1Z0-063 Free Practice Test

- (Exam Topic 1)
Which three statements are true about the SQL*Loader utility? (Choose three.)

1. A. It can be used to load data from multiple external files into multiple tables.
2. B. It can be used to extract and reorganize data from external files, and then load it into a table.
3. C. It can be used to load data from external files using direct path only.
4. D. It can be used to create tables using data that is stored in external files.
5. E. It can be used to generate unique sequential values in specified columns while loading data.

Correct Answer: ABE

- (Exam Topic 1)
You are required to migrate your 11.2.0.3 database to an Oracle 12c database.
Examine the list of steps that might be used to accomplish this task:
1. Place all user-defined tablespaces in read-only mode on the source database.
2. Use the RMAN convert command to convert data files to the target platform's endian format, if required.
3. Perform a full transportable export on the source database with the parameters VERSI0N=12, TRANSPORTABLE=ALWAYS, and FULL=Y.
4. Transport the data files for all the user-defined tablespaces.
5. Transport the export dump file to the target database.
6. Perform an import on the target database by using the full, network_link, and transportable_datafiles parameters.
7. Perform an import on the target database by using the full and transportable_datafiles parameters. Identify the required steps in the correct order.

1. A. 1, 3, 5, 4, 2, and 7
2. B. 1, 2, 4, 6, 5, 3, and 7
3. C. 1, 2, 4, and 7
4. D. 2, 4, 5, 6, and 7

Correct Answer: A

- (Exam Topic 2) Examine the command and its output: SQL> DROP TABLE EMPLOYEE;
SQL> SELECT object_name AS recycle_name, original_name, type
FROM recyclebin; RECYCLE_NAMEORIGINAL_NAMETYPE
binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE You then successfully execute the command:
SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP;
Which two statements are true? (Choose two.)

1. A. It flashes back the employee table and all the constraints associated with the table.
2. B. It automatically flashes back all the indexes on the employees table.
3. C. It automatically flashes back any triggers defined on the table.
4. D. It flashes back only the structure of the table and not the data.
5. E. It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.

Correct Answer: AC

- (Exam Topic 2)
Which two statements are true about 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: ACDB resource plan determines the amount of resources allocated to each PDB. A PDB resource plan determines how the resources allocated to a specific PDB are allocated to consumer groups within that PDB.
Resource Manager allocates the resources in two steps:
E: A PDB resource plan allocates resource among the consumer groups within a PDB. References: https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm

- (Exam Topic 2)
Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)

1. A. A PDB must be in closed state before it can be unplugged.
2. B. A PDB must have been opened at least once after creation.
3. C. A PDB must be in MOUNT state before it can be unplugged.
4. D. PDB data file are automatically removed from disk.
5. E. An unplugged PDB can be plugged into the same or another container database (CDB).

Correct Answer: ABE
A: To unplug a PDB, you first close it.
E: You can disassociate or unplug a PDB from a CDB and reassociate or plug the PDB into the same CDB or into another CDB.