Observe the information in the columns： 1. The SGA                 a. Text and parsed forms of all SQL statements 2. The cursor state       b. Run-time memory values for the SQL statement， such as rows retrieved 3. User-session data    c. Security and resource usage information 4. The stack space      d. Local variables for the process  Which option has the correct match between the memory areas and their contents（）

View the Exhibit to observe the roles assigned to the SLP_REP user.  Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SLP_REPuser（）

单选题查看答案

View the Exhibit to observe the roles assigned to the SL_REP user.  Which statement is true about theassignment of the SELECT_CATALOG_ROLE role to the SL_REP user（）

单选题查看答案

View the Exhibit and examine the characteristics of the USERS tablespace.  You observe that a large volume of inserts and deletes are happening on the TRANS table in the USERS tablespace and you suspect that the TRANS table is fragmented.  Which advisory component would you refer to， in order to find information about table fragmentation？（）

单选题查看答案

You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files：  $ rman target /  What would be the effect of this command？（）

单选题查看答案

Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade，you observe that the DBA executes the following script：   SQL> @utlrp.sql   What is the significance of executing this script？（）  

单选题查看答案

Exhibit： View the Exhibit to see the information on existing tablespaces of the PROD database.  You observe that a large volume of INSERTs and DELETEs are happening on the TRANS table residing in the USERS tablespace， and you suspect that the TRANS table is fragmented. Which advisory component would you refer to， in order to find the information about table fragmentation？（）

单选题查看答案

View the Exhibit to see the output of queries on DATABASEPROPERTIES and DBAUSERS. You observe that the current default permanent tablespace of the database is  running out of space and you decide to change it to NEWDEFTBSP. You create a new user， USER04， after changing the default permanent tablespace of the database. What would be the new user’s default tablespace？（）

单选题查看答案

Observe the following warning in an RMAN session of your database instance：   WARNING:// new failures were found since last LIST FAILURE command   Which statement describes the scenario that must have produced this warning？（）

单选题查看答案

Observe the information in the columns：  1： The SGA     a. Text and parsed forms of all SQL statements  2： The cursor state   b. Run-time memory values for the SQL statement， such as rows retrieved  3： User-session data   c. Security and resource usage information  4：The stack space   d. Local variables for the process  Which option has the correct match between the memory areas and their contents（）

单选题查看答案