Oracle 11gocmu Actual Free Exam Questions & Community Discussion
What is the purpose of the list expired backup command?
Correct Answer: D
Vote an answer
If you are going to run a TSPITR recovery, which view will help you to determine which objects will be lost during the TSPITR?
Correct Answer: B
Vote an answer
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.)
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
Which two statements are true regarding the execution of the above command? (Choose two.)
Correct Answer: A,C
Vote an answer
You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g:
1.Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.
2.Load these plans from the STS into the SQL plan baseline immediately after the upgrade.
What is the reason for performing these activities?
1.Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.
2.Load these plans from the STS into the SQL plan baseline immediately after the upgrade.
What is the reason for performing these activities?
Correct Answer: C
Vote an answer
View the Exhibit.
Examine the following command that is executed for the TRANSPORT table in the SH
schema:
SQL> SELECT DBMS_STATS.CREATE_EXTENDED_STATS('sh', 'customers_obe',
'(country_id, cust_state_province)') FROM dual; Which statement describes the significance of this command?
Examine the following command that is executed for the TRANSPORT table in the SH
schema:
SQL> SELECT DBMS_STATS.CREATE_EXTENDED_STATS('sh', 'customers_obe',
'(country_id, cust_state_province)') FROM dual; Which statement describes the significance of this command?
Correct Answer: D
Vote an answer
True or false: RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.
Correct Answer: B
Vote an answer
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?
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?
Correct Answer: C
Vote an answer
Which command is used to begin a tablespace point-in-time recovery?
Correct Answer: A
Vote an answer
0
0
0
10