1z1-497無料問題集「Oracle Database 12c Essentials」

質問 1

John is a CDB administrator, and Mike and Tim are PDB administrators of their respective databases- John takes a complete CDB backup by using RMAN>Backup Database. Mike and Tim may need point-in-time recovery of their PDBs. Which statement is true?

（A）Mike and Tim need to individually take backups of their respective PDBs, because CDB-level backup does not include PDB data dictionary objects.

（B）Mike and Tim do not need to worry, because recovery of individual PDBs is possible.

（C）Recovery of individual PDBs is not possible, because John did not back up by using RMAN>Backup Pluggable database pdb1 pdb2. However, complete CDB recovery is still possible.

（D）Recovery of individual PDBs is not possible at all.

正解：C 解答を投票する

質問 2

Examine the commands:
SQL> CONNECT sys@CDBl AS SYSDBA
$QL>STARTUP MOUNT
SQL> ALTER DATABASE cdbl MOUNT;
Which four options represent what happens when these commands are executed?

（A）The PDBs are mounted, and opened in READ WRITE mode, while the seed is opened In READ ONLY mode.

（B）The root is opened.

（C）The PDBs are mounted.

（D）The CDB control files are opened for the instance.

（E）The instance is started.

（F）The root is mounted.

（G）The PDBs are mounted, and the seed is opened in READ ONLY mode.

正解：C、D、E、F 解答を投票する

質問 3

Several tables are accidentally deleted from a PDB. Which database would you immediately connect to, and as which user, to recover these tables?

（A）the CDB as the ROOT user

（B）the PDB as the PDB Admin user

（C）the CDB as the CDBADMIN user

（D）the PDB as the ROOT user

正解：B 解答を投票する

質問 4

A DBA informs you that an Oracle instance has started. What does this imply?

（A）Only SGA has been allocated for the database.

（B）Users can access the data in the database.

（C）Only background and user processes are running.

（D）Memory areas have been allocated and background processes have been started.

正解：D 解答を投票する

質問 5

Which statement about Storage Snapshot Optimization is correct?

（A）It enables you to use RMAN to take a storage snapshot of your database. The database doesn't have to be in BACKUP mode. You can then use the snapshot to recover all or part of the database.

（B）It enables you to use third-party technologies to take a storage snapshot of your database. The database must be in BACKUP mode. You can then use the snapshot to recover all or part of the database.

（C）It enables you to use third-party technologies to take a storage snapshot of your database without putting the database in BACKUP mode. You can then use the snapshot to recover all or part of the database.

（D）It enables you to use RMAN to take a storage snapshot of your database. The database must be in BACKUP mode. You can then use the snapshot to recover all or part of the database.

正解：C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 6

You need to recover a database running In NOARCHIVELOG mode. Which two statements are true in this scenario?

（A）Only consistent backups can be used for restoring a database in NOARCHIVELOG mode.

（B）Media recovery is possible in most cases.

（C）You can perform complete recovery by using the command:
RESTORE DATABASE
FROM TAG"consistent_whole_backup";
RECOVER DATABASE;

（D）You can perform incomplete recovery by using the command:
RESTORE DATABASE;
FROM TAG "consistent_whole_backup";
RECOVER DATABASE NOREDO;

正解：A、D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 7

Which three statements are true about a database instance that has mounted a database but has not opened it?

（A）System Global Area (SGA) is allocated and background processes are started.

（B）Instance recovery is performed for the database.

（C）A control file is open.

（D）Data files are open in read-only mode.

（E）An alert log and trace files are open.

（F）System administrators and users with the CREATE SESSION system privilege may connect to the instance.

正解：A、C、E 解答を投票する

質問 8

Which three statements represent the difference between a container database (CDB)and a non-container database?

（A）In a newly created non-CDB that does not yet contain user data, the data dictionary contains only system metadata. When application users create their own objects, this metadata is mixed with the system metadata. In a CDB, the data dictionary metadata is split between the root and the PDBs. The data dictionary in the PDB contains pointers to the data dictionary in the root.

（B）A container database has exactly one seed PDB, and a non-container database has no seed PDB.

（C）You are allowed to create only a single HR user in a non-CDB database. This restriction is identical for a CDB database.

（D）New views are introduced. Next to DBA_views, AIL_-views, and USER_-views, there are CDB_-views. Both CDB and non-CDB databases can access this information.

（E）Every PDB in a CDB has its own control file. A non-CDB, which has no containers, needs only one control file.

正解：A、B、D 解答を投票する

質問 9

An Oracle instance is a combination of______.

（A）System Global Area (SGA) and background processes

（B）System Global Area (SGA), server processes, and background processes

（C）database files and parameter file (initialization parameter file or server parameter file)

（D）a listener process, server processes, and background processes

（E）database files, System Global Area (SGA), and background processes

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 10

Which two statements describe data dictionary views?

（A）They are owned by the SYS user.

（B）They speed up query and data manipulation language (DML) operations.

（C）They are based on virtual tables.

（D）The VSFIXED_TABLEview can be queried to list the names of these views.

（E）They are stored in the SYSTEM tablespace.

正解：A、E 解答を投票する

1z1-497 無料問題集「Oracle Database 12c Essentials」

弊社を連絡する

関連リンク

トップ試験