1z0-067 Oracle Exam Questions and Free Practice Test

Question 25

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?

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.

Correct Answer:BC
The following example creates a parent table orders which is range-partitioned on order_date. The reference-partitioned child table order_items is created with four partitions, Q1_2005, Q2_2005, Q3_2005, and Q4_2005, where each partition contains the order_items rows corresponding to orders in the respective parent partition. Partitions of a reference-partitioned table will collocate with the corresponding partition of the parent table, if no explicit tablespace is specified for the reference-partitioned table’s partition. The partitions of a reference-partitioned table can be named. If a partition is not explicitly named, then it will inherit its name from the corresponding partition in
the parent table. http://docs.oracle.com/cd/B28359_01/server.111/b32024/part_admin.htm#BAJDDEEC

Question 26

Examine the command to back up the ASM metadata: ASMCMD>md_backup /backup/ASM_backup
In which three situations can you use the backup?

A. when one or more disks in an ASM disk group are lost

B. when the data file on an ASM disk group gets corrupted

C. when one of the disks in a disk group is accidentally unplugged

D. when one or more file directory paths are accidentally deleted from an ASM disk group

E. when all the ASM disk groups for the ASM instance are lost

Correct Answer:ADE
http://www.hhutzler.de/blog/asm-backup-and-restore-dg-metadata/
The md_backup command creates a backup file containing metadata for one or more disk groups. i By default all the mounted disk groups are included in the backup file which is saved in the current working directory. http://docs.oracle.com/cd/E11882_01/server.112/e18951/asm_util004.htm#OSTMG94578
The md_backup command creates a backup file containing metadata for one or more disk groups.

Question 27

ENCRYPT_TS an encrypted tablespace that contains tables with data.
Which statement is true about queries and data manipulation language statements on these tables?

A. Queries may be performed on columns that have the NO SALT option.

B. Data remains encrypted when read into the buffer cache.

C. Redo generated by DML remains encrypted.

D. UNDO generated by DML remains encrypted if the UNDO tablespace is encrypted.

E. Data remains encrypted when read into the PGA for direct path read

Correct Answer:C

Question 28

On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:
S>sqlldrhr/hr@pdb table=employees
Which two statements are true about the command?

A. It succeeds with default settings if the employees table exists in the hr schema.

B. It fails because no SQL*Loader data file location is specified.

C. It fails if the hr user does not have the create any directory privilege.

D. It fails because no SQL*Loader control file location is specified.

E. It succeeds and creates the employees table in the HR schem

Correct Answer:AC
sqlldr scott/tiger@pdb1 TABLE=EMP2 DATE_FORMAT=\”DD-MON-YYYY HH24:MI:SS\” https://oraclebase. com/articles/12c/sql-loader-enhancements-12cr1

Question 29

You want to move your existing recovery catalog to another database. Examine the steps:
1) Export the catalog data by using the Data Pump Export utility in the source database.
2) Create a recovery catalog user and grant the necessary privileges in the target database.
3) Create a recovery catalog by using the create catalog command.
4) Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.
5) Import the source recovery catalog schema by using the import catalog command.
6) Connect to the destination database.
7) Connect as catalog to the destination recovery catalog schema.
Identify the option with the correct sequence for moving the recovery catalog.

A. 1, 6, 4

B. 2, 3, 7, 5

C. 1, 2, 6, 4

D. 1, 2, 3, 6, 5

Correct Answer:B

Question 30

Which two statements are true about making RMAN image copies of a database? Choose two.

A. They can be made only when the database is running in ARCHIVELOG mode.

B. They consist of all used and unused blocks in the data files.

C. They can be made only when the database is in MOUNT state.

D. They can only be written to disk.

E. They can be made only when the database is running in NOARCHIVELOG mod

Correct Answer:BD

START 1z0-067 EXAM