Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP: 1z0-034 Exam Premium File as PDF & Test Engine

Whether you study best on paper or on screen, Fast2test has a Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP format that fits: a printable PDF, a desktop test engine for Windows, and an online test engine that runs in any browser. All three cover the same 148 1z0-034 practice questions.

Oracle 1z0-034 Exam Overview:

Oracle 1z0-034 Exam Syllabus Topics:

Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP Exam FAQs and Straight Answers

Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP Sample Questions:

Question 1

The DB_BLOCK_CHECKING parameter is set to FULL.
What checks occur each time the DBWnprocess(es) writes?

A. The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through the data on each block, making sure the data is self-consistent.
B. The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through the data on each block, making sure the data is self-consistent.
C. The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by going through the data on each block, making sure the data is self-consistent.
D. The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.
E. The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.

Question 2

Examine the following command to create an external table from EMPLOYEES and DEPARTMENTS database tables.
1.CREATE TABLE employee_ext
2.(employee_id, first_name, department_name)
3.ORGANIZATION EXTERNAL
4.(
5.TYPE ORACLE_LOADER
6.DEFAULT DIRECTORY ext_dir
7.LOCATION ('emp1.dmp')
8.)
9.PARALLEL
10.
AS
11.
SELECT e.emplyee_id, e.first_name, e.last_name, d.department_name
12.
FROM employees e, departments d;
Which line of the command would cause an error?

A. line 7, because file name must have a .dat extension
B. line 5, because ORACLE_LOADER is not a valid structure for external table creation with the SELECT statement
C. line 12, because there is no join defined between EMPLOYEES and DEPARTMENTS table
D. line 3, because ORGANIZATION EXTERNAL has been specified
E. line 2, because the column names have been specified
F. line 9, because the PARALLEL option cannot be specified with one file name

Question 3

Which three tasks can be performed using a duplicate database? (Choose three.)

A. Testing the effect of an application changes on database performance
B. Testing the backup and recovery procedures
C. Testing the upgrade of an Oracle database to a new release
D. Continuously updating archive log files from the target database to support failover

Question 4

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 backups control file, perform complete recovery, and open the database with theRESETLOGS option.
B. Restore the latest backup control file, perform incomplete recovery using backup control file, and open thedatabase with the RESETLOG option.
C. Restore the latest whole backup, perform complete recovery, and open the database
--- --
normally
D. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGSoption.

Question 5

You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped. On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that.
So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted
the database. Identify the next set of commands that are required to accomplish the task?

A. Option B
B. Option A
C. Option D
D. Option C

Solutions: