Oracle 1z0-063 問題集

質問 1：
Which two components are contained only in CDB$ROOT? (Choose two.)
A. PDB service names
B. database links between PDBs in the CDB
C. the unified audit trail
D. resource manager plans for each PDB in the CDB
E. the default TEMP tablespace for the entire CDB
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
RMAN is configured to create backupset backups for your database. You issue the command to back up the database:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which two statements are true about the backup performed by the command? (Choose two.)
A. Only the used blocks in the data files are backed up.
B. It backs up all the data files and deletes obsolete backups after the backup is complete.
C. It backs up all the archived log files and deletes the ones that were just backed up.
D. It backs up only those archived log files that are not backed up at least once.
E. It backs up all archived redo log files and online log files and deletes the archived log files after the backup is complete.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which two statements are true about Flashback Version Query? (Choose two.)
A. It can be used only if Flashback Data Archive is enabled for a table.
B. It retrieves all versions of rows that exist in a time interval, including the start time and end time.
C. It can be used to create views.
D. The result of a query can be used as part of a DML statement.
E. It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.
正解：B,E

質問 4：
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

質問 5：
A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.
Which table organization allows for generating the bills with minimum degree of row sorting?
A. a partitioned table
B. a heap table with a rowid column
C. an index cluster
D. a hash cluster
E. a sorted hash cluster
正解：E

質問 6：
You are administering a multitenant container database (CDB) that contains two pluggable databases (PDBs), PDB1 and PDB2. You are connected to PDB2 as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB modifiable.
As the user SYS, execute the following command on PDB2:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;
Which statement is true about the result of this command?
A. The STATISTICS_LEVEL parameter is set to ALL only for PDB2 when it is reopened.
B. The STATISTICS_LEVEL parameter is set to ALL when the root database is restarted.
C. The statement is ignored because there is no SPFILE for a PDB.
D. The STATISTICS_LEVEL parameter is set to ALL when any of the PDBs is reopened.
正解：A