1Z0-067 Online Practice Questions and Answers

You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.

Examine the table definition:

create table employees (empno number, salary number, deptid number, name varchar2(100), period for employee_time);

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

A. The valid time columns employee_time_start and employee_time_end are automatically created.

B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

C. The valid time columns are not populated by the Oracle Server automatically.

D. The valid time columns are visible by default when the table is described.

E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Identify three scenarios in which RMAN will use backup sets to perform active database duplication.

A. when the duplicate ... from active database command contains the section size clause

B. when you perform active database duplication on a database with flashback disabled

C. when you specify set encryption before the duplicate ... from active database command

D. when the number of auxiliary channels allocated is equal to or greater than the number of target channels

E. when you perform active database duplication on a database that has read-only tablespaces

You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.

You set the value of the initialization parameter resumable_timeout to 3600.

Which two statements are true?

A. A resumable statement can be suspended and resumed only once during execution.

B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.

C. A suspended statement will report an error if no corrective action has taken place during a timeout period.

D. Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.

E. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

Examine the following set of RMAN commands:

RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ; RMAN> RUN { ALLOCATE CHANNEL ch1 DEVICE TYPE DISK; EXECUTE SCRIPT arc_backup; }

Which statement is true about the RMAN RUN block execution?

A. The script is executed and both DC1 and CH1 channels are used for script execution.

B. The execution of the script fails because multiple channels cannot exist simultaneously.

C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.

D. The new channel, CH1, is ignored because a channel has been configured already.

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

A. A base recovery catalog should exist.

B. The owner of VPC cannot own recovery catalog.

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

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

E. The recovery_catalog_owner role should be granted to the virtual catalog owner.

You issue the command:

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

Which statement is true about the command?

A. It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter.

B. It creates a file that contains the SQL statement, which is required to re-create the control file.

C. It updates the alert log file with the location and contents of the control file.

D. It creates a binary backup of the control file.

Which two can be backed up by using RMAN in a database that is in ARCHIVELOG mode? (Choose two.)

A. data files while the database is in NOMOUNT state

B. data blocks in data files that have changed since the previous backup

C. PFILE and password file in MOUNT state

D. data files while the database is open

E. online redo log files while the database is open

Examine the RMAN command:

RMAN> RUN {

ALLOCATE CHANNEL c1 DEVICE TYPE sbt;

ALLOCATE CHANNEL c2 DEVICE TYPE sbt;

ALLOCATE CHANNEL c3 DEVICE TYPE sbt;

BACKUP

INCREMENTAL LEVEL = 0

(DATAFILE 1, 4, 5 CHANNEL c1)

(DATAFILE 2, 3, 9 CHANNEL c2)

(DATAFILE 6, 7, 8 CHANNEL c3)

SQL `ALTER SYSTEM ARCHIVE LOG CURRENT';

}

Which statement is true about the command? (Choose the best answer.)

A. It uses multisection backup.

B. It uses parallelization for the backup set.

C. It uses asynchronous I/O for the backup.

D. It creates compressed backup sets.

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.

You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo? (Choose two.)

A. Temporary undo reduces the amount of undo stored in undo tablespaces

B. Performance improves because less redo is written to the redo log

C. Performance improves because no redo and undo are generated for the temporary tables

D. Performance improves because data manipulation language (DML) operations performed on temporary tables do not use the buffer cache