Oracle 1z0-063 問題集

質問 1：
Identify three scenarios in which RMAN will use backup sets to perform active database duplication. (Choose three.)
A. when the number of auxiliary channels allocated is equal to or greater than the number of target channels
B. when the DUPLICATE ... from ACTIVE DATABASE command contains the SECTION SIZE clause
C. when you perform active database duplication on a database with flashback disabled
D. when you specify SET ENCRYPTION before the DUPLICATE ... FROM ACTIVE DATABASE command
E. when you perform active database duplication on a database that has read-only tablespaces
正解：A,B,D

質問 2：
Which two statements are true about making RMAN image copies of a database? (Choose two.)
A. They can only be written to disk.
B. They can be made only when the database is running in NOARCHIVELOG mode.
C. They consist of all used and unused blocks in the data files.
D. They can be made only when the database is in MOUNT state.
E. They can be made only when the database is running in ARCHIVELOG mode.
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
A database is running in ARCHIVELOG mode. The database contains locally managed tablespaces. Examine the RMAN command:
RMAN> BACKUP
AS COMPRESSED BACKUPSET
SECTION SIZE 1024M
DATABASE;
Which statement is true about the execution of the command?
A. The backup succeeds and only the used blocks are backed up with a maximum backup piece size of
1024 MB.
B. The backup succeeds only if all the tablespaces are locally managed.
C. The backup succeeds only if the RMAN default device for backup is set to disk.
D. The backup fails because you cannot specify section size for a compressed backup.
正解：A

質問 4：
Your database has a table CUSTOMERS that contains the columns CUST_NAME, AMT_DUE, and OLD_STATUS.
Examine the commands executed and their output:

Why is it that only one update is listed by the Flashback Version Query?
A. The undo data that existed for versions of rows before the change to the table structure is invalidated.
B. The DB_FLASHBACK_RETENTION_TARGET parameter is set to a lower value and the undo data pertaining to the first transaction is flushed out.
C. Flashback Data Archive is full after the first update statement.
D. Supplemental logging is not enabled for the database.
E. Undo retention guarantee is not enabled.
正解：A

質問 5：
You are connected to a pluggable database (PDB) as a common user with the SYSDBA privilege. The PDB is open and you issue the SHUTDOWN IMMEDIATE command.
What is the outcome?
A. The command results in an error because the PDB can be shut down only by a local user.
B. The command executes only if the common user is granted the SET CONTAINER privilege for the PDB.
C. The PDB is closed and left in the mount state.
D. The PDB is closed and left in the unmount state.
正解：D

質問 6：
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the db_smart_flash_file parameter:
DB_FLASH_CACHE_FILE= ' /dev/f lash_device_1',' /dev/f lash_device_2'
How should the D3_flash_cache_size be configured to use both devices?
A. Set D3_FLASH_CACHE_SIZE=64G, 64G.
B. db_flash_cache_SI2E is automatically configured by the instance at startup.
C. Set DB_FLASH_CACHE_SIZE=64G.
D. Set D3_FLASK_CACKE_SI2E=128G.
正解：A
解説: (Topexam メンバーにのみ表示されます)