CertsTopics Logo

New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Oracle Database 12c 1z0-067 Full Course Free

Page: 8 / 10
Total 263 questions
Get 1z0-067 Full Access Download 1z0-067 PDF

Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP Questions and Answers

Question 29

Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2. RMAN is connected to the target database pdb2_1.

Examine the command executed to back up pdb2_1:

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Which statement is true about the execution of this command?

Options:

A.

It fails because archive log files cannot be backed up using a connection to a PDB.

B.

It succeeds but only the data files belonging to the PDB2_1 pluggable database are backed up.

C.

It succeeds and all data files belonging to PDB2_1 are backed up along with the archive log files.

D.

It fails because the pluggable clause is missing.

Question 30

Evaluate these statements:

CREATE TABLE purchase_orders

(po_idNUMBER(4),

po_dateTIMESTAMP,

supplier_idNUM8ER(6),

po_totalNUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id))

PARTITIONBYRANGE(po_date)

(PARTITIONQ1 VALUESLESSTHAN (TO_DATE('01-apr-2007','dd-mon-yyyy')), PARTITIONQ2VALUESLESSTHAN(TO_DATE('01-jul-2007','dd-mon-yyyy')), PARTITIONQ3VALUESLESSTHAN (TO~DATE('01-oct-2007','dd-non-yyyy')), PARTITIONQ4VALUESLESSTHAN (TO_DATE('Ol-jan-2008','dd-non-yyyy' )));

CREATETABLEpurchase_order_items

(po_idNUM3ER(4)NOTNULL,

product_idNUMBER(6)NOTNULL,

unit_prlceNUMBER(8,2),

quantity NUMBER(8),

CONSTRAINTpo_items_f k

FOREIGNKEY(po_id)REFERENCESpurchase_orders(po_id) )

PARTITIONBYREFERENCE(po_items_fk);

Which two statements are true?

Options:

A.

Partitions of purchase_order_items are assigned unique names based on a sequence.

B.

The purchase_orders and purchase_order_items tables are created with four partitioneach.

C.

purchase_order_items table partitions exist in the same tablespaces as the purchase_orders table partitions.

D.

The purckase_order_:teks table inherits the partitioning key by duplicating the key columns from the parent table.

E.

Partition maintenance operations on the purchase_order_items table require disabling the foreign key constraint.

Question 31

Which three RMAN persistent settings can be set for a database?

Options:

A.

backup retention policy

B.

default backup device type

C.

default section size for backups

D.

default destinations for backups

E.

multiple backup device types for a single backup

Question 32

Which two are prerequisites for creating a backup-based duplicate database?

Options:

A.

connecting to the target database and a recovery catalog to execute the duplicate command

B.

creating a password file for an auxiliary instance

C.

connecting to an auxiliary instance

D.

matching the database identifier (DBID) of the source database and the duplicate database

E.

creating an SPFILE for the target database

Page: 8 / 10
Total 263 questions
Get 1z0-067 Full Access Download 1z0-067 PDF