单选题You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）A V$DATABASE B DBA_TABLES C SYSAUD$ D EMP

第1题：

Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?（）

• A、All objects in the database
• B、Tables owned by SYS and SYSTEM
• C、Data dictionary tables
• D、NCHAR columns
• E、CHAR columns

第2题：

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

第3题：

第4题：

You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package. Which statement is true regarding the ACL created?（）

• A、It is a list of remote database links stored in the XML file that are available to the users of the database.
• B、It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.
• C、It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.
• D、It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.

第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 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.

第6题：

You executed the following command to start the database：  SQL> STARTUP  ORACLE instance started.  Total System Global Area 281018368 bytes  Fixed Size 789000 bytes  Variable Size 229635576 bytes  Database Buffers 50331648 bytes  Redo Buffers 262144 bytes ORA-00205： error in identifying controlfile， check alert log for more info  Which view would you query at this stage to investigate this missing control file？（）

• A、V$INSTANCE
• B、V$CONTROLFILE
• C、DBA_CONTROL_FILES
• D、V$DATABASE_PROPERTIES
• E、V$CONTROLFILE_RECORD_SECTION

第7题：

You work as a database administrator for Supportcenter.cn. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）

• A、The trace file
• B、The fixed views
• C、The data dictionary views
• D、The operating system log fields
• E、The dynamic performance views.

第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题：

What does the Metadata Application Programming Interface （API） allow you to do？（）

• A、Repair damaged data dictionary entries.
• B、Delete data dictionary information about database objects you no longer need.
• C、Extract data definition commands from the data dictionary in a variety of formats.
• D、Prepare pseudocode modules for conversion to Java or PL/SQL programs with a Metadata code generator

第10题：

You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）

• A、Library cache 
• B、Row cache
• C、Dictionary cache 
• D、Large area 
• E、Buffer cache