QUESTION NO: 1
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)
Correct Answer: D,E
Vote an answer
QUESTION NO: 2
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.)
Correct Answer: A,C
Vote an answer
QUESTION NO: 3
You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?
You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?
Correct Answer: C
Vote an answer
QUESTION NO: 4
You are in the process of creating a virtual private catalog in your Oracle Database 11g 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?
You are in the process of creating a virtual private catalog in your Oracle Database 11g 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?
Correct Answer: C
Vote an answer
QUESTION NO: 5
View the Exhibit and examine the output.
You executed the following command to enable Flashback Data Archive on the
EXCHANGE_RATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIVE;
What is the outcome of this command?
View the Exhibit and examine the output.
You executed the following command to enable Flashback Data Archive on the
EXCHANGE_RATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIVE;
What is the outcome of this command?
Correct Answer: C
Vote an answer
QUESTION NO: 6
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance :
SQL> shutdown immediate;
What is the result of executing this command?
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance :
SQL> shutdown immediate;
What is the result of executing this command?
Correct Answer: D
Vote an answer
QUESTION NO: 7
To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:
BEGIN dbms_advisor.create_task(dbms_advisor.sqlaccess_advisor,'TASK1'); END; /
BEGIN dbms_advisor.set_task_parameter('TASK1','ANALYSIS_SCOPE','ALL'); dbms_advisor.set_task_parameter('TASK1','MODE','COMPREHENSIVE');
END; /
BEGIN
dbms_advisor.execute_task('TASK1')
dbms_output.put_line(dbms_advisor.get_task_script('TASK1')); END; /
The blocks of code execute successfully; however, you do not get the required outcome. What could be the reason?
To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:
BEGIN dbms_advisor.create_task(dbms_advisor.sqlaccess_advisor,'TASK1'); END; /
BEGIN dbms_advisor.set_task_parameter('TASK1','ANALYSIS_SCOPE','ALL'); dbms_advisor.set_task_parameter('TASK1','MODE','COMPREHENSIVE');
END; /
BEGIN
dbms_advisor.execute_task('TASK1')
dbms_output.put_line(dbms_advisor.get_task_script('TASK1')); END; /
The blocks of code execute successfully; however, you do not get the required outcome. What could be the reason?
Correct Answer: C
Vote an answer
QUESTION NO: 8
You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?
You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?
Correct Answer: C
Vote an answer
QUESTION NO: 9
USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methods would you use to achieve this? (Choose all that apply.)
USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methods would you use to achieve this? (Choose all that apply.)
Correct Answer: A,D,E
Vote an answer
QUESTION NO: 10
You are managing an Oracle Database 11g 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 11g 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.)
Correct Answer: B,D
Vote an answer