Free 1Z0-034 Exam Dumps PDF Preview

Question 1

Multiple choice

Which two statements are true about a job chain? (Choose two.)

A
A job chain can contain a nested chain of jobs.
B
The jobs in a job chain cannot have more than one dependency.
C
A job of the CHAIN type can be run using event-based or time-based schedules.
D
The jobs in a job chain can be executed only by using the events generated by the Scheduler

Reveal answer details Close answer details

Correct answersA, C

Question 2

Multiple choice

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

Reveal answer details Close answer details

Correct answersB, C

Question 3

Multiple choice

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

Reveal answer details Close answer details

Correct answersB, C, E

Question 4

Single choice

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.

Reveal answer details Close answer details

Correct answerD

Question 5

Multiple choice

Identify two options that Oracle recommends while configuring the backup and recovery environment for
your recovery catalog. (Choose two.)

A
configuring control file autobackup to be ON
B
backing up data filed only and not the archived redo log files
C
running the recovery catalog database in NOARCHIVELOG mode.
D
setting the retention policy to a REDUNDANCY value greater than 1
E
backing up the recovery catalog to the same disk as that of the target database

Reveal answer details Close answer details

Correct answersA, D

Question 6

Multiple choice

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.

Reveal answer details Close answer details

Correct answersB, C, D

Question 7

Single choice

Before a Flashback Table operation, you execute the following command:

ALTER TABLE employees ENABLE ROW MOVEMENT;

Why would you need this to be executed?

A
Because row IDs may change during the flashback operation
B
Because the object number changes after the flashback operation
C
Because the rows are retrieved from the recycle bin during the flashback operation
D
Because the table is moved forward and back to a temporary during the flashback opertion

Reveal answer details Close answer details

Correct answerA

Question 8

Multiple choice

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

Reveal answer details Close answer details

Correct answersA, B

Question 9

Single choice

The Automatic Workload Repository (AWR) snapshot interval is set to 1 hour. A user of your database notifies you that the system was slow between 10:00 PM and 10:10 PM, but the Automatic Database Diagnostic Management (ADDM) analysis for the time period between 10:00 PM and 11:00 PM does not show this performance problem.

What would you suggest to analyze this performance problem for the user?

A
SQL Tuning Advisor
B
SQL Performance Analyzer
C
Active Session History report
D
AWR Compare Periods report

Reveal answer details Close answer details

Correct answerC

Question 10

Single choice

View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN session:

RMAN> BACKUP DATABASE FILESPERSET 2;

The database has seven data files.

Why is the value of %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?

A
Because the progress is reported for each data file
B
Because the progress is reported for each backup set
C
Because other RMAN sessions have issued the same BACKUP command
D
Because new data files have been added to the database while the RMAN backup is in progress

Reveal answer details Close answer details

Correct answerB

Question 11

Single choice

The DB_BLOCK_CHECKING parameter is set to FULL.

What checks occur each time the DBWnprocess(es) writes?

A
The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.
B
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.
C
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.
D
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.
E
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.

Reveal answer details Close answer details

Correct answerA

Question 12

Multiple choice

In which two situations would you rebuild an index using the ALTER INDEX----- REBUILD command?

A
to change a unique index into a non-unique index
B
to change index storage options
C
to enable index monitoring
D
to move the index to another tablespace
E
to improve performance of an INDEX CLUSTER

Reveal answer details Close answer details

Correct answersB, D

Question 13

Multiple choice

You want to perform an RMAN backup of database as a copy.

Which two factors will you consider while performing the backup operation?

A
The backup as copy can only be taken to disk
B
The backup as copy can only be taken to tape
C
Backup can be performed only when the instance is shutdown
D
Backup will constitute all used and unused blocks in the database

Reveal answer details Close answer details

Correct answersA, D

Question 14

Multiple choice

You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode.

Which two statements are true in this scenario?

A
You must shut down the database instance to perform the backups.
B
You must configure the flash recovery area (fast recovery area) for the database.
C
You can perform complete database backups without closing the database.
D
All the previous closed database backups including control files become invalid after you configure the database to ARCHIVELOG mode.

Reveal answer details Close answer details

Correct answersC, D

Question 15

Multiple choice

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*';

Reveal answer details Close answer details

Correct answersA, C

Question 16

Multiple choice

Identify three key features of Oracle Data Pump (Choose three.)

A
Data Pump can stop a running job and resume it later
B
Data Pump can perform import using database link
C
Data Pump uses absolute path instead of relative path
D
Data Pump uses relative path instead of absolute path
E
Data Pump can perform incremental and cumulative exports

Reveal answer details Close answer details

Correct answersA, B, D

Question 17

Multiple choice

Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.)

A
It bypasses the OS file system cache.
B
A separate NFS interface is required for use across Linux, UNIX, and Windows platforms.
C
It uses the operating system kernel NFS layer for user tasks and network communication modules.
D
File systems need not be mounted by the kernel NFS system when being served through Direct NFS.
E
Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver.

Reveal answer details Close answer details

Correct answersA, E

Question 18

Single choice

Examine the following RMAN command:

RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS
ARCHIVELOG;

Which perquisite must be met before accomplishing the backup?

A
Provide a password for the encryption.
B
Set up an Oracle wallet for the encryption.
C
No setup is required as it is a default encryption method.
D
Both Oracle wallet and password must be set up for the encryption.

Reveal answer details Close answer details

Correct answerB

Question 19

Multiple choice

Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)

A
Flash recovery area must be defined
B
Undo retention guarantee must be enabled.
C
Database must be running in archivelog mode.
D
Automatic undo management must be enabled.
E
The tablespace in which the Flashback Data Archive is created must have automatic segment spaceManagement (ASSM).

Reveal answer details Close answer details

Correct answersD, E

Question 20

Multiple choice

You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is (jetting filled up very fast and it is running out of space. Your database flash recovery area is low on specie and you have no more room on disk.

Proactively, which two options could you use to make more space available in the flash recovery [Choose two]

A
Change the RMAN archived log deletion policy.
B
Use the RMAN CROSSCHECK command to reclaim the archived log space.
C
Change the RMAN retention policy to retain backups for a shorter period of time.
D
Use OS command to move files from the flash recovery area to some other location

Reveal answer details Close answer details

Correct answersB, D

Question 21

Single choice

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.

Reveal answer details Close answer details

Correct answerA

Question 22

Single choice

Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace. A user issues a query on the orders table and receives the following error:

ERROR at line I: ORA-0I565: error in identifying file '/u01/app/oracle/oradata/TEST/temp01.

tmp' ORA-27037: unable to obtain file status What would be the most efficient way to rectify this error?

A
Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.
B
Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
C
Allow the database to continue running, drop the temp01.tmp temporary file, and then re-create it with new tempfiles.
D
Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.

Reveal answer details Close answer details

Correct answerA

Question 23

Single choice

ENCRYPT_TS is an encrypted tablespace that contains tables with data.

Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

A
The data is decrypted during SORT and JOIN operations.
B
The data remains encrypted when it is read into memory.
C
The data remains encrypted when it is stored in the redo logs.
D
The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

Reveal answer details Close answer details

Correct answerC

Free 1Z0-034 Exam Dumps Preview

Upgrade Oracle9i/10g OCA to Oracle Database OCP

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11

QUESTION 12

QUESTION 13

QUESTION 14

QUESTION 15

QUESTION 16

QUESTION 17

QUESTION 18

QUESTION 19

QUESTION 20

QUESTION 21

QUESTION 22

QUESTION 23

VOL	TYPE	QUESTIONS
1	Single choice	9
2	Multiple choice	14