1z0-034 | The Leading Guide To 1z0-034 pdf
Q71. View the Exhibit and examine the steps that you executed to create a database resource plan.
Subsequently, you execute the following procedure which results in an error:
SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );
What could be the reason?
A. The pending area is automatically submitted after the plan creation
B. The procedure must be executed before creating the resources plan directive
C. The SYS_GROUP resource consumer group is not included in the resource plan directive
D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive
Answer: D
Q72. Which steps are mandatory to enable Direct NFS?
1. Mount all required file systems using the kernel NFS driver.
2. Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.
3. Replace the ODM library libodm11.so_stub with libodm11.so.
A. 2 and 3
B. 1 and 3
C. 1 and 2
D. 1, 2 and 3
Answer: B
Q73. You execute these RMAN commands:
BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST;
What will these commands do?
A. create a backup of the database and recover all corrupted blocks found in the backup
B. perform a backup validation and list all logically and physically corrupt blocks in the database
C. perform a backup validation and populate the memory structure used by the vscopy_corruption view with details of any corrupt blocks found
D. perform a backup validation and populate the memory structure used by the vsDATABASE_BLOCK_CORRUPTION view, then recover any corrupt blocks
E. create an image copy of the database and recover all corrupted blocks found in the image copy
Answer: D
Reference: http://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta010.htm
Q74. 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.
Answer: B,C
Q75. You executed the following command In Recovery Manager {RMAN):
RMAN>REPORTNEEDBACKUPdays 3;
What is the output of this command?
A. a list of files that require a backup within three days
B. a list of files requiring more than 3 days of archive logs to apply
C. a list of files that RMAN recommends be backed up only once in every three days, based on low volatility
D. a list of files for which a backup has already been performed in the last three days and which is required tobe backed up again based on the high number of transactions performed on them
Answer: B
Using RMAN REPORT NEED BACKUP with Different Retention Policies (link)
You can specify different criteria for REPORT NEED BACKUP, using one of the following forms of
the command:
REPORT NEED BACKUP RECOVERY WINDOW OF n DAYS
Displays objects requiring backup to satisfy a recovery window-based retention policy
REPORT NEED BACKUP REDUNDANCY n
Displays objects requiring backup to satisfy a redundancy-based retention policy
REPORT NEED BACKUP DAYS n
Displays files that require more than n days' worth of archived redo log files for recovery
REPORT NEED BACKUP INCREMENTAL n
Displays files that require application of more than n incremental backups for recovery
Q76. Your database is open and running in ARCHIVELOG mode.
You take RMAN full backups every Sunday night.
On Monday morning, while querying the user1.emoloyees table, you receive the following error message:
01578: ORACLE data block corrupted (file # 5, block # 51) ORA-0lll0: data file 5: '/u01/app/oracle/oradata/orcl/exanple0l.dbf*
You need to recover from this while ensuring that:
1. The data file remains online.
2. Mean Time To Recover (MTTR) is minimized as much as possible
You have no backup control file, but all the archived logs are accessible. Which method will best satisfy the requirements?
A. flash back the corrupted blocks
B. use the DBMS_REPAIR package
C. use RMAN tablespace point in time recovery
D. use the RMAN BLCCKRECOVER command
E. perform a table point in time recovery with datapump export and import
Answer: D
Q77. Which option must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?
A. New channels for restore and recovery tasks
B. New name for the data files of the tablespace
C. Auxiliary name for the data files of the tablespace
D. Auxiliary destinations for an auxiliary set of data files
Answer: D
Q78. What two are the prerequisites for enabling Flashback Database?
A. The database must be in ARCHIVELOG mode
B. The database must be in MOUNT EXCLUSIVE mode
C. The database must be opened in RESTRICTED mode
D. The database instance must be started in the NOMOUNT state
E. The database instance must have the keep buffer pool defined
Answer: A,B
Q79. Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)
A. The ADR base keeps all diagnostic information in binary format
B. SQL*Plus provides the ADRI script, which can be used to work with ADR
C. The ADR can be used for problem diagnosis only when the database is open
D. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
E. The ADR can be used for problem diagnosis even when the database instance is down
F. The ADR base is shared across multiple instances
Answer: E,F
Q80. Examine the following ALTER command:
SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;
What is the purpose of the command?
A. It cancels all pending disk drops within the disk group.
B. It adds previously dropped disks back into the disk group.
C. It restores disks that are being dropped as the result of a DROP DISKGROUP operation.
D. It mounts disks in the disk group for which the drop-disk operation has already been completed.
E. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed.
Answer: A