多选题Examine the commands executed to monitor database operations: $> conn sys oracle/oracle@prod as sysdba SQL > VAR eid NUMBER SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’); Which two statements are true?（）ADat

第1题：

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 

第2题：

Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）

• A、The SKD user cannot log in to the database instance.
• B、The objects owned by the SKD user are not accessible to any user.
• C、The other users can access the objects owned by the SKD user， on which they have access.
• D、The password for the SKD user expires and the user is forced to change the password at the next log in

第3题：

第4题：

Examine the commands executed to monitor database operations: $> conn sys oracle/oracle@prod as sysdba SQL > VAR eid NUMBER SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’); Which two statements are true?（）

• A、Database operations will be monitored only when they consume a significant amount of resource.
• B、Database operations for all sessions will be monitored.
• C、Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.
• D、Only DML and DDL statements will be monitored for the session.
• E、All subsequent statements in the session will be treated as one database operation and will be monitored.

第5题：

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script：   SQL>@utlu111i.sql   Which statement about the execution of this script is true？（）

• A、 It must be executed from the Oracle Database 11g environment.
• B、 It must be executed only after the SYSAUX tablespace has been created.
• C、 It must be executed from the environment of the database that is being upgraded.
• D、 It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
• E、 It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

第6题：

All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions： SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.  SQL> DELETE FROM persons WHERE exp=’Y’； 3 rows deleted.  The SYS user opens a new session after HR executed the above commands.  Which sessions can seethe effect of the UPDATE and DELETE commands （）

• A、all sessions of the HR user only
• B、all sessions of the HR user and the SYS user
• C、the session of the HR user that executed the commands
• D、all the sessions for which the database users have access privilege to the PERSONS table

第7题：

You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database12c. Your database supports a mixed workload. During the day, lots of insert, update, and deleteoperations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause ofperformance degradation, you want to collect basic statistics such as the level of parallelism, totaldatabase time, and the number of I/O requests for the ETL jobs. How do you accomplish this?（）

• A、Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.
• B、Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.
• C、Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.
• D、Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.

第8题：

Which two are attributes of iSQL*Plus? （）

• A、iSQL*Plus commands cannot be abbreviated.
• B、iSQL*Plus commands are accessed from a browser.
• C、iSQL*Plus commands are used to manipulate data in tables.
• D、iSQL*Plus commands manipulate table definitions in the database.
• E、iSQL*Plus is the Oracle proprietary interface for executing SQL statements.

第9题：

Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）

• A、The SKD user cannot log in to the database instance.
• B、The objects owned by the SKD user are not accessible to any user.
• C、The other users can access the objects owned by the SKD user， on which they have access.
• D、The password for the SKD user expires and the user is forced to change the password at the next log in.

第10题：

Which two statements are true regarding Oracle Data Pump（）

• A、EXPDP and IMPDP are the client components of Oracle Data Pump.
• B、DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
• C、Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
• D、Oracle Data Pump imports can be done from the export files generated in the export utility of previous versions.
• E、EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.