1z0-067 sample questions

Question 1

RMAN is configured to create backupset backups for your database. You issue the command to back up the database: RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

Which two statements are true about the backup performed by the command? (Choose two.)

Accepted Answer

It backs up all the archived log files and deletes the ones that were just backed up

Accepted Answer

Only the used blocks in the data files are backed up

Answer

|t backs up all the data files and deletes obsolete backups after the backup is complete

Answer

|t backs up all archived redo log files and online log files and deletes the archived log files after the backup is complete

Answer

It backs up only those archived log files that are not backed up at least once

Question 2

Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

Accepted Answer

The DBA role should be granted to the virtual catalog owner.

Accepted Answer

A base recovery catalog should exist.

Accepted Answer

The register database privilege should be granted to the virtual catalog owner.

Answer

At least one target database should be registered in the recovery catalog.

Answer

The owner of VPC cannot own recovery catalog.

Question 3

Identify three benefits of unified auditing.

Accepted Answer

It automatically audits Recovery Manager (RMAN) events.

Accepted Answer

An audit trail cannot be modified because it is read-only.

Accepted Answer

It reduces overhead on a database caused by auditing, by having a single audit trail.

Answer

|t guarantees zero-loss auditing.

Answer

|t helps to reduce disk space used to store an audit trail in a database.

Question 4

On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:
S>sqlldrhr/hr@pdb table=employees

Which two statements are true about the command?

Accepted Answer

It fails if the hr user does not have the create any directory privilege.

Accepted Answer

|t succeeds with default settings if the employees table exists in the hr schema.

Answer

|t fails because no SQL*Loader data file location is specified.

Answer

|t fails because no SQL*Loader control file location is specified.

Answer

|t succeeds and creates the employees table in the HR schema.

Question 5

You execute the RMAN commands: RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2; RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT ‘7disk/%U’; RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT ‘7disk/%U’; RMAN> BACKUP DATABASE;

Which statement is true about the backup set created by the BACKUP command?

Accepted Answer

Two channels are allocated and backup pieces for the backup set are created in both the specified destinations

Answer

Two channels are allocated and a copy of the backup set is taken in the location specified by CHANNEL 2

Answer

Two channels are allocated and two copies of the backup set are taken in parallel in both locations

Answer

The default channel is allocated and the backup set is created in only one destination

Question 6

Which two statements are true about Flashback Version Query?

Accepted Answer

|t retrieves all versions of rows that exist in a time interval, including the start time and end time.

Accepted Answer

|t can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.

Answer

|t can be used only if Flashback Data Archive is enabled for a table.

Answer

It can be used to create views.

Answer

The result of a query can be used as part of a DML statement.

Question 7

Which two statements are true regarding SecureFile lobs?

Accepted Answer

Fragmentation is minimized by using variable-sized chunks.

Accepted Answer

They support random reads and writes of encrypted LOB data.

Answer

The amount of undo retained is user controlled.

Answer

They can be used only for nonpartitioned tables.

Question 8

You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?

Accepted Answer

The backup must be performed in mount state.

Answer

The database must be backed up as an image copy.

Answer

All files must be backed up as backup sets.

Answer

The tablespace must be taken offline.

Question 9

During the day, your database must support an OLTP workload that requires a large database buffer cache. At night, it must support batch jobs that require a higher value to be set for large pool.
What must you do to allow the memory pools to change size automatically as required? (Choose the best answer.)

Accepted Answer

Enable AMM and set the PRE_PAGE_SGA initialization to TRUE.

Answer

Enable Automatic Memory Management (AMM) and set the PGA_TARGET initialization parameter to a nonzero value.

Answer

Enable AMM and set the PGA_TARGET initialization parameter to a nonzero value.

Answer

Enable AMM and set the SGA_TARGET initialization parameter to a nonzero value.

Question 10

Examine the statements that use flashback technologies: 1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’); 2. SELECT * FROM customers AS OF SCN 123456; 3. FLASHBACK TABLE customers TO BEFORE DROP; 4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP (‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’);
5. SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999; 6. ALTER TABLE customers FLASHBACK ARCHIVE;

Which set of statements depends on the availability of relevant undo data in the undo tablespace? (Choose the best answer.

Accepted Answer

1,2, 5

Answer

2, 3, 5, 6

Answer

3,4,5

Answer

1,3,6

Upgrade Oracle 9i/10g/11g to Oracle Database 12c OCP Free Sample Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Register free for 10 more questions

1z0-067 Sample Questions

Register free for 10 more questions

Related practice tests