1Z0-062 Free Practice Test

You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE; Which is true about the result of this command?

1. A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
2. B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
3. C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
4. D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignore

Correct Answer: A

An application repeatedly accesses small lookup tables, causing a lot of physical I/O operations. What do you recommend to minimize this?

1. A. Configure the nonstandard buffer cache with a buffer size greater than the size of the default buffer cache.
2. B. Increase the size of the shared pool
3. C. Configure the KEEP buffer cache and alter the tables to use the KEEP cache.
4. D. Configure the RECYCLE buffer cache and alter the tables to use the RECYCLE cach

Correct Answer: C

What must you use to read data from a table in your database and write it to an external table?

1. A. Use SQL* LOADER conventional path load.
2. B. Use SQL* LOADER direct path load.
3. C. Use CREATE TABL
4. D. . ORGANIZATION EXTERNAL command with ORACLE_LOADER access driver.
5. E. Use CREATE TABL
6. F. . ORGANIZATION EXTERNAL command with ORACLE_DATAPUMP access drive

Correct Answer: D

You want to create a file watcher and an event-based job for detecting the arrival of files on the local server from various locations. To achieve this, you enable the raising of file arrival events from remote systems.
Which two conditions must be satisfied to receive file arrival events from a remote system? (Choose two.)

1. A. The remote system must have a running Oracle Database instance and a scheduler agent installed.
2. B. The initialization parameter REMOTE_OS_AUTHENT must be set to TRUE on your database.
3. C. The local database must be set up to run remote external jobs.
4. D. The remote system\'s scheduler agent must be registered with your database.
5. E. Database links to remote databases must be created.

Correct Answer: CD
References: https://docs.oracle.com/cd/E18283_01/server.112/e17120/scheduse005.htm

Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)

1. A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
2. B. In a PDB plan, subplans may be used with up to eight consumer groups.
3. C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
4. D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
5. E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Correct Answer: AE
A: Setting a PDB resource plan is optional. If not specified, all sessions within the PDB are treated equally.
*
In a non-CDB database, workloads within a database are managed with resource plans.
In a PDB, workloads are also managed with resource plans, also called PDB resource plans. The functionality is similar except for the following differences:
/ Non-CDBDatabase Multi-level resource plans Up to 32 consumer groups Subplans
/ PDBDatabase
Single-level resource plans only Up to 8 consumer groups
(not B) No subplans