1z0-034 | 10 Tips For Renewal 1z0-034 exam


Q1. You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. 

One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours: 

ALTER DISKGROUP dg01 SET ATTRIBUTE *disk_repair_time' = '5h' 

To which disks in the disk group will the new value be applicable? 

A. all disks in the disk group 

B. all disks that are currently in OFFLINE mode 

C. all disks that are not currently in OFFLINE mode 

D. all disks in the disk group only if all of them are ONLINE 

Answer:

Check out the answer options, it is tricky. The NOT OFFLINE disks equals ONLINE disks. Refer to Set the DISK_REPAIR_TIME Disk Group Attribute Appropriately. The DISK_REPAIR_TIME disk group attribute specifies how long a disk remains offline before Oracle ASM drops the disk. If a disk is made available before the DISK_REPAIR_TIME parameter has expired, the storage administrator can issue the ONLINE DISK command and Oracle ASM resynchronizes the stale data from the mirror side. In Oracle Database 11g, the online disk operation does not restart if there is a failure of the instance on which the disk is running. You must reissue the command manually to bring the disk online. 

Q2. View the Exhibit and examine the RMAN commands. 

Which statement describes the effect of a backup retention policy on the backup of a backup set? 

A. Either all the copies of a backup set are obsolete or none of them are as per the retention policy. 

B. The copies of the backup will be reported as obsolete under a redundancy-based backup retention policy. 

C. The copies of the backup will be reported as obsolete under a recovery window-based backup retentionpolicy. 

D. All the copies of the backup set are counted as one instance of a backup and will deleted in backup setexceeds the redundancy-based backup retention policy. 

Answer:

Q3. View the Exhibits exhibit1 and exhibit2. 

Both the processes use PROG_1 as the job template that is already available. The time taken by the jobs are recorded in the TEST_LOG table. While comparing the time taken to create the jobs, the process in exhibit1 takes less time than the process in exhibit2. 

What is the reason for this? 

lightweight-job-1 (exhibit): 

lightweight-job-2 (exhibit): 

A. It updates several tables in the SYSTEM tablespace instead of creating new tables. 

B. It creates jobs temporarily in memory only. 

C. It creates less metadata for the jobs. 

D. It writes the job metadata to disk in compressed format. 

Answer:

The difference between two blocks of code is the "JOB_STYLE". The lightweight job creates less metadata for the jobs. 

Q4. Which statement is true about a Scheduler-generated event? 

A. It can be generated when a file arrives on the file system. 

B. it indicates state changes that occur within the Scheduler itself. 

C. it is raised by an application that is consumed by the Scheduler to start a job. 

D. it requires jobs to be defined with an event condition and a queue specification. 

Answer:

Consuming Job State Events with your Application To consume job state events, your application must subscribe to the Scheduler event queue SYS.SCHEDULER$_EVENT_QUEUE. This queue is a secure queue and is owned by SYS. To create a subscription to this queue for a user, do the following: 

1. Log in to the database as the SYS user or as a user with the MANAGE ANY QUEUE privilege. 

2. Subscribe to the queue using a new or existing agent. 

3. Run the package procedure DBMS_AQADM.ENABLE_DB_ACCESS as follows: 

DBMS_AQADM.ENABLE_DB_ACCESS(agent_name, db_username); where agent_name references the agent that you used to subscribe to the events queue, and db_username is the user for whom you want to create a subscription. 

There is no need to grant dequeue privileges to the user. The dequeue privilege is granted on the 

Scheduler event queue to PUBLIC. 

Q5. Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.) 

A. It can be used to allow the access privilege settings for users but not roles. 

B. It can be used to allow the access privilege settings for users as well as roles. 

C. It can be used to control the time interval for which the access privilege is available to a user. 

D. It can be used to selectively restrict the access for each user in a database to different host computers. 

E. It can be used to selectively restrict a user's access to different applications in a specific host computer. 

Answer: B,C,D 

Q6. User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions? 

A. ALTER DATABASE FLASHBACK ON; 

B. GRANT SELECT ANY TRANSACTION TO scott; 

C. GRANT EXECUTE ON dbms_flashback TO scott; 

D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; 

E. ALTER TABLESPACE undots1 RETENTION GUARANTEE; 

F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS; 

Answer: B,C,D,F 

Q7. The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery? 

A. Inactive and current redo log files are required to accomplish recovery 

B. Online and archived redo files are required to accomplish instance recovery 

C. All redo log entries after the last checkpoint are applied from redo log files to data files 

D. All redo log entries recorded in the current log file until the checkpoint position are applied to data files 

Answer:

Q8. You executed the following commands: 

SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false; 

SQL> EXECUTE DBMS_STATS. SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false'); 

SQL> EXECUTE DBMS_STATS. GATHER_TABLE_STATS ('SH' , 'CUSTOMERS'); 

Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session? 

A. The statistics are stored in the pending statistics table in the data dictionary. 

B. The statistics are treated as the current statistics by the optimizer for all sessions. 

C. The statistics are treated as the current statistics by the optimizer for the current sessions only. 

D. The statistics are temporary and used by the optimizer for all sessions until this session terminates. 

Answer:

Q9. Which three elements can a job chain process involve? (Choose three) 

A. an event 

B. a schedule 

C. a program 

D. another chain 

E. a lightweight job 

Answer: B,D,E 

Don't really understand the answer so far. 

Defining Chain Steps 

After creating a chain object, you define one or more chain steps. Each step can point to one of the following: 

Q10. You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema. 

You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows: You then issue the following statement to recover the table: 

SQL> SELECT object_name, original_name, droptime FROM recyclebin; 

What would be the outcome of the precedent statement? 

A. It retrieves the latest version of the table from the recycle bin 

B. It retrieves the oldest version of the table from the recycle bin 

C. It retrieves the version of the table for which undo information is available 

D. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column 

Answer: