单选题You need to allow the user to toggle between automatic query and no automatic query using a pop-up menu. Which built-in would you use in the menu item command to obtain the relationship name? （）A GET_RELATION_PROPERTY B SET_RELATION_PROPERTY C GET_BLOC

第1题：

You work as a database administrator for Certkiller .com. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）

• A、use enterprise manager
• B、use DBMS_SQL package
• C、use DBMS_AWR package
• D、use PRVT_WORKLOAD package
• E、query the AWR snapshot repository objects
• F、use DBMS_WORKLOAD_REPOSITORY package

第2题：

You are maintaining a database of credit card transactions. You want the data to be returned automatically in the chronological order of the credit card numbers without using the ORDER BY clause in the query. Which type of cluster will you use to obtain the desired result？（）  

• A、 Hash cluster
• B、 Index cluster
• C、 Sorted hash cluster
• D、 Real Application cluster

第3题：

You want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）

• A、 rman TARGET / NOCATALOG
• B、 rman TARGET sys/password
• C、 rman TARGET sys/password AS SYSDBA
• D、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

第4题：

You need to change the text of a pop-up menu that appears when a user right clicks the mouse in the EMP_DATA data block. Where could you find the node for the pop-up menu in the Object Navigator?（）

• A、Built-in Packages 
• B、Menus 
• C、PL/SQL Libraries 
• D、Object Libraries 
• E、Form Module

第5题：

You established access to menu modules using roles. You have allowed the sales role to access the menu module, but prevented access to the Update menu item. Which item property would you alter to gray out the menu option for the role?（）

• A、Item Roles. 
• B、Menu Item Roles. 
• C、Display without Privilege. 
• D、Use Security. 
• E、Command Type.

第6题：

You want users to log on to Active Directory by using a new User Principal Name （UPN）.    You need to modify the UPN suffix for all user accounts.  Which tool should you use（）

• A、Dsmod
• B、Netdom
• C、Redirusr
• D、Active Directory Domains and Trusts

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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.

第14题：

Which of the following would you use to enable automatic media recovery for a database？（）

• A、SET AUTORECOVERY ON
• B、SET RECOVERY ON
• C、SET AUTO ON
• D、You cannot enable automatic media recovery.

第15题：

You need to allow the user to toggle between automatic query and no automatic query using a pop-up menu. Which built-in would you use in the menu item command to obtain the relationship name? （）

• A、GET_RELATION_PROPERTY 
• B、SET_RELATION_PROPERTY 
• C、GET_BLOCK_PROPERTY 
• D、GET_FORM_PROPERTY

第16题：

You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）

• A、run Segment Advisor
• B、run SQL Tuning Advisor on top SQL statements
• C、run the Automatic Workload Repository （AWR） report
• D、run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements

第17题：

You need to add a pop-up menu to the CV_EMP canvas to display when a user right-clicks the mouse within the canvas. How could you create the pop-up menu?（）

• A、Use the Layout Editor to create a pop-up menu, assign commands to the menu in the Menu Editor, and attack the menu items to the canvas. 
• B、Use the Report Wizard to create a pop-up menu and attack the menu items to the canvas.  
• C、Alter the pop-up Menu Property value in the Property Palette of the canvas. 
• D、Use the Object Navigator to create a pop-up menu, assign commands to the menu items, and attack the menu to items or canvases.

第18题：

You are the network administrator for The network consists of a single Active Directory domain named The functional level of the domain is Windows Server 2003. Some user accounts have expiring passwords and some do not. You need to identify all user accounts that do not have expiring passwords. You need to modify the password property to allow the passwords on these accounts to expire. You must complete this task by using the minimum amount of administrative effort. First, you create a saved query to obtain a list of all user accounts that do not have expiring passwords. What should you do next?（）

• A、Export the query results to a comma-delimited file. Use a CSVDE script to modify the password property of each user account.
• B、From the Results pane of the query, select all user accounts and modify their password properties simultaneously.
• C、Export the query results to a comma-delimited file. Use an LDIFDE script to modify the password property of each user account.
• D、From the Results pane of the query, select each user account and modify the password property, one by one.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：