[Q61-Q79] Real Oracle 1Z0-066 Exam Questions [Updated 2022]

4.5/5 - (2 votes)

Real Oracle 1Z0-066 Exam Questions [Updated 2022]

1Z0-066 Exam Dumps Pass with Updated 2022 Oracle Database 12c: Data Guard Administrator

Oracle 1Z0-066 Exam Syllabus Topics:

Topic	Details
Topic 1	Explain the applicability between physical and logical standby and snapshot databases Using Temporary Undo. Global Sequences and Session Sequences
Topic 2	Creating a Physical Standby Database by Using SQL and RMAN Commands Explain Data Guard use with the Oracle Multi-tennant databases
Topic 3	Creating a Physical Standby Database by Using Enterprise Manager Cloud Control Create a Data Guard broker configuration
Topic 4	Managing Archive Redo Logs in a Data Guard Environment Managing Oracle Net Services in a Data Guard Environment
Topic 5	Enable RMAN block change tracking for a physical standby database Describe the Architecture of Oracle Data Guard
Topic 6	Using Application Continuity in a Data Guard Environment Use Real-time Query to access data on a physical standby database

Oracle 1Z0-066 Dumps

Oracle 12c Dumps are tests created to demonstrate all the features of our Oracle 12c Questions Web Simulator. You will be able to access to many questions and will have the ability to test your knowledge on-line.

There are several components you can interact with when you take our practice exams:

Navigate the Oracle 12c Questions using the “Previous” and “Next” buttons.
Start now our 1Z0-066 exam dumps on-line Simulator.
if you want to take a look at the correct answers for a question, just click the “Solution” button. In the solution section you will be able to check your answers as well as find a full explanation.
Keep an eye on the countdown. This will tell you how much time is left. When the countdown expires, the test will be automatically submitted.
Mark the Oracle 12c Certification Questions you wish to review later. All the questions you have marked will be listed in the right section “marked questions”. You will be able to jump directly to the question from this list.
Take a look at the progress bar at the top; it will tell how you are progressing throughout the exam.

QUESTION 61
Examine this query and its output:

Which are true?

The observer is not connected to the database on which the query was executed.

Cats is a bystander database.

The observer is connected to the database on which the query was executed.

The observer is currently running on o17.example com

The observer is not running, but should run on o17 example.com .

QUESTION 62
Which two are true about the creation of a Data Guard Broker configuration?

in a broker configuration, the primary database name must match the
DB_UNIQUE_NAME value in the database initialization parameter file.

A primary database profile may be added to the configuration prior to creating the primary database.

A standby database profile may be added to the configuration prior to creating that standby database.

A newly created broker configuration requires at least one standby database profile to be specified at the time the configuration is created.

A newly created broker configuration is in the disabled state

QUESTION 63
Your Data Guard environment has one physical standby database using Real-Time Query.
Two sentences have been created by these SQL statements:
create sequence a global;
create sequence b session;
Neither sequence has been used since being created.
Session 1 connects to the primary database instance and issues these two SQL statements:
SELECT a.nextval FROM DUAL;
SELECT b.nextval FROM DUAL;
Then session 2 connects to the physical standby database instance and issues the same SQL statements.
What output will be seen for session 2?

Option A

Option B

Option C

Option D

QUESTION 64
You have a Data Guard Broker configuration called ‘Somewhere’ as shown:
DGMGRL> SHOW CONFIGURATION;
Configuration ‒ Somewhere
Protection Mode: MaxPerformance
Databases:
Nearby ‒ Primary database
FS ‒ Far Sync
Farout ‒ Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
You then run this command:
DGMGRL > SHOW DATABASE ‘Nearby’ ‘InconsistentProperties’;
Which two are true about the output of this DGMGRL command? (Choose two.)

A far sync instance cannot have inconsistent properties because it has no database.

It shows all properties whose broker configuration values for database Nearby are inconsistent with the broker configuration values for database Farout.

It shows all properties whose broker configuration values for database Nearby are inconsistent with the values in the corresponding server parameter file or the runtime values for database instance Nearby.

Any inconsistency reported is on an instance-specific basis.

QUESTION 65
Which two are true about the usage of DBMS_ROLLING?

The leading group contains the original primary database.

The trailing group contains the original primary database.

The background process DMON must be enabled on all database instances that take part in the rolling release upgrade process.

At least one logical standby database must be part of the initial Data Guard configuration.

The trailing group can contain standby databases that will protect the original primary database during the rolling release upgrade process.

QUESTION 66
You edit the DGConnectIdentifier database property using the edit database set property DGMGRL command.
Which two are effects of this change?

The fal_client database initialization parameter on all standby databases is updated with the new value.

The service attribute of the log_archive_dest_n initialization parameter for any database referring to the specified database is updated with the new value.

The fal_client database initialization parameter for the specified database is updated with the new value.

The broker configuration must be disabled and then enabled to use the new connection property.

The service attribute of the log_archive_dest_n initialization parameter referring to all standby databases is updated with the new value.

QUESTION 67
A query on the view DBA_LOGSTBY_UNSUPPORTED on your primary database returns no rows.
As a result of this, you decide that an upgrade may use logical standby databases.
Which two are true about upgrading Data Guard environments consisting of one logical standby database running on a separate host from the primary? (Choose two.)

The upgrade always requires downtown until the upgrade of the logical standby is completed.

Using manual upgrade, catctl.pl can be executed in some cases on the primary and standby database simultaneously.

The upgrade always required downtime until the upgrade of the primary is completed.

Using manual upgrade, catupgr.sql needs to run on the primary database only.

SQL Apply on the local standby database must be stopped while the primary database is upgraded.

Fast-Start Failover can be used to protect the primary database during the upgrade.

QUESTION 68
You have a Data Guard Broker configuration called Somewhere’ as shown:

Which two are true about the output of this DGMGRL command?

A far sync instance cannot have inconsistent properties because it has no database.

It shows all properties whose broker configuration values for database Nearby are inconsistent with the
broker configuration values for database Farout.

It shows all properties whose broker configuration values for database Nearby are inconsistent with the
values in the corresponding server parameter file or the runtime values for database instance Nearby.

Any inconsistency reported is on an instance-specific basis.

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

Which is true regarding the execution ofthe UNSKIP procedure?

it succeeds only if SQL apply is stopped before deleting the SQL Apply filter

it succeeds but the SQL Apply fitters are not deleted.

It deletes both the SQL Apply filters.

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

it succeeds only if all DML statements executed on the primary have been applied on the logical
standby

QUESTION 70
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?

The upgrade requires downtime until the upgrade of the standby is completed.

The broker must be disabled during the upgrade.

With manual upgrade, catupgrd.sq1 can be executed on the primary and standby databases simultaneously.

The upgrade requires downtime until the upgrade of the primary is completed.

The new release of the Oracle Software must be installed on both the primary and standby database hosts.

Redo Apply on the standby database must be stopped while the primary database is upgraded.

Fast-Start Failover can be used to protect the primary database during the upgrade.

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

They are required on a logical standby for real-time apply

They are required only for synchronous redo transport.

Only standby databases can write redo to them.

It is recommended to have them on the primary database.

They are required on a physical standby for real-time apply.

The LGWR process writes to them on a standby database.

QUESTION 72
Which two are true about the creation of a Data Guard Broker configuration? (Choose two.)

In a broker configuration, the primary database name must match the DB_UNIQUE_NAME value in the database initialization parameter file.

A primary database profile may be added to the configuration prior to creating the primary database.

A standby database profile may be added to the configuration prior to creating that standby database.

A newly created broker configuration requires at least one standby database profile to be specified at the time the configuration is created.

A newly created broker configuration is in the disabled state.

QUESTION 73
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 primary database with three physical standby databases

a primary database with one logical and two physical standby databases

a primary database with one logical standby database

a primary database with one logical and one physical standby database

a primary database with two physical standby databases

a primary database with one physical standby database

QUESTION 74
Examine the Data Guard configuration:

Which three will be true after a successful failover to Cats?

Sheep will be in the disabled state.

Sheep will be in the enabled state.

Dogs will be in the disabled state and has to be manually reinstated

The configuration will be in Maximum Performance mode.

The configuration will be in Maximum Availability mode.

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

It can be used for database rolling release upgrades.

It can be used to replicate a single pluggable database (PDB) in a multitenant container database.

It can be used as an updatable database for Real Application testing and then converted back to a standby database without affecting the updates.

It can be used for reporting workloads requiring additional indexes or materialized views or both.

It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.

It can be used for testing patches without affecting the primary database.

QUESTION 76
Attempting to start the observer raises an error:
DGMGRL> start observer:
DGM-16954: Unable to open and lock the Observer configuration file Failed.
Identify two possible ways to start the observer successfully. (Choose two.)

Set the Observer Override property to TRUE before starting the observer.

Create a broker configuration and enable Fast-Start Failover before starting the observer.

Start the observer using a different observer configuration file.

Start the observer in a different working directory.

Enable Fast-Start Failover before starting the observer.

QUESTION 77
Which four statements are true regarding SQL Apply filters for a logical standby database?

They can be used to skip execution of DML triggers on a table while allowing the DML to execute.

They can be used to skip ALTER SYSTEM and ALTER DATABASE commands.

They can be used to stop SQL apply if it encounters an error.

They can be used to skip all SQL statements executed on a specific pluggable database (PDB) within a standby multitenant container database (CDB).

They can only be used to skip DML statements on a table.

They can be used to skip ALTER TABLE commands on a specific tables.

They can be used to skip CREATE TABLE commands.

QUESTION 78
There are currently 6 APPLIER and 6 PREPARER processes running and no idle APPLIER processes on your logical standby database.
The MAX_SERVERS SQL apply parameter and number of archiver processes are both set to 12.
Identify two changes, each of which would allow you to increase the number of APPLIER processes.

Increase the PROCESSES initialization parameter

Increase the value for the MAX_SERVERS SQL apply parameter.

Decrease the number of archiver processes on the standby database.

Increase the PARALLEL_MAX_SERVER initialization parameter

Decrease the number of PREPARER processes

Increase the RECOVERY_PARALLELISM initialization parameter

QUESTION 79
Examine the Data Guard configuration:
DGMGRL > show configuration:
Configuration – Animals
Protection Mode: MaxAvailability
Databases:
dogs Primary database
cats Snapshot standby database
sheep Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status:
ORA-01034: ORACLE not available
ORA-16625: cannot reach database “dogs”
DGM-17017: unable to determine configuration status
Which three will be true after a successful failover to Cats? (Choose three.)