1z0-060 Free Practice Test

You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements:
<>

1. A. It succeeds because the PDB_ADMIN user has the required privileges.
2. B. It fails because common users are unable to use the SET CONTAINER statement.
3. C. It fails because local users are unable to use the SET CONTAINER statement.
4. D. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

Correct Answer: C

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?

1. A. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
2. B. Increase the database buffer cache size.
3. C. Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
4. D. Configure Automata Shared Memory Management.
5. E. Configure Automatic Memory Management-

Correct Answer: A

A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);
You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.
What could be a reason for this recommendation?

1. A. The keep pool is not configure
2. B. Automatic Workarea Management is not configure
3. C. Automatic Shared Memory Management is not enable
4. D. The data blocks in the SUBSCRIBE_LOG table are rarely accesse
5. E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.

Correct Answer: D

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE” statement?

1. A. It will create a multitenant container database (CDB) with only the root opene
2. B. It will create a CDB with root opened and seed read only.
3. C. It will create a CDB with root and seed opened and one PDB mounte
4. D. It will create a CDB that must be plugged into an existing CD
5. E. It will create a CDB with root opened and seed mounte

Correct Answer: B

An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.
A multitenant container database (CDB) instant has the following parameter set:
THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?

1. A. You can conned as a common user by using the connect statement.
2. B. You can connect as a local user by using the connect statement.
3. C. You can connect by using easy connect.
4. D. You can connect by using OS authentication.
5. E. You can connect by using a Net Service name.
6. F. You can connect as a local user by using the SET CONTAINER statement.

Correct Answer: ACE