Oracle 1Z0-066 Free Practice Questions

NEW QUESTION 1
Your Data Guard environment consists of these components and settings:
1. A primary database supporting an OLTP workload 2 A remote physical standby database
3. Real-time query is enabled
4. The redo transport mode is set to SYNC.
5. The protection mode is set to Maximum Availability
Which two are true regarding the DelayMins Database Property for the standby database?

• A. it can only be enabled for a configuration in Maximum Performance mode.
• B. It allows user errors on the primary to be recovered by using the physical standby database.
• C. It enables you to bypass the default network timeout interval specified for the standby redo transport destination.
• D. it can only be enabled for a configuration in Maximum Availability mode.
• E. It allows logical corruptions on the primary to be recovered by using the physical standby database.
• F. It specifies a delay before the primary ships redo to the standby destination havingDelayMins set.

Answer: BF

NEW QUESTION 2
Which two are prerequisites for configuring flashback database for Oracle 12c databases, in a Data Guard environment?

• A. a flash recovery area must be configured
• B. The database must be in MOUNT state.
• C. The database must be in ARCHIVELOG mode.
• D. A far sync instance must be configured to flash back a standby when the primary has been flashed back.
• E. The Data Guard Broker must be used.

Answer: AC

NEW QUESTION 3
On your logical standby database, you specified these rules:

Which is true regarding the execution of the UNSKIP procedure?

• A. it succeeds only if SQL apply is stopped before deleting the SQL Apply filter
• B. it succeeds but the SQL Apply fitters are not deleted.
• C. It deletes both the SQL Apply filters.
• D. it returns an error because the syntax to delete a SQL Apply filter must specify the same object names as specified when the filter was added
• E. it succeeds only if all DML statements executed on the primary have been applied on the logical standby

Answer: D

NEW QUESTION 4
Which three statements are true about snapshot standby databases?

• A. Snapshot standby databases may be used for rolling release upgrades.
• B. if datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database.
• C. Flashback logs are used to convert a snapshot standby database back into a physical standby database.
• D. a snapshot standby database can have Real-Time Query enabled
• E. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.

Answer: CE

NEW QUESTION 5
A Data Guard environment has this configuration and these attributes:
1. A primary database
2. A Physical Standby Database named sbdb
3. The configuration is in maximum availability protection mode.
Then sbdb is converted to a snapshot standby database When two statements are true?

• A. Sdbd can still apply redo
• B. The recovery point objective increases
• C. The protection mode is lowered to maximum performance
• D. The recovery time objective increases.
• E. Sbdb can still receive redo

Answer: DE

NEW QUESTION 6
You created a physical standby database PRODSBY1 from the primary database PROD using SQL and RMAN Which two are prerequisites for creating a Data Guard Broker configuration to manage these databases?

• A. The standby database must have supplemental logging enabled.
• B. The primary database must have FORCE LOGGING enabled
• C. The DG_BROKER_START parameter must be set to TRUE for both database instances.
• D. The primary database must have supplemental logging enabled.
• E. A local net service name to enable connectivity to the PRODSBY1 database instance must be defined on the primary database host.

Answer: BC

NEW QUESTION 7
Examine the Data Guard configuration:

Which three will be true after a switchover to Sheep?

• A. Dogs will be an enabled logical standby database.
• B. Sheep will be the primary database.
• C. Cats will be a disabled physical standby database.
• D. Dogs will be a disabled logical standby database
• E. Cats will be an enabled physical standby database.

Answer: ABE

NEW QUESTION 8
Which two statements are true for Data Guard environments with multi-tenant databases?

• A. DB_UNIQUE_NAME must be specified differently for each pluggable database within a multi-tenant standby database.
• B. Each pluggable database within a multi-tenant physical standby database has a minimum of one associated Oracle Net service name.
• C. Each pluggable database within a multi-tenant physical standby has one MRP background process running during redo apply.
• D. A pluggable database within a multi-tenant standby database can have a different open mode than the container database
• E. A pluggable database within a multi-tenant standby database can have a different database role than the container database.

Answer: AD

NEW QUESTION 9
Which three statements are true about snapshot standby databases?

• A. Tablespaces can be dropped.
• B. Tables can be dropped
• C. The broker may be used to fail over to a snapshot standby database.
• D. A logical standby database can be converted into a snapshot standby database.
• E. Tablespaces can be created.

Answer: ABE

NEW QUESTION 10
A customer has these requirements for their potential 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?

• A. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (pnma: physt2 SYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY
• B. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 ASYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima physt FASTSYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION
• C. EDIT DATABASE prima SET PROPERY REDOROUTES^' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNCfs1 SET PROPERTY REDORUOTES=' (prima physt ASYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
• D. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES= (LOCAL: fs1. FASTSYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima: physt2 ASYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

Answer: A

NEW QUESTION 11
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?

• A. Recover the datafile by using the RMAN RECOVER DATAFILE command
• B. Restart the redo apply.
• C. Restore the datafile by using the RMAN RESTORE DATAFILE command.
• D. Stop the redo apply.
• E. Recover the database by using the RMAN RECOVER DATABASE command.

Answer: CDE

NEW QUESTION 12
You must design an Oracle Data Guard configuration for an OLTP database that meets these permanent requirements:
1. Data loss is not permitted.
2. Read-only applications should not connect to the primary database instance. Additionally, there are these requirements, only one of which is ever done at any one time:
1. It should be possible to apply designated patches with a minimum amount of downtime.
2. Upgrading to a new database release should be performed with the least possible amount of downtime.
3. New application software releases should be tested against an exact and up-to-date replica of the primary database.
Which configuration meets these requirements with the fewest databases?

• A. a primary database with three physical standby databases
• B. a primary database with one logical and two physical standby databases
• C. a primary database with one logical standby database
• D. a primary database with one logical and one physical standby database
• E. a primary database with two physical standby databases
• F. a primary database with one physical standby database

Answer: D

NEW QUESTION 13
You are licensed to use Oracle Active Data Guard
Which two statements are true after enabling block change tracking on a physical standby database?

• A. it allows fast incremental backups to be offloaded to the physical standby database
• B. It starts the CTWR process on the physical standby database instance
• C. it allows fast incremental backups to be taken on the primary database.
• D. It starts the RVWR process on the physical standby database instance.
• E. It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database in converted.
• F. It starts the CTWR process on the primary database instance.

Answer: AB

NEW QUESTION 14
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2 Three Physical Standby Databases
You must meet these requirements:
✑ A designated physical standby database should become the primary database automatically whenever the primary database falls
✑ The chosen protection mode should provide the highest level of protection
possible without violating the other requirement
Which redo transport mode and protection mode would you configure to meet these requirements?

• A. SYNC NOAFFRIM and Maximum Protection
• B. SYNC NOAFFIRM and Maximum Availability
• C. ASYNC and Maximum Performance
• D. SYNC AFFIRM and Maximum Availability
• E. SYNC AFFIRM and Maximum Protection

Answer: D

NEW QUESTION 15
Examine the Data Guard configuration:

Which three will be true after a switchover to Sheep?

• A. Dogs will be an enabled logical standby database.
• B. Sheep will be the primary database.
• C. Cats will be a disabled physical standby database.
• D. Dogs will be a disabled logical standby database
• E. Cats will be an enabled physical standby database.

Answer: ABE

NEW QUESTION 16
Which three statements are true about standby redo logs in a Data Guard configuration with no Oracle Streams or Goldengate configured?

• A. They are required on a logical standby for real-time apply
• B. They are required only for synchronous redo transport.
• C. Only standby databases can write redo to them.
• D. It is recommended to have them on the primary database.
• E. They are required on a physical standby for real-time apply.
• F. The LGWR process writes to them on a standby database.

Answer: ACE

NEW QUESTION 17
Which three are always benefits of using a logical standby database?

• A. it can be used for database rolling release upgrades
• B. it can be used to replicate a single pluggable database (PDB) in a multitenant container database.
• C. It can be used as an updatable database for Real Application testing and then converted back to a standby database without affecting the updates.
• D. It can be used for reporting workloads requiring additional indexes or materialized viewsor both.
• E. It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.
• F. it can be used for testing patches without affecting the primary database.

Answer: CDF

NEW QUESTION 18
A query on the view DBA_LOGSTDBY_UNSUPPORTED on your primary database returns several rows.
As a result of this, you decide that an upgrade may not use logical standby databases Which three are true about upgrading Data Guard environments consisting of one physical
standby database running on a separate host from the primary?

• A. The upgrade requires downtime until the upgrade of the standby is completed.
• B. The broker must be disabled during the upgrade
• C. With manual upgrade, catupgrd.sql can be executed on the primary and standby databases simultaneously.
• D. The upgrade requires downtime until the upgrade of the primary is completed.
• E. The new release of the Oracle Software must be installed on both the primary and standby database hosts
• F. Redo Apply on the standby database must be stopped while the primary database is upgraded.
• G. Fast-Start Failover can be used to protect the primary database during the upgrade.

Answer: BDE

NEW QUESTION 19
Which two statements are true for Data Guard environments with mufti-tenant databases?

• A. Different pluggable databases within a logical standby database may have different guard statuses.
• B. The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation.
• C. The Data Guard broker automatically opens all pluggable databases of a primary database a role change operation.
• D. The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standbydatabase.
• E. A multi-tenant standby database can have fewer pluggable databases than the primary container database

Answer: CD