1Z0_067 questions • Exam prepare

Exam contains 176 questions

Page 11 of 30

Question 61 🔥

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.quantityFROM orders o,productsp,order_itemsiWHERE 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?

Which database solution meets these requirements?

Discussion of the question

Question 62 🔥

Users report this error message when inserting rows into the orders table:ERROR atline1:ORA-01654f:unable to extend index USERS.ORDERS_IND by 8in tablespace INDEXESYou determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.Which two must you do to fix this problem without affecting currently executing queries?

Which database solution meets these requirements?

A. drop and re-create the index

Highly voted

B. coalesce the orders„ind index

C. coalesce the indexes tablespace

Highly voted

D. perform an on line table rebuild using dbns_redefir.ition.

E. rebuild the index online moving it to another tablespace that has enough free space for the index

Discussion of the question

Question 63 🔥

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?

Which database solution meets these requirements?

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.

Highly voted

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.

Highly voted

Discussion of the question

Question 64 🔥

Which four actions are possible during an Online Datafile Move operation?

Which database solution meets these requirements?

A. Creating and dropping tables in the datafile being moved

Highly voted

B. Performing file shrink of the data file being moved

C. Querying tables in the datafile being moved

Highly voted

D. Performing Block Media Recovery for a data block in the datafile being moved

E. Flashing back the database

Highly voted

F. Executing DML statements on objects stored in the datafile being moved

Highly voted

Discussion of the question

Question 65 🔥

Examine the command used to perform an incremental level-0 backup:RMAN>BACKUPINCREMENTALLEVEL0DATABASE;To enable block change tracking, after the incremental level 0 backup, you issue the command:SQL>ALTERDATABASEENABLEBLOCKCHANGETRACKINGUSINGFILE'/mydir/rman_change_track.f';To perform an incremental level-1 cumulative backup, you issue the command:RMAN>BACKUPINCREMENTALLEVEL1CUMULATIVEDATABASE;Which two statements are true in the preceding situation?

Which database solution meets these requirements?

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.

Discussion of the question

Question 66 🔥

Which two statements are true about scheduling operations in a pluggable database (PDB)?

Which database solution meets these requirements?

A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.

B. A job defined in a PDB runs only if that PDB is open.

C. Scheduler attribute setting is performed only at the CDB level.

D. Scheduler objects created by users can be exported or imported using Data Pump.

E. Scheduler jobs for a PDB can be created only by common users.

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_067

Exam contains 176 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us