Online 1z0-067 Practice TestMore Oracle Products >

Free Oracle 1z0-067 Exam Dumps Questions

Oracle 1z0-067: Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP

- Get instant access to 1z0-067 practice exam questions

- Get ready to pass the Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP exam right now using our Oracle 1z0-067 exam package, which includes Oracle 1z0-067 practice test plus an Oracle 1z0-067 Exam Simulator.

- The best online 1z0-067 exam study material and preparation tool is here.

4.5

(4035 ratings)

Question 1

Examine the RMAN commands executed in your database: RMAN>CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN>CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET; RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
You issue the command: RMAN> BACKUP DATABASE;
Which two statements are true about the command?

A. It performs a log switch.

B. It creates compressed backup sets by using binary compression by default.

C. It backs up only the used blocks in data files.

D. It backs up data files, the control file, and the server parameter file.

E. It creates a backup of only the control file whenever the database undergoes a structural chang

Correct Answer:CD
C: RMAN backup sets automatically use unused block compression. http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta007.htm#i1015382
D: If CONFIGURE CONTROLFILE AUTOBACKUP is ON (by default it is OFF), then RMAN automatically backs up the control file and server parameter file after every backup and after database structural
changes. http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup003.htm#i1009642 Not E: spfile is also backed up.

Question 2

Examine the initialization parameter that is set in the PFILE: DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/'
You execute the following command to create theCDB1. container database (CDB): SQL>CREATE DATABASE CDB1
DEFAULT TABLESPACE users
DEFAULT TEMPORARY TABLESPACE temp
UNDO TABLESPACE undotbsl
ENABLE PLUGGABLE DATABASE SEED
SYSTEM DATAFILES SIZE125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED SYS AUX DATAFILES SIZE 100M;
Which three statements are true?

A. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.

B. The files created for both the root and seed databases use Oracle Managed Files (OMF).

C. It creates a multitenant container database with the root and seed databases opened and one PDB mounted.

D. It sets the users tablespace as the default for both the root and seed databases.

E. undotbs1 is used as the undo tablespace for both the root and seed databases.

F. It creates a multitenant container database with the root database opened and the seed database mounted.

Correct Answer:ABE
The seed actually doesn’t use anything since it’s read-only, but any PDB created from the seed will use the undotbs1 undo tablespace. Each PDB can have its own default tablespace, but cannot change the undo tablespace.

Question 3

Examine the command to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TO cdb PLUGGABLE DATABASE pdb1, pdb5;
Which two statements are true about the DUPLICATE command?

A. The SPFILE is copied along with the data files of the pluggable databases (PDBs).

B. The root and the seed database in the container database (CDB) are also duplicated.

C. A backup of pdb1 and pd5 must exist before executing the command.

D. The duplicate command first creates a backup, and then duplicates the PDBs by using the backup.

E. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

Correct Answer:BE
Do backups of the source database exist? The principal advantage of active database duplication is that it does not require source database backups. Active duplication copies mounted or online database files over a network to the auxiliary instance. One disadvantage of this technique is the negative performance effect on the network. Another disadvantage is that the source database is running processes required to transfer the files to the auxiliary host, thereby affecting the source database and production workload. If the source database backups exist, and if the effect on the network is unacceptable, then backup-based duplication may be a better option. You can copy backups to temporary storage and transfer them manually to the destination host. If duplication is made with a connection to the target or the recovery catalog, then the backup files on the destination host must have the same file specification as they had on the source host. Otherwise, this is not a requirement.

Question 4

Your database supports an OLTP workload. Examine the output of the query:
SQL> SELECT target_mttr, estimated_mttr FROM v$instance_recovery
Target_mttr estimated_mttr
---------------------- --------------------------- 0 76
To ensure faster instance recovery, you set the fast_start_mttr_target initialization parameter to 30. What is the effect of this setting on the database?

A. Automatic checkpoint tuning is disabled.

B. The frequency of log switches is increased.

C. The overhead on database performance is increased because of frequent writes to disk.

D. The MTTR advisor is disable

Correct Answer:C
Reference: http://docs.oracle.com/cd/A97630_01/server.920/a96533/instreco.htm

Question 5

You must unload data from the orders, order_items, and products database tables to four files using the External Tables.
CREATE TABLE orders_ext
(order_id, order_date, product_id, product_name,quantity) ORGANIZATION EXTERNAL
(
TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY ext.dir
LOCATION (‘ordersl.dmp','orders2.dmp’,’orders3.dmp’,’lorders4.dmp')
) PARALLEL AS
SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity FROM orders o,productsp,order_itemsi
WHERE o.orderjd = i.order_id and i.product_id = p.product_id;
You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?

A. TYPE

B. LOCATION

C. PARALLEL

D. DEFAULT DIRECTORY

E. ORGANIZATION EXTERNAL

Correct Answer:C
Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14215/et_concepts.htm#i1007483

Question 6

You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user: SQL> CREATE USER c##scott IDENTIFIED BY scottorcl1;
SQL> GRANT CREATE SESSION TO c##scott;
Which statement is true about the C##SCOTT user? Choose the best answer.

A. It is created in all the PDBs with CREATE SESSION privilege.

B. It is created in all the PDBs but has CREATE SESSION privilege only in CDB$ROOT.

C. It is created and has the CREATE SESSION privilege only in a PDB that is open.

D. It is created only in CDB$ROOT and has the CREATE SESSION privileg

Correct Answer:D

START 1z0-067 EXAM