Oracle 1Z0-034 Online Practice Questions and Exam Preparation

Oracle 1Z0-034 Online Questions & Answers

• Question 41:

  In Recovery Manager (RMAN), you are taking Image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy.

  Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?

  A. using only the RMAN SWITCH command to set the new location for the data file
  B. placing the database in the MOUNT state for the restore and recovery operations.
  C. using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.
  D. configuring two channels: one for the restore operation and the other for the recovery operation
  C. using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

• Question 42:

  Evaluate the following statements:

  CREATE TABLE purchase_orders (

  po_id NUMBER(4),

  po_date TIMESTAMP,

  supplier_id NUMBER(6),

  po_total NUMBER(8,2),

  CONSTRAINT order_pk PRIMARY KEY(po_id))

  PARTITION BY RANGE(po_date) (

  PARTITION Q1 VALUES LESS THAN (TO_DATE('1-apr-2007','d-mon-yyyy'), PARTITION Q2 VALUES LESS THAN (TO_DATE('1-jul-2007','d-mon-yyyy'), PARTITION Q3 VALUES LESS THAN (TO_DATE('1- oct-2007','d-mon-yyyy'),

  PARTITION Q4 VALUES LESS THAN (TO_DATE('1-jan-2008','d-mon-yyyy')); CREATE TABLE purchase_order_items (

  po_id NUMBER(4) NOT NULL,

  product_id NUMBER(6) NOT NULL,

  unit_price NUMBER(8,2),

  quantity NUMBER(8),

  CONSTRAINT po_items_fk FOREIGN KEY (po_id)

  REFERENCES purchase_orders(po_id))

  PARTITION BY REFERENCE(po_items_fk);

  What are the two consequences of the above statements? (Choose two.)

  A. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.
  B. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.
  C. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.
  D. The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.
  E. Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.
  B. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.
  C. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.

• Question 43:

  Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS.

  Which two actions will permit the TSPITR to work? (Choose two.)

  A. Taking the MASTERTBS tablespace offline
  B. Dropping the relationship between the tables
  C. Adding the MASTERTBS tablespace to the recovery set
  D. Putting the MASTERTBS tablespace in read-only mode
  B. Dropping the relationship between the tables
  C. Adding the MASTERTBS tablespace to the recovery set

• Question 44:

  Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?

  A. Only one nested subplan is allowed per parent plan
  B. The plans can be nested up to four levels.
  C. Nested plans only control resources used by recursive SQL
  D. Nested plans control only the degree of parallelism and I/O requests
  E. Each nested plan gets a proportion of the CPU resources assigned to its parent group.
  E. Each nested plan gets a proportion of the CPU resources assigned to its parent group.

• Question 45:

  Which three file types are managed by Data Pump jobs?

  A. out files
  B. log files
  C. alert files
  D. SQL files
  E. error files
  F. dump files
  B. log files
  D. SQL files
  F. dump files

• Question 46:

  Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)

  A. ALTER DISKGROUP misc MOUNT;
  B. ALTER DISKGROUP misc DROP DISK misc2;
  C. ALTER DISKGROUP misc CHECK ALL NOREPAIR;
  D. ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;
  E. ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';
  A. ALTER DISKGROUP misc MOUNT;
  C. ALTER DISKGROUP misc CHECK ALL NOREPAIR;

• Question 47:

  Your database is in NOARCHIVELOG mode.

  One of the two data files belonging to the SYSTEM tablespace is corrupt.

  You discover that all online redo logs have been overwritten since the last backup.

  Which method would you use to recover the data file using RMAN?

  A. Shut down the instance if not already shut down, restart in MOUNT state, restore both data files belonging to the SYSTEM tablespace from the last backup, and restart the instance.
  B. Shut down the instance if not already shut down, restart in mount state, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance.
  C. Shut down the instance if not already shut down, restart in mount state, restore all data files for the entire database from the last backup, and restart the instance.
  D. Shut down the instance if not already shut down, restart In MOUNT state, restore all data files belonging to the SYSTEM tablespace from the last backup, and restart the instance.
  E. Shut down the instance if not already shut down, restart In NOMOUNT state, restore all data files for the entire database from the last backup, and restart the instance.
  E. Shut down the instance if not already shut down, restart In NOMOUNT state, restore all data files for the entire database from the last backup, and restart the instance.

• Question 48:

  UNDO__RETENTION is set to 1000 and retention is not guaranteed. You configure the database with a fixed size undo tablespace. Which is true about undo retention in this configuration?

  A. Undo expires after 1000 seconds and is deleted.
  B. Inactive undo is retained for 1000 seconds even if new transactions fail due to lack of space in the undo tablespace.
  C. Inactive undo is retained for at least 1000 seconds if free undo space is available.
  D. Undo is retained in the UNDO tablespace for 1000 seconds, and then moved to the SYSAUX tablespace to provide read consistency.
  C. Inactive undo is retained for at least 1000 seconds if free undo space is available.

• Question 49:

  Which two statements are true regarding the functionality of the remap command in ASMCMD?

  A. It repairs blocks that have read disk I/O errors.
  B. It checks whether the alias metadata directory and the file directory are linked correctly.
  C. It repairs blocks by always reading them from the mirror copy and writing them to the original location.
  D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.
  A. It repairs blocks that have read disk I/O errors.
  D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.

• Question 50:

  In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:

  

  Which statement is true about the outcome?

  A. Only one channel is allocated and the backup is created in the flash recovery area
  B. Only one channel is allocated and the backup is created in the destination specified for channel
  C. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
  D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA
  A. Only one channel is allocated and the backup is created in the flash recovery area