1z1-063 무료 덤프문제 온라인 액세스

Which three statements are true about using RMAN without a recovery catalog? (Choose three.)

• A.Database duplication will require a connection to the target.
• B.The REPORT SCHEMA command will report only the current database schema.
• C.CONTROL_FILE_RECORD_KEEP_TIME may need to be increased.
• D.CONTROL_FILE_RECORD_KEEP_TIME may need to be decreased.
• E.The RMAN backup retention can only be configured to use a redundancy based policy.
• F.No archive log deletion policies will be possible.

A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.
Which table organization allows for generating the bills with minimum degree of row sorting?

• A.an index cluster
• B.a sorted hash cluster
• C.a heap table with a rowid column
• D.a partitioned table
• E.a hash cluster

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=>'on 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?

• A.The procedure must be executed before creating any plan directive.
• B.Pending areas can not be validated until submitted.
• C.The pending area is automatically submitted when creating plan directives.
• D.The other_groups group is not included in the resource plan.
• E.The sys_group group is not included in the resource plan.

Examine the statements that use flashback technologies:
1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00',
'YYYY-MM-DD HH:MI:SS');
2. SELECT * FROM customers AS OF SCN 123456;
3. FLASHBACK TABLE customers TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00',
'YYYY-MM-DD HH:MI:SS');
5. SELECT * FROM customers VERSIONS BETWEEM SCN 123456 AND 123999;
6. ALTER TABLE customers FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the undo tablespace?

• A.1, 3, 6
• B.3, 4, 5
• C.1, 2, 5
• D.2, 3, 5, 6

Which two statements are true regarding Oracle Data Pump? (Choose two.)

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