A Review Of Actual 1z0-034 braindumps

It is impossible to pass Oracle 1z0-034 exam without any help in the short term. Come to Actualtests soon and find the most advanced, correct and guaranteed Oracle 1z0-034 practice questions. You will get a surprising result by our Most recent Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP practice guides.


2024 Oracle Official New Released 1z0-034 ♥♥
https://www.certleader.com/1z0-034-dumps.html


Q1. Examine the following scenario: 

-Database is running in ARCHIVELOG mode. 

-Complete consistent backup is taken every Sunday. 

-On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted -The disk having active online redo log files is also corrupted. -The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure? 

A. Restore the latest whole backup, perform complete recovery, and open the database normally 

B. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGSoption. 

C. Restore the latest backups control file, perform complete recovery, and open the database with theRESETLOGS option. 

D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open thedatabase with the RESETLOG option. 

Answer:

Q2. Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)? (Choose three.) 

A. Alert log file 

B. Archived redo log files 

C. Control file autobackups 

D. Server Parameter file (SPFILE) 

E. Recovery Manager (RMAN) backup piece 

Answer: B,C,E 

Q3. 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 

Q4. View the following SQL statements: Transaction T1 

SQL> INSERT INTO hr.regions 2 VALUES (5,'Pole'); 3 COMMIT; 

Transaction T2 

SQL> UPDATE hr.regions 2 SET region_name='Poles' 3 WHERE region_id = 5; 4 COMMIT; 

Transaction T3 

SQL> UPDATE hr.regions 2 SET region_name='North and South Poles' 3 WHERE region_id = 5; You want to back out transaction T2. Which option would you use? 

A. It is possible, but transaction T3 also backs out. 

B. It is possible with the NOCASCADE_FORCE option. 

C. It is possible with the NONCONFLICT_ONLY option. 

D. It is not possible because it has conflicts with transaction T3. 

Answer:

Table 12-2 Flashback TRANSACTION_BACKOUT Options 

CASCADE 

Backs out specified transactions and all dependent transactions in a post-order fashion (that is, children arebacked out before parents are backed out). 

Without CASCADE, if any dependent transaction is not specified, an error occurs. 

NOCASCADE 

Default. Backs out specified transactions, which are expected to have no dependent transactions. 

Firstdependent transactions causes an error and appears in *_FLASHBACK_TXN_REPORT. 

NOCASCADE_FORCE 

Backs out specified transactions, ignoring dependent transactions. Server runs undo SQL statements forspecified transactions in reverse order of commit times.If no constraints break and you are satisfied with the result, you can commit the changes; otherwise, you canroll them back. 

NONCONFLICT_ONLY 

Backs out changes to nonconflicting rows of the specified transactions. Database remains consistent, buttransaction atomicity is lost. 

Q5. While exporting data with Data Pump, you find that the export takes longer than expected. You decide to stop the job and restart it during off-peak hours. 

Which view would you query to determine the name and status of the stopped job? 

A. DBA_JOBS 

B. V$SESSION 

C. V$SESSION_LONGOPS 

D. DBA_DATAPUMP_JOBS 

E. DBA_DATAPUMP_SESSIONS 

Answer:

When a Datapump Export or Import session is launched, a Datapump Job is automatically tarted. This way, we can:* detach from and reattach to long-running jobs without affecting the job itself. 

* monitor jobs from multiple locations 

* stop a job: suspend it temporarily to leave other applications requesting more resources to get them restart itlater 

* kill any Datapump job anytime 

* see the progress of the import or export operations 

REF.: Metalink Note: 262557.1 

Q6. Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.) 

A. flashback query 

B. distributed transactions 

C. logging in and logging out of sessions 

D. all DDL statements having bind variables 

E. direct path load of data from external files 

Answer: C,D 

Q7. Identify two advantages of using a recovery catalog instead of the control file of the target database in Recovery Manager (RMAN). 

A. You can use RMAN stored scripts. 

B. Recovery is faster if data is stored in catalog in addition to the control file. 

C. You can store backup information of all registered databases in one place. 

D. Database backups are automatically deleted when they are older than the specified time period. 

Answer: A,C 

Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcatdb.htm 

Q8. The database is configured in ARCHIEVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option? 

A. Control files 

B. Password file 

C. Inactive online redo log file 

D. Archived log files required to perform recovery 

E. Newly created tablespace which is not backed up 

Answer: A,D 

The RESETLOGS options is required in: 

1. Imcomplete Recovery 

2. Change of control file 

So that, the control file and archived redo logs are required. 

Q9. You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up. 

A. The data file backup is done with multiple channels 

B. The data files is in the read-write mode after being backed up in the read only mode 

C. The backup was taken after the data files was taken offline-normal or is in the read only mode 

D. The data file backup complies with the back retention policy and the backup duplexing feature 

Answer: C,D 

Q10. 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: