AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-060





Question ID 2219

On your Oracle Database, you issue the following commands to create indexes:
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id)
 
INVISIBLE;
Which two statements are true?
 

Option A

A.    Only the ORD_CUSTOMER_IX1 index created.
 

Option B

B.    Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.
 

Option C

C.    Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.
 

Option D

D.    The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.
 

Option E

E.    Both the indexes are created and used by the optimizer for queries on the ORDERS table.
 

Option F

F.    Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.
 

Correct Answer B,F
Explanation


Question ID 2220

Which two statements are true when row archival management is enabled?

Option A

A.    The ORA ARCHIVE _STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
 

Option B

B.    The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
 

Option C

C.    The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
 

Option D

D.    The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
 

Option E

E.    The ORA ARCHIVE _STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
 

Explanation

Send email to admin@getfreedumps for new dumps request!!!