READ Free Dumps For Oracle- 1z0-062
Question ID 2382 | An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. |
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 |
|
Option E |
|
Correct Answer | A |
Question ID 2383 | You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege. |
Option A | A. The shutdown proceeds immediately. |
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 |