Oracle 1Z0-050 問題集

質問 1：
Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.)
A. The BACKGROUND_DUMP_DEST initialization parameter overrides the DIAGNOSTIC_DEST initialization parameter for the location of the alert log file.
B. If the environmental variable ORACLE_BASE is set, then DIAGNOSTIC_DEST is set to $ORACLE_BASE.
C. A single ADR can support multiple ADR homes for different database instances.
D. The alert files are stored in XML file format in the TRACE directory of each ADR home.
正解：B,C

質問 2：
In which situations will the ASM metadata backup help you recover the ASM disk in a disk group? (Choose all that apply.)
A. wnen one or more file directory paths are accidentally deleted from an ASM disk group
B. when one or more disks in an ASM disk group are lost
C. when the data file on an ASM disk group gets corrupted
D. when one of the disks in a disk group is accidentaly unplugged
正解：A,B

質問 3：
You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?
A. Create a repeating baseline template.
B. Insert a finding directive for future ADDM tasks.
C. Change the RETENTION setting for the AWR snapshots to 7 days on Monday.
D. Create and populate a SQL Tuning Set from the AWR on every Monday.
正解：A

質問 4：
An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the
ORDERS table using the following command:
SQL>CREATE INDEX ord_custname_ix ON orders(custname);
The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause.
You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.
Which is the most efficient method of performing this task?
A. making the index invisible
B. using the MONITORING USAGE clause for the index
C. making the index unusable
D. disabling the index
正解：A

質問 5：
Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g? (Choose all that apply.)
A. You can track the Service Request (SR) and implement repairs.
B. You can manually run health checks to gather diagnostic data for a problem.
C. You can package and upload diagnostic data to Oracle Support.
D. Generate reports on data failure such as data file failures,
正解：A,B,C

質問 6：
View the Exhibit exhibit1.

In the CUSTOMERS_OBE table, when the value of CUST_STATE_PROVINCE is "CA",
the value of COUNTRYJD is "US."
View the Exhibit exhibit2 to examine the commands and query plans.
The optimizer can sense 8 rows instead of 29 rows, which is the actual number of rows in the table. What can you do to make the optimizer detect the actual selectivity?
A. Set the STATISTICS_LEVEL parameter to TYPICAL.
B. Change the STALE_PERCENT value for the CUSTOMERS_OBE table.
C. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE.
D. Create extended statistics for the CUST_STATE_PROVINCE and CUSTOMERSJDBE columns.
正解：D

質問 7：
You want to take the backup of the USERS tablespace. It has a single data file of 900 MB.. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup, you issued the following RMAN command:
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
Which two statements are true regarding the execution of the above command? (Choose two.)
A. Three channels for the tape drive must be configured by setting the parallelism to three.
B. The RMAN parallelizes the backup although the parallelism is not set for a channel,
C. The backup piece size will be limited to 300 MB.
D. The operation is accomplished using the default channel available.
正解：C,D

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