Oracle 1z0-034 問題集

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

質問 2：
Examine the following RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which perquisite must be met before accomplishing the backup?
A. No setup is required as it is a default encryption method.
B. Provide a password for the encryption.
C. Both Oracle wallet and password must be set up for the encryption.
D. Set up an Oracle wallet for the encryption.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.
Which method must you use to recover the lost data?
A. Complete Recovery with online redo log
B. Tablespace Point-in-Time Recovery (TSPITR)
C. Complete Recovery with archived redo log
D. Incomplete Recovery with system change number (SCN)
正解：B

質問 4：
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode. Which two statements are true in this scenario?
A. You must configure the flash recovery area (fast recovery area) for the database.
B. You must shut down the database instance to perform the backups.
C. All the previous closed database backups including control files become invalid after you configure the database to ARCHIVELOG mode.
D. You can perform complete database backups without closing the database.
正解：C,D

質問 5：
Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.)
A. It bypasses the OS file system cache.
B. File systems need not be mounted by the kernel NFS system when being served through Direct NFS.
C. A separate NFS interface is required for use across Linux, UNIX, and Windows platforms.
D. It uses the operating system kernel NFS layer for user tasks and network communication modules.
E. Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)
A. The ADR can be used for problem diagnosis even when the database instance is down
B. The ADR base keeps all diagnostic information in binary format
C. The ADR can be used for problem diagnosis only when the database is open
D. SQL*Plus provides the ADRI script, which can be used to work with ADR
E. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
F. The ADR base is shared across multiple instances
正解：A,F

質問 7：
You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.
You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows: You then issue the following statement to recover the table:
SQL> SELECT object_name, original_name, droptime FROM recyclebin;

What would be the outcome of the precedent statement?
A. It retrieves the version of the table for which undo information is available
B. It retrieves the latest version of the table from the recycle bin
C. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column
D. It retrieves the oldest version of the table from the recycle bin
正解：B

質問 8：
Your production database is functional on the SHOST1 host. You are backing up the production database by using Recovery Manager (RMAN) with the recovery catalog. You want to replicate the production database to anther host, SHOST2, for testing new applications.
After you ensured that the backups of the target database are accessible on the new host, what must you do to restore and recover the backup for the test environment?
A. Restoring the control file from the backup by using the NOCATALOG option to restore, and recovering the data files
B. Restoring the data files from the backup by using the recovery catalog to recover the files, and using the SWITCH command to change the location.
C. Restoring the data files by using the NOCATALOG option and using the SET NEWNAME command to change the location
D. Restoring the server parameter file from the backup by using the recovery catalog to restore,
正解：A
解説: (Topexam メンバーにのみ表示されます)