Oracle 1z0-063 問題集

質問 1：
You use RMAN to take regular backups for your database.
Examine the RMAN commands:
RMAN> CROSSCHECK BACKUP;
RMAN> DELETE EXPITED BACKUP;
Which statement is true?
A. All backups that have exceeded the age set by the RMAN retention policy are deleted.
B. All backups and archived redo log files that are not required for the recovery are deleted and the repository is updated.
C. All metadata, for backups and archived redo log files that are recorded in the repository but do not exist on disk or media, is deleted.
D. All metadata pertaining to backups and archived redo log files that have exceeded the age set by the RMAN retention policy are deleted from the repository.
正解：C

質問 2：
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)
A. The ADR base is shared across multiple instances.
B. The ADR can be used for problem diagnosis even when the database instance is down.
C. The ADR is used to store Automatic Workload Repository (AWR) snapshots.
D. The ADR base keeps all diagnostic information in binary format.
E. The ADR can be used to store statspack snapshots to diagnose database performance issues.
正解：A,B

質問 3：
You want to create a database with a block size other than the default 8 KB by using the Database Configuration Assistant (DBCA).
Which option should you use?
A. A Data Warehouse database template
B. A file system for storage of data files
C. Automatic Storage Management (ASM) for storage of data files
D. A custom database template
正解：D

質問 4：
Your database is running in ARCHIVELOG mode and flashback is enabled.
In which scenario must you use RMAN backups for recovering tables and table partitions?
A. when recovering dropped tables that are present in the recyclebin
B. when recovering a table to a point in time
C. when recovering a table that has been logically corrupted
D. when recovering data that was lost after a DDL operation modified the structure of a table
E. when recovering the data of a table to the desired point in time, which is more recent than the oldest available undo
正解：B

質問 5：
One of your multitenant container databases (CDB) contains two pluggable databases (PDBs) called PDB1 and PDB2.
You connect to PDB2 as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB modifiable.
As the user SYS, you execute this command successfully on PDB2:
SQL> ALTER SET STATISTICS_LEVEL=ALL SID='*' SCOPE=BOTH;
Which two statements are true about the result of this command?
A. The data dictionary in CDB$ROOT is updated.
B. The STATISTICS_LEVEL parameter is set to ALL in memory for both PDBs.
C. The STATISTICS_LEVEL parameter is set to ALL in memory only for PDB2.
D. The data dictionary in PDB2 is updated.
E. The SPFILE is updated.
正解：C

質問 6：
Which three statements are true about a job chain? (Choose three.)
A. It can be executed using event-based or time-based schedules.
B. It cannot have more than one dependency.
C. It can contain a nested chain of jobs.
D. It can be used to implement dependency-based scheduling.
E. It cannot invoke the same program or nested chain in multiple steps in the chain.
正解：A,C,D