单选题The following command is executed to create the baseline template：   SQL> EXECUTEDBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE（START_TIME=> TO_TIESTAMP（SYSDATE+2），  END_TIME=>TO_TIMESTAMP（SYSDATE+10）， BASELINE_NAME=>’Mybase4’，  TEMPLATE_NAME=>’Myte

第1题：

You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）

• A、Image of the control file
• B、Location of the control file
• C、Contents of the control file in text format
• D、SQL command to re-create the database
• E、SQL command to re-create the control file
• F、Contents of the control file in binary format

第2题：

Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp； Table dropped.  What happens in this scenario？ （）

• A、The table is moved to the SYSAUX tablespace.
• B、The table is moved to the SYSTEM tablespace.
• C、The table is removed from the database permanently.
• D、The table is renamed and remains in the TBSFD tablespace.

第3题：

Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）

• A、 SQL statements that are part of the AWR baseline only
• B、 SQL statements based on the AWR top SQL identification
• C、 SQL statements that are part of the available SQL Tuning Set （STS） only
• D、 SQL statements that are available in the cursor cache and executed by a user other than SYS

第4题：

Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）

• A、FORMS_DDL 
• B、DO_SQL 
• C、FORM_SUCCESS 
• D、FORM_NOT_SUCCESS
• E、DBMS.ERROR_CODE

第5题：

The following command is executed to create the baseline template：   SQL> EXECUTEDBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE（START_TIME=> TO_TIESTAMP（SYSDATE+2），  END_TIME=>TO_TIMESTAMP（SYSDATE+10）， BASELINE_NAME=>’Mybase4’，  TEMPLATE_NAME=>’Mytemp4’， EXPIRATION=>NULL）；   Which statement is true about the effect of the above command？（）  

• A、 It creates a baseline template that never expires.
• B、 It produces an error because no snapshot information is provided to create the baseline.
• C、 It creates a baseline template that expires after the Automatic Workload Repository （AWR） retention period.
• D、 It creates a repeating baseline template that repeats after the Automatic Workload Repository （AWR） retention period.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You plan to collect the Automatic Workload Repository （AWR） data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline.  What is the correct action to achieve this？（）  

• A、 Create and populate a SQL Tuning Set from the AWR on every Monday.
• B、 Change the RETENTION setting for the AWR snapshots to 7 days on Monday.
• C、 Create a repeating baseline template.
• D、 Insert a finding directive for future ADDM tasks.

第14题：

You are creating a job class. You have issued the following command to create the job class：  SQL> BEGIN   DBMS_SCHEDULER.CREATE_JOB_CLASS（        JOB_CLASS_NAME => ’LOW_PRIORITY_CLASS’，        RESOURCE_CONSUMER_GROUP => ’LOW_GROUP’，        LOGGING_LEVEL => DBMS_SCHEDULER.LOGGING_FULL，        LOG_HISTORY => 1200，   COMMENTS => ’LOW JOB PRIORITY CLASS’）；        END；        SQL> /   What will be the result of the above command？（）

• A、 The command will be executed successfully.
• B、 The command will fail because RESOURCE_CONSUMER_GROUP is an invalid parameter in the  DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
• C、 The command will fail because LOGGING_LEVEL is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
• D、 The command will fail because LOG_HISTORY is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
• E、 The command will fail because 1200 is an invalid value for the LOG_HISTORY parameter in the  DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.

第15题：

Examine the commands executed in the following sequence：  1：SQL> CREATE ROLE mgrrole；  2：SQL> GRANT create user，select any table，connect，resource TO mgrrole；  3：SQL> GRANT select，update ON sh.sales TO mgrrole；  4：SQL> CREATE ROLE ceo IDENTIFIED BY boss；  5：SQL> GRANT mgrrole，drop any table，create any directory TO ceo；  6：SQL> GRANT ceo TO mgrrole；  Which statement is true about the above commands（）

• A、The commands execute successfully.
• B、Command 6 produces an error because of circular role grant.
• C、Command 5 produces an error because a role cannot be granted to another role.
• D、Command 3 produces an error because the MGRROLE role already contains system privileges.
• E、The table created by HR remains and HR still has the CREATE TABLE system privilege.
• F、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

第16题：

You created the ORDERS table in your database by using the following code：   SQL> CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）；   Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL> INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）；   SQL> INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）；   SQL> COMMIT；   Next， you issued the following statement to change the time zone for the database：   SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’；   What will be the result of executing the above statement？（）  

• A、 The statement will fail.
• B、 The statement will be executed successfully， and the new time zone will be set for the database.
• C、 The statement will be executed successfully， but the new time zone will be set for the current session.
• D、The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.

第17题：

You are the administrator of a SQL Server 2005 computer named SQL1. You create a security template that disables unnecessary services. The template is appropriate only for SQL1. You need to ensure that the security template is applied to SQL1. Your solution must ensure that the template automatically overrides any manual configuration changes made by other administrators within an hour. What should you do？（）

• A、Use the SQL Server Surface Area Configuration tool to import the security template.
• B、Use the Local Security Policy editor to import the security template into the Local Security Policy object.
• C、Configure Task Scheduler to import the security template by using Secedit.exe. Configure the task to run every half hour.
• D、Configure Task Scheduler to run the Microsoft Baseline Security Analyzer tool every half hour.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：