Free Oracle 1Z0-066 Exam Actual Questions

The questions for 1Z0-066 were last updated On Nov 22, 2024

Question No. 1

A data file on one of your physical standby databases has been accidentally deleted and you must restore and recover it.

All the archive logs required for recovery are still on disk in the directory pointed to by the log_archive_dest_1 parameter.

Which three steps must be performed to restore the missing file and recover the standby database while it is in the MOUNT state? (Choose three.)

Show Answer Hide Answer
Correct Answer: C, D, E

Recovery from Loss of Datafiles on the Standby Database


Question No. 2

A customer has these requirements for their proposed Data Guard implementation:

1. Zero data loss must still be guaranteed through the loss of any one configuration component.

2. The primary database must be protected against a regional disaster.

3. Performance overheads on the primary should be minimized as much as possible given these requirements.

4. Downtime on the primary database for any reason must be kept to a minimum.

Components referred to in the broker commands are:

Which Data Guard broker commands are needed to implement these requirements?

Show Answer Hide Answer
Correct Answer: A

The route between fs1 and physical standbase in the remote region, like physt2, should be SYNC or SYNC NOAFFIRM.

Note:

Fast Sync is a new Data Guard capability available with Oracle Database 12c. Fast Sync enables use of the destination parameter NOAFFIRM which specifies that the standby acknowledge receipt of redo without waiting for the write to the standby redo log file to complete. Fast Sync can improve application response time in a SYNC configuration by removing remote I/O from the total round trip time.

Active Data Guard Far Sync Architecture


Question No. 3

Which three are always benefits of using a logical standby database? (Choose three.)

Show Answer Hide Answer
Correct Answer: C, D, F

C: A logical standby database can be used to test new software releases and some kinds of applications on a complete and accurate copy of the primary's data. It can host other applications and additional schemas while protecting data replicated from the primary against local changes.

D: A logical standby database is open read/write while changes on the primary are being replicated. Consequently, a logical standby database can simultaneously be used to meet many other business requirements, for example it can run reporting workloads that would problematical for the primary's throughput.

F: Logical standby can be used to greatly reduce downtime associated with applying patchsets and new software releases. A logical standby can be upgraded to the new release and then switched over to become the active primary. This allows full availability while the old primary is converted to a logical standby and the patchset is applied.

References:

https://docs.oracle.com/cd/E11882_01/server.112/e41134/standby.htm#SBYDB00103


Question No. 4

Which three are true concerning restoring of RMAN backups to primary and physical standby databases in a Data Guard environment? (Choose three.)

Show Answer Hide Answer
Correct Answer: C, E, F

C, F: All backup operations can be offloaded to a single standby database, except backups of the SPFILE. Backups of the SPFILE can only be restored to the database from which they were backed up.

E: RMAN restores database files, over the network, from a physical standby database.

As of Oracle Database 12c, RMAN lets you restore or recover files by connecting, over the network, to a physical standby database that contains the required files. You can restore an entire database, data files, control files, spfile, or tablespaces.

Note: An Oracle database consists of one or more logical storage units called tablespaces, which collectively store all of the database's data. Each tablespace in an Oracle database consists of one or more files called datafiles, which are physical structures that conform to the operating system in which Oracle is running.

References:

https://docs.oracle.com/database/121/SBYDB/rman.htm#SBYDB00755


Question No. 5

On your logical standby database, you specified these rules:

SQL> EXECUTE DBMS_LOGSTBY.SKIP (STMT=> 'DML', -

SCHEMA_NAME => 'HR', -

OBJECT_NAME=> 'EMP_NEW');

SQL> EXECUTE DBMS_LOGSTBY.SKIP (STMT=> 'DML', -

SCHEMA_NAME => 'HR', -

OBJECT_NAME=> 'EMP_OLD');

After completion of the weekend batch cycle you attempt to delete the SQL Apply filters:

SQL> EXECUTE DBMS_LOGSTBY.UNSKIP (STMT=> 'DML', -

SCHEMA_NAME => 'HR', -

OBJECT_NAME=> 'EMP%');

Which is true regarding the execution of the UNSKIP procedure?

Show Answer Hide Answer
Correct Answer: D

The UNSKIP procedure reverses the actions of the SKIP procedure by finding the record, matching all the parameters, and removing the record from the system table. The match must be exact, and multiple skip actions can be undone only by a matching number of unskip actions. You cannot undo multiple skip actions using wildcard characters.

References:

https://docs.oracle.com/cd/B12037_01/appdev.101/b10802/d_lsbydb.htm#997823