单选题In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? （）A DBA_USERS B DBA_OBJECTS C DBA_TS_QUOTAS D DBA_TAB_PRIVS

第1题：

You are trying to determine how many disk sorts are happening on the database right now. Which of the following dictionary tables would you use to find that information?（）

• A、V$SESSION 
• B、V$SYSSTAT 
• C、DBA_SEGMENTS 
• D、V$SORT_USAGE

第2题：

A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance？（）

• A、Data Pump
• B、Oracle Net Manager
• C、Oracle Enterprise Manager
• D、Oracle Universal Installer （OUI）
• E、Database Configuration Assistant （DBCA）

第3题：

第4题：

A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL> connect smith/smith  Connected.  SQL> SELECT * FROM v$session；  SELECT * FROM v$session *  ERROR at line 1：  ORA-00942： table or view does not exist  Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）

• A、granting SELECT privilege to SMITH on V$SESSION
• B、granting SELECT privilege to SMITH on V_$SESSION
• C、asking the user SMITH to run the catalog.sql script
• D、granting SELECT privilege to SMITH on V$FIXED_TABLES
• E、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
• F、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created

第5题：

You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created.You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view?（）

• A、Use the DESCRIBE command in the EMP_DEPT VU view.
• B、Use the DEFINE VIEW command on the EMP_DEPT VU view.
• C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view.
• D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
• E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
• F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

第6题：

You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this？（）

• A、enable index monitoring and query the DBA_OBJECTS view
• B、enable index monitoring and query the DBA_INDEXES view
• C、enable index monitoring and query the V$OBJECT_USAGE view
• D、enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view

第7题：

You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definition of the view?（）

• A、Use the DESCRIBE command on the EMP_DEPT_VU view.
• B、Use the DEFINE VIEW command on the EMP_DEPT_VU view.
• C、Use the DESCRIBE VIEW command on the EMP_DEPT_VU view.
• D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
• E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
• F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

第8题：

In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? （）

• A、DBA_USERS 
• B、DBA_OBJECTS 
• C、DBA_TS_QUOTAS 
• D、DBA_TAB_PRIVS 

第9题：

On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup. Which flashback feature would you use？（）

• A、Flashback Drop
• B、Flashback Table
• C、Flashback Database
• D、Flashback Version Query
• E、Flashback Transaction Query

第10题：

You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）

• A、 Query the V$FLASHBACK_DATABASE_LOG view.
• B、 Query the V$FLASHBACK_DATABASE_STAT view.
• C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
• D、 Query the V$RECOVERY_FILE_DEST view.