You executed the following PL/SQL block successfully:<br /> <img src="https://nimg.ppkao.com/2018-08/yiyu/2018080209212755738.jpg?sign=24b8e4e98a26cd5258de367a99442bce&t=62d206be" /><br /> The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis.（）..

第1题

[] You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously. Dim ar As IAsyncResult = cmd.BeginExecuteReader() You need to execute a method named DoWork() that takes one second to run while the SQL query is executing. DoWork() must run as many times as possible while the SQL query is executing. Which code segment should you use?（） You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously. Dim ar As IAsyncResult = cmd.BeginExecuteReader() You need to execute a method named DoWork() that takes one second to run while the SQL query is executing. DoWork() must run as many times as possible while the SQL query is executing. Which code segment should you use?（）

A、A.
B.
C.
D.

点击查看答案

第2题

[] View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error: SQL> EXECUTE dbms_resources_manager.validate_pending_area ( ); What could be the reason?（） View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error: SQL> EXECUTE dbms_resources_manager.validate_pending_area ( ); What could be the reason?（）

A、A. The pending area is automatically submitted after the plan creation B、B. The procedure must be executed before creating the resources plan directive C、C. The SYS_GROUP resource consumer group is not included in the resource plan directive D、D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

点击查看答案

第3题

[] View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error: SQL> EXECUTE dbms_resources_manager.validate_pending_area ( ); What could be the reason?（） View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error: SQL> EXECUTE dbms_resources_manager.validate_pending_area ( ); What could be the reason?（）

A、A. The pending area is automatically submitted after the plan creation B、B. The procedure must be executed before creating the resources plan directive C、C. The SYS_GROUP resource consumer group is not included in the resource plan directive D、D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

点击查看答案

第4题

[多选题] You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?（）

A、the SQL text SQL B、the execution plan C、the execution context D、the execution frequency E、the system change number (SCN)

点击查看答案

第5题

[单选题] Which statement about using RMAN stored scripts is true?（）

A、To create and execute an RMAN stored script, you must use a recovery catalog. B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file. C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog. D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

点击查看答案

第6题

[单选题] Which statement about using RMAN stored scripts is true?（）

A、To create and execute an RMAN stored script, you must use a recovery catalog. B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file. C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog. D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

点击查看答案

第7题

[多选题] You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?（）

A、Every SQL statement in the STS is considered only once for execution B、The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics C、The execution plan and execution statistics are computed for each SQL statement in the STS D、The effects of DDL and DML are considered to produce the execution plan and execution statistics

点击查看答案

第8题

[单选题] 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.

点击查看答案

第9题

[] Examine the output of the query that you executed to list the objects in the recycle bin: You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin: SQL> PURGE TABLE sales_tab; What would be the outcome of this command?（） Examine the output of the query that you executed to list the objects in the recycle bin: You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin: SQL> PURGE TABLE sales_tab; What would be the outcome of this command?（）

A、A. All three tables in the recycle bin are purged B、B. Only the table with the oldest DROPSCN is purged C、C. The command returns an error because multiple entries with the same name exist in the recycle bin D、D. Only the table with the latest DROPSCN is purged

点击查看答案

第10题

[单选题] You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）

A、 You must enable the block change tracking feature. B、 You must have enable the flashback feature. C、 You must use the OMF in your database. D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

点击查看答案

You executed the following PL/SQL block successfully:<br /> <img src="https://nimg.ppkao.com/2018-08/yiyu/2018080209212755738.jpg?sign=24b8e4e98a26cd5258de367a99442bce&t=62d206be" /><br /> The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis.（）

请使用微信扫码支付