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 2151

An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache.
How would you guarantee that the blocks for the table never age out?
 

Option A

A.    Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
 

Option B

B.    Increase the database buffer cache size.
 

Option C

C.    Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
 

Option D

D.    Configure Automata Shared Memory Management.

 

Option E

E.    Configure Automatic Memory Management-

Correct Answer A
Explanation


Question ID 2152

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?
 

Option A

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

Option B

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

Option C

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

 

Option D

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

Correct Answer B
Explanation

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