1Z0-063 Online Practice Questions and Answers

You want to create a guaranteed restore point for one of your databases by executing the command:

SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;

Which two are required for the successful execution? (Choose two.)

A. The database must be in ARCHIVELOG mode.

B. Flashback Database must be enabled.

C. The Fast Recovery Area must be configured.

D. The database must be mounted.

E. Undo retention guarantee must be enabled.

F. The database must be opened.

You plan to upgrade a production database running in NOARCHIVELOG mode that has no Fast Recovery

Area configured.

The upgrade must be reversable within as quickly as possible with the smallest overhead.

Which three steps must you perform before you start the upgrade? (Choose three.)

A. Configure a flashback retention target and the Fast Recovery Area.

B. Configure the Fast Recovery Area.

C. Configure the database in ARCHIVELOG mode.

D. Create a normal restore point.

E. Take a database backup.

F. Create a guaranteed restore point.

Which three statements are true about using RMAN without a recovery catalog? (Choose three.)

A. No archive log deletion policies will be possible.

B. The REPORT SCHEMA command will report only the current database schema.

C. CONTROL_FILE_RECORD_KEEP_TIME may need to be increased.

D. The RMAN backup retention can only be configured to use a redundancy based policy.

E. Database duplication will require a connection to the target.

F. CONTROL_FILE_RECORD_KEEP_TIME may need to be decreased.

Examine the command and its output:

SQL> DROP TABLE EMPLOYEE; SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin; RECYCLE_NAMEORIGINAL_NAMETYPE binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE

You then successfully execute the command:

SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP;

Which two statements are true? (Choose two.)

A. It flashes back the employee table and all the constraints associated with the table.

B. It automatically flashes back all the indexes on the employees table.

C. It automatically flashes back any triggers defined on the table.

D. It flashes back only the structure of the table and not the data.

E. It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.

When is the UNDO_RETENTION parameter value ignored by a transaction?

A. when the data file of the undo tablespace is autoextensible

B. when there are multiple undotablespaces available in a database

C. when the undo tablespace is of a fixed size and retention guarantee is not enabled

D. when Flashback Database is enabled

A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance? (Choose three.)

A. Set the backup_tape_io_slaves parameter to true.

B. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.

C. Configure large pool if not already done.

D. Remove the rate parameter, if specified, in the allocate channel command.

E. Always use RMAN compression for tape backups rather than the compression provided by media manager.

F. Always use synchronous I/O for the database.

Examine the command:

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;

In which two scenarios is this command required? (Choose two.)

A. The current online redo log file is missing.

B. A data file belonging to a noncritical tablespace is missing.

C. All the control files are missing.

D. The control file backup is older than the database backup.

E. All the data files are missing.

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? (Choose three.)

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.

Which three types of failures are detected by the Data Recovery Advisor (DRA)? (Choose three.)

A. loss of a non-critical data file

B. loss of a control file

C. physical data block corruption

D. logical data block corruption

E. loss of an archived redo log

Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN? (Choose three.)

A. The compatible initialization parameter is set to 10.2 or higher.

B. There are no guaranteed restore points defined for the database.

C. The default device for the backup must be set to disk.

D. The tablespaces are locally managed.

E. The fast recovery area is less than 50 percent free.