Oracle 1z0-063 問題集

質問 1：
Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time.
Examine the steps to recover this table from an RMAN backup:
1. Determine which backup contains the table that needs to be recovered.
2. Issue the RECOVER TABLE RMAN command with an auxiliary destination defined and the point in time specified.
3. Import the Data Pump export dump file into the auxiliary instance.
4. Create a Data Pump export dump file that contains the recovered table on a target database.
Identify the required steps in the correct order.
A. 1, 2
B. 1, 4, 3
C. 1, 4, 3, 2
D. 1, 2, 4
正解：A

質問 2：
Your database instance is started using an SPFILE. You are connected to CDB$ROOT, as a DBA.
You issue:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;
Which two statements are true about the STATISTICS_LEVEL parameter? (Choose two.)
A. It is immediately set to ALL only for CDB$ROOT.
B. It is immediately set to ALL in the SPFILE and the CDB instance.
C. It is set to ALL for all PDBs only in the SPFILE.
D. It is immediately set to ALL in only those pluggable databases (PDBs) where the value is set to TYPICAL.
E. It is immediately set to ALL in all PDBs where the STATISTICS_LEVEL parameter is not set.
正解：B,D

質問 3：
In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file.
What precaution must you take for the read-only tablespaces before performing an incomplete recovery?
A. All the read-only tablespaces should be restored separately.
B. All the read-only tablespaces should be renamed to have the MISSINGnnnn format.
C. All the read-only tablespaces should be taken offline.
D. All the read-only tablespaces should be made online with logging disabled.
正解：C

質問 4：
Which two statements are true regarding Oracle Data Pump? (Choose two.)
A. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
B. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.
C. EXPDP and IMPDP are the client components of Oracle Data Pump.
D. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
E. Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.
正解：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 database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
Which action must you take for recovery?
A. Restore all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.
B. Restore the control file and all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.
C. Restore the data file, recover it by using the recover datafilenoredo command, and use the resetlogs option to open the database.
D. Restore all the data files, recover them by using the recover database command, and open the database.
正解：B