1z0-067 Oracle Exam Questions and Free Practice Test

Question 61

You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.

A. 2, 1, 3, 4, 5, 6

B. 1, 3, 4, 5, 6, 7

C. 1, 4, 3, 5, 6, 7

D. 2, 1, 3, 4, 5, 6, 7

E. 1, 5, 6, 4, 3, 2

Correct Answer:C
1. Create a directory in source database to store the export dump files. 2. Set the user and application tablespace in the source database as READ ONLY 3. Export the source database using expdp with parameters version=12.0, transportable=always and full=y 4. Copy the dumpfile and datafiles for tablespaces containing user /application dat
A. 5. Create a new PDB in the destination
CDB using create pluggable database command. 6. Create a directory in the destination PDB pointing to the folder containing the dump file or create a directory for dump file and move the dump file there. 7. Create an entry in tnsnames.ora for the new PDB. 8. Import in to the target using impdp
with parameters FULL=Y and TRANSPORT_DATAFILES parameters. Make sure, the account is having IMP_FULL_DATABASE. 9. Restore the tablespaces to READ-WRITE in source database. http://sandeepnandhadba.blogspot.pt/2014/05/migrating-from-11203-non-cdb-to-12c-pdb.html

Question 62

You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command.
What is the outcome?

A. The PDB is closed.

B. The PDB is placed in mount state.

C. The command executes only if the common user is granted the set container privilege for the PDB.

D. The command results in an error because the PDB can be shut down only by a local use

Correct Answer:B
The PDB is placed in mount state. SQL> shutdown immediate; Pluggable Database closed. SQL>
select status from v$instance; STATUS ———— MOUNTED SQL> There is no closed Status in a PDB. PDB can have Mount/Read Write/Read Only.

Question 63

Your database is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost.
Examine the steps to restore the SPFILE and the control file to mount the database:
1. Set DBID of the target database in RMAN.
2. Start the database instance by using the STARTUP FORCE NOMOUNT command in RMAN.
3. Restore the control files from the backup.
4. Mount the database.
5. Restore the SPFILE from the autobackup.
6. Create a PFILE from the recovered SPFILE.
7. Restart the instance in NOMOUNT state. Identify the required steps in the correct order.

A. 1, 2, 5, 3, 6, 4

B. 1, 2, 3, 5, 6, 4

C. 2, 1, 5, 7, 3, 4

D. 2, 1, 5, 6, 7, 4, 3

Correct Answer:C

Question 64

Which two statements are true about roles in multitenant container databases (CDBs)?

A. Local roles can be granted to local and common users.

B. A common role can be granted only to a common user.

C. A common user can create a local role by default in any pluggable database (PDB) that is plugged in to a CDB.

D. A common role can be granted only system privileges.

E. The root container can have both local and common roles.

F. A local role can be assigned to a common role in a PD

Correct Answer:DF

Question 65

Examine the command used to perform an incremental level-0 backup: RMAN>BACKUP INCREMENTAL LEVEL0 DATABASE;
To enable block change tracking, after the incremental level 0 backup, you issue the command: SQL>ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING
FILE'/mydir/rman_change_track.f';
To perform an incremental level-1 cumulative backup, you issue the command: RMAN>BACKUP INCREMENTAL LEVEL1 CUMULATIVE DATABASE;
Which two statements are true in the preceding situation?

A. The block change tracking data is used only from the next incremental backup.

B. The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.

C. The incremental level 1 backup does not use change tracking data for accomplishing the backup.

D. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.

E. The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.

Correct Answer:CE

Question 66

Which two statements are true about service creation for pluggable databases (PDBs)?

A. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.

B. The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.

C. A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.

D. Only a common user can create additional services for a PDB.

E. When a PDB is created, a service with the same name as the PDB is created in the PD

Correct Answer:AC

START 1z0-067 EXAM