Online Access Free Oracle.1Z1-060.v2022-04-28.q110 Practice Test (Page 20)

1Z1-060 Exam Question 91

Examine the parameters for your database instance:

Which three statements are true about the process of automatic optimization by using cardinality feedback?

A.The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.

B.The optimizer can re optimize a query only once using cardinality feedback.

C.The optimizer enables monitoring for cardinality feedback after the first execution of a query.

D.The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.

E.After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

1Z1-060 Exam Question 92

Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.
Which three steps should you perform to recover the control file and make the database fully operational?
(Choose three.)

A.Mount the container database (CDB) and restore the control file from the control file autobackup.

B.Recover and open the CDB in NORMAL mode.

C.Mount the CDB and then recover and open the database, with the RESETLOGS option.

D.Open all the pluggable databases.

E.Recover each pluggable database.

F.Start the database instance in the nomount stage and restore the control file from control file autobackup.

1Z1-060 Exam Question 93

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.)

A.Cursors are not being shared.

B.There are frequent logons and logoffs.

C.The size of the shared pool is too small.

D.A large number COMMITS are being performed.

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

1Z1-060 Exam Question 94

Examine the following query output:

You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?

A.All database operations performed by the impdp command are logged.

B.Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.

C.Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.

D.None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

1Z1-060 Exam Question 95