【C4】A．setting upB．making upC．taking upD．building up

A．120M

B．320M

C．480M

D．600M

A．4

B． 8

C． 7

D． 0

A. Accept the recommended SQL profile.

B.Collect statistics for the related objects.

C. Run the Access Advisor for the SQL statement.

D. Run the Segment Advisor for recommendations.

n.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. The pending area is automatically submitted after the plan creation

B. The procedure must be executed before creating the resources plan directive

C. The SYS_GROUP resource consumer group is not included in the resource plan directive

D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

n. 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. The pending area is automatically submitted after the plan creation

B. The procedure must be executed before creating the resources plan directive

C. The SYS_GROUP resource consumer group is not included in the resource plan directive

D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS.Which statement is true if the SQL query in exhibit1 is executed again when the valueof OPTIMIZER_MODE is set to FIRST_ROWS？（）

A. The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans.

B. The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.

C. The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan.

D. The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to FIRST_ROW during its creation.

A．90 MB

B． 272 MB

C． 362 MB

D． 1,440 MB

Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row？（）

A. Flashback logging is not enabled for the database.

B. The changes made to the table are not committed.

C. Supplemental logging is not enabled for the database.

D. The database is not configured in ARCHIVELOG mode.

for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN> REPAIR FAILURE;Which statement describes the consequence of the command？（）

A. The command performs the recovery and closes the failures.

B. The command only displays the advice and the RMAN script required for repair.

C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.

D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

A. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema.

B. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only.

C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state.

D. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.