Oracle 1z0-034 問題集

質問 1：
Your database is running in ARCHIVELOG mode. You have been taking backups of all the data files and control files regularly.
You are informed that some important tables in the BILLING tablespace have been dropped on February 28, 2007 at 10.30 AM and must be recovered.
You decide to perform an incomplete recovery using the following command:
SQL> RECOVER DATABASE UNTIL TIME '2007-02-28:10:15:00';
Identify the files that must be restored to recover the missing tables successfully.
A. Restore the backup of all the data files.
B. Restore the backup of all the data files belonging to the tablespace containing the dropped tables.
C. Restore the backup of only the data files that contain the dropped tables.
D. Restore the backup of all the data files and the control file.
正解：A

質問 2：
You executed the following commands:
SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;
SQL> EXECUTE DBMS_STATS. SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false');
SQL> EXECUTE DBMS_STATS. GATHER_TABLE_STATS ('SH' , 'CUSTOMERS');
Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?
A. The statistics are treated as the current statistics by the optimizer for the current sessions only.
B. The statistics are treated as the current statistics by the optimizer for all sessions.
C. The statistics are stored in the pending statistics table in the data dictionary.
D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.
正解：C

質問 3：
Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS.
Which two actions will permit the TSPITR to work? (Choose two.)
A. Taking the MASTERTBS tablespace offline
B. Dropping the relationship between the tables
C. Putting the MASTERTBS tablespace in read-only mode
D. Adding the MASTERTBS tablespace to the recovery set
正解：B,D

質問 4：
You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database l1g database .The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER.CATOWNER executes the following command to grant privileges to a new user vpc1 using Oracle Database 11g RMAN executables:
RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;
Then you issue the following commands:
RMAN> CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"
What is the outcome of the above commands?
A. They execute and create a virtual catalog for pre-Oracle 11g clients.
B. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.
C. They produce an error because you need to connect to the target database to execute this packaged procedure.
D. They produce an error because PROD1 and PROD2 databases belong to the older version.
正解：A

質問 5：
Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace. A user issues a query on the orders table and receives the following error:
ERROR at line I:
ORA-0I565: error in identifying file '/u01/app/oracle/oradata/TEST/temp01.tmp'
ORA-27037: unable to obtain file status
What would be the most efficient way to rectify this error?
A. Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.
B. Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.
C. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
D. Allow the database to continue running, drop the temp01.tmp temporary file, and then re-create it with new tempfiles.
正解：B

質問 6：
Which two statements are true about a duplicate database that is created by using the DUPLICATE command in RMAN? (Choose two.)
A. It is created by using backups and archived redo log files from the target database.
B. It is opened in RESTRICT mode after a duplicating operation.
C. It is created with the same database identifier (DBID) as that of target database.
D. It is a copy or a subset of the target database.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIEVELOG mode? (Choose all that apply.) (Choose all that apply.)
A. setting the FAST_START_MTTR_TARGET to set the mean time to recover
B. using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
C. setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
D. using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area.
正解：B,D

質問 8：
Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)
A. direct path load of data from external files
B. all DDL statements having bind variables
C. flashback query
D. distributed transactions
E. logging in and logging out of sessions
正解：B,E