최신Oracle Database 11g: New Features for Administrators - 1Z1-050무료샘플문제
문제1
Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)
Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)
정답: B,C
문제2
You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:
ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h';
To which disks in the disk group will the new value be applicable?
You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:
ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h';
To which disks in the disk group will the new value be applicable?
정답: A
문제3
You are in the process of creating a virtual private catalog in your Oracle Database 11 g database. The PROD1 , PROD and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who own the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11 g 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?
You are in the process of creating a virtual private catalog in your Oracle Database 11 g database. The PROD1 , PROD and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who own the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11 g 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?
정답: C
문제4
You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB. You issued the following RMAN commands to create a duplicate database: RMAN> CONNECT target sys/sys@APPPROD RMAN> DUPLICATE TARGET DATABASE
TO dupdb FROM ACTIVE DATABASE DB_FILE_NAME_CONVERT '/oracIe/oradata/prod/1, '/scratch/oracIe/oradata/dupdb/1 SPILE PARAMETER_VALUE_CONVERT'/oracle/oradata/prod/1, '/scratch/oracIe/oradata/dupdb/1 SET SGA_MAX_SIZE = '300M1 SET SGA_TARGET = '250M' SET LOG_FILE_NAME_CONVERT '/oracle/oradata/prod/redo/', '/scratch/oracIe/oradata/dupdb/redo/1;
Which three are the prerequisites for the successful execution of the above command? (Choose three.)
You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB. You issued the following RMAN commands to create a duplicate database: RMAN> CONNECT target sys/sys@APPPROD RMAN> DUPLICATE TARGET DATABASE
TO dupdb FROM ACTIVE DATABASE DB_FILE_NAME_CONVERT '/oracIe/oradata/prod/1, '/scratch/oracIe/oradata/dupdb/1 SPILE PARAMETER_VALUE_CONVERT'/oracle/oradata/prod/1, '/scratch/oracIe/oradata/dupdb/1 SET SGA_MAX_SIZE = '300M1 SET SGA_TARGET = '250M' SET LOG_FILE_NAME_CONVERT '/oracle/oradata/prod/redo/', '/scratch/oracIe/oradata/dupdb/redo/1;
Which three are the prerequisites for the successful execution of the above command? (Choose three.)
정답: A,D,E
문제5
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?
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?
정답: C
문제6
Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)
Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)
정답: A,D
문제7
What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration?
What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration?
정답: A
문제8
You are managing an Oracle Database 11 g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective? (Choose all that apply.)
You are managing an Oracle Database 11 g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective? (Choose all that apply.)
정답: A,B,C
설명: (ITDumpsKR 회원만 볼 수 있음)
문제9
You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup? (Choose two.)
You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup? (Choose two.)
정답: B,D
문제10
Which statements are true regarding the Query Result Cache? (Choose all that apply.)
Which statements are true regarding the Query Result Cache? (Choose all that apply.)
정답: A,D
문제11
You executed the following PL/SQL block successfully:
VARIABLE tname VARCHAR2(20)
BEGIN
dbms_addm.insert_finding_directive (NULL, DIR_NAME=>'Detail CPU Usage1,
FINDING_NAME=>'CPU Usage1,
MIN_ACTIVE_SESSIONS=>0,MIN_PERC_IMPACT=>90);
:tname := 'database ADDM task4';
dbms_addm.analyze_db(:tname, 150,162);
END;
/
Then you executed the following command:
SQL> SELECT dbms_addm.get_report(:tname) FROM DUAL;
The above command produces Automatic Database Diagnostic Monitor (ADDM)
analysis____.
You executed the following PL/SQL block successfully:
VARIABLE tname VARCHAR2(20)
BEGIN
dbms_addm.insert_finding_directive (NULL, DIR_NAME=>'Detail CPU Usage1,
FINDING_NAME=>'CPU Usage1,
MIN_ACTIVE_SESSIONS=>0,MIN_PERC_IMPACT=>90);
:tname := 'database ADDM task4';
dbms_addm.analyze_db(:tname, 150,162);
END;
/
Then you executed the following command:
SQL> SELECT dbms_addm.get_report(:tname) FROM DUAL;
The above command produces Automatic Database Diagnostic Monitor (ADDM)
analysis____.
정답: A
문제12
Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.)
Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.)
정답: C,D