Question 126
Examine the commands:
SQL> ALTER SESSION SET RECYCLEBIN = ON;
Session altered.
SQL> DROP TABLE emp; --(First EMP table)
Total dropped.
SQL> CREATE TABLE emp(id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name
VARCHAR2 (15), salary NUMBER(7,2));
Table created.
You then execute multiple INSERTstatements to insert rows into EMPtable and drop the table again:
SQL> DROP TABLE emp; -- (Second EMP table)
Table dropped.
SQL> FLASHBACK TABLE emp TO BEFORE DROP;
Which statement is true about the FLASHBACK command?
SQL> ALTER SESSION SET RECYCLEBIN = ON;
Session altered.
SQL> DROP TABLE emp; --(First EMP table)
Total dropped.
SQL> CREATE TABLE emp(id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name
VARCHAR2 (15), salary NUMBER(7,2));
Table created.
You then execute multiple INSERTstatements to insert rows into EMPtable and drop the table again:
SQL> DROP TABLE emp; -- (Second EMP table)
Table dropped.
SQL> FLASHBACK TABLE emp TO BEFORE DROP;
Which statement is true about the FLASHBACK command?
Question 127
Which three statements are true about persistent lightweight jobs? (Choose three.)
Question 128
Flashback Data Archive has been configured to retain data on all transactions that modify a table for a period of four years.
Three years later, it is decided to change the retention period.
You execute this command:
SQL> ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENSION RETENTION 2 YEAR;
Which is true?
Three years later, it is decided to change the retention period.
You execute this command:
SQL> ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENSION RETENTION 2 YEAR;
Which is true?
Question 129
Examine the parameters for your database instance:
NAMETYPEVALUE
- -----------------------------------------------
optimizer_adaptive_reporting_onlybooleanFALSE
optimizer_capture_sql_plan_baselinesbooleanFALSE
optimizer_dynamic_samplinginteger2
optimizer_features_enablestring12.1.0.1
Which three statements are true about the process of automatic optimization by using statistics feedback?
NAMETYPEVALUE
- -----------------------------------------------
optimizer_adaptive_reporting_onlybooleanFALSE
optimizer_capture_sql_plan_baselinesbooleanFALSE
optimizer_dynamic_samplinginteger2
optimizer_features_enablestring12.1.0.1
Which three statements are true about the process of automatic optimization by using statistics feedback?
Question 130
View the Exhibit showing steps to create a database resource manager plan.
SQL>execute dbms_resource_manager.create_pendingarea();
PL/SQL procedure successfully completed.
SQL>exec dbms_resource_manager, create_consumergroup
(consumer_group=>'OLTP,,comment=>,onlineuser')
PL/SQL procedure successfully completed.
SQL>exec bras resource_manager.create plan
(plan=>'PRIU3ER3',comment=>'dssprio');
SQL>exec
Dbms_resource_manager.create_plan_directive
(plan=>'PRIU3ER3',group_or_subplan=>'OLTP',comment=>'onlinegrp'CPU_Pl=>60); PL/3QLproceduresuccessfullycompleted.
After executing the steps in the exhibit you execute this procedure, which results in an error:
SQL> EXECUTE dbms_resource_manager. validate_pending_area ();
What is the reason for the error?
SQL>execute dbms_resource_manager.create_pendingarea();
PL/SQL procedure successfully completed.
SQL>exec dbms_resource_manager, create_consumergroup
(consumer_group=>'OLTP,,comment=>,onlineuser')
PL/SQL procedure successfully completed.
SQL>exec bras resource_manager.create plan
(plan=>'PRIU3ER3',comment=>'dssprio');
SQL>exec
Dbms_resource_manager.create_plan_directive
(plan=>'PRIU3ER3',group_or_subplan=>'OLTP',comment=>'onlinegrp'CPU_Pl=>60); PL/3QLproceduresuccessfullycompleted.
After executing the steps in the exhibit you execute this procedure, which results in an error:
SQL> EXECUTE dbms_resource_manager. validate_pending_area ();
What is the reason for the error?