CertsTopics Logo

New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Oracle Oracle Database 12c 1z0-060 New Questions

Page: 6 / 8
Total 208 questions
Get 1z0-060 Full Access Download 1z0-060 PDF

Upgrade to Oracle Database 12c Questions and Answers

Question 21

Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

What are three possible causes for the latch-related wait events? (Choose three.)

Options:

A.

The size of the shared pool is too small.

B.

Cursors are not being shared.

C.

A large number COMMITS are being performed.

D.

There are frequent logons and logoffs.

E.

The buffers are being read into the buffer cache, but some other session is changing the buffers.

Question 22

The current system change number (SCN) for a live database is 663571.

You decide to use the flashback table statement to flash back the customers table to SCN 662116.

After flashing back the customers table, you query It and decide to undo the effects of the flashback table command.

Which is the fastest way to do this?

Options:

A.

Execute another flashback table statement to restore the customers table to SCN 663571.

B.

Perform tablespace point-in-time recovery because flashback table cannot be performed on a table that has already been flashed back.

C.

Execute the RMAN recover block command by specifying the table name and SCN 663571 because fiashback table cannot be performed on a table that has already been flashed back.

D.

Perform table polnt-in-time recovery because flashback table cannot be performed on a table that has already been flashed back.

Question 23

You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.

The CDB has several pluggable databases (PDBs) open in the read/write mode.

There are ongoing transactions in both the CDB and PDBs.

What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?

Options:

A.

The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack.

B.

The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.

C.

The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.

D.

The statement results in an error because there are open PDBs.

Question 24

On your Oracle 12c 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;

SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);

Which two statements are true? (Choose two.)

Options:

A.

The optimizer evaluates index access from both the indexes before deciding on which index to use for a query execution plan.

B.

Both the indexes are created: however, only ORD_CUSTOMER_IX2 index is visible.

C.

Only the ORD_CUSTOMER_IX1 index is created.

D.

Only the ORD_CUSTOMER_IX2 index is created.

E.

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

Page: 6 / 8
Total 208 questions
Get 1z0-060 Full Access Download 1z0-060 PDF