1Z0-066 PDF DOWNLOAD

									
										
										
Q1. 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.
Option A,D are correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com


Q2.Your Data Guard environment has two remote physical standby databases Client applications use the
local naming method to connect to the primary database instance. You want applications to
automatically connect to the new primary database instance in case of a switchover or a failover Which
will fulfill this requirement?
A. Create a database service on each standby database that is started automatically by a trigger, when
the database rote is PRIMARY, modify the connection description used by client applications to include
all the standby hosts and connect to the database instance using that service name.
B. Create a database service on the primary database that is started automatically by a trigger, when
the database role is PRIMARY, modify the connection descriptors used by client applications to include
all the standby hosts and connect to the database instance using that service name.
C. Set the INSTANCE_NAME parameter identically on all databases; modify the connection descriptor on
client applications to include all the standby hosts and connect to the database instance using that
service name.
D. Set the DB_NAME and DB_UNIQUE_NAME identical on all databases, modify the connection descriptors on
client applications to include all the standby hosts and connect to the database using that service
name.
Option A is correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com


Q3.Examine the Data Guard configuration:
DGMGRL > show configuration;
Configuration-Animals
Protection Mode MaxPerformance
Databases
dogs-Primary database sheep-Snapshot standby database cats-Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status: SUCCESS
You receive an error while attempting to raise the protection mode to Maximum Availability:
https://www.certification-questions.com/
DGMGDRL> edit configuration set protection mode as max availability;
Error ORA-16627 operation disallowed since no standby databases would remain to support protection
mode Failed.
Identify two statements that you can execute, either one of which will enable successful raising of
the protection mode to Maximum Availability.
A. DGMGRL> convert database sheep to physical standby;
B. DGMGRL> convert database cats to physical standby;
C. DGMGRL> edit database dogs set property LogXptMode= fastsync;
D. DGMGRL> edit database sheep set property LogXptMode= fastsync;
E. DGMGRL> edit database cats set property LogXptMode= sync;
Option B,E are correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com


Q4.You administer a Data Guard environment with a primary and two physical standby databases. One of
the physical standby databases is used for reporting and is on the same host as the primary database.
The other physical standby database is remote, used for disaster recovery and REDO is routed to it via
a far sync instance. Backups are offloaded to the remote physical standby. Which three are true
concerning the management of archive logs in this Data Guard configuration?
A. Archive logs on the primary database may be deleted once they are applied on all standby
databases.
B. Archive logs on the primary database may be deleted once they are shipped on all standby
databases.
C. The deletion policy for archive logs on the remote physical standby should be set so that archived
logs are deleted once they backed up at least once on the remote physical standby database.
D. The deletion policy for archive logs on the remote physical standby should be set so that archived
logs are deleted once they are applied on all standby databases.
E. Archive logs on the primary database may be deleted once they are archived locally to disk.
Option A,D,E are correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com


Q5.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.
Option A,C are correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com


Q6.You are required to change the Data Guard Configuration protection mode from MAXPERFORMANCE to
MAXAVAJLABILITY using Enterprise Manager Cloud Control Which two are true about this change?
A. If the primary database cannot write its redo to at least one synchronized standby database, then
the protection level remains unchanged.
B. The primary database instance will remain up and running, if it cannot write redo to at least one
synchronized standby database.
C. Transactions will not commit until all redo data needed to recover those transactions are written
to the online redo log, and to the standby redo log on at least one synchronizes standby database.
D. Fast start failover can be enabled when making the chance. E. Real time apply will be automatically
turned on.
Option B,C are correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com


Q7.Which four database parameters might be affected by or influence the creation of standby databases?
https://www.certification-questions.com/
A. DB_NAME B. ARCHIVE_LAG_TARGET
C. COMPATIBLE
D. DB_FILE_NAME_CONVERT
E. DB_UNIQUE_NAME F. FAL_SERVER G. STANDBY_ARCH1VE_DEST
Option A,D,E,F are correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com


Q8.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?
A)
+-------------------+----+
| Sequence a output | 21 |
+-------------------+----+
+-------------------+----+
| Sequence b output | 1 |
+-------------------+----+
B)
+-------------------+----+
| Sequence a output | 21 |
+-------------------+----+
+-------------------+----+
| Sequence b output | 21 |
+-------------------+----+
C)
+-------------------+----+
| Sequence a output | 1 |
+-------------------+----+
+-------------------+----+
| Sequence b output | 1 |
+-------------------+----+
D)
+-------------------+----+
| Sequence a output | 1 |
+-------------------+----+
+-------------------+----+
| Sequence b output | 1 |
+-------------------+----+
A. Option A
B. Option B
C. Option C
D. Option D
Option C is correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com



Q9.You must propose an Oracle Data Guard configuration tor a database supporting an OLTP workload that
meets these permanent requirements:
https://www.certification-questions.com/
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:
3. It should be possible to apply and test designated patches with a minimum amount of downtime.
4. Upgrading to a new database release should be performed with the least possible amount of
downtime.
5. New application software releases should be tested against an exact up-to-date replica of the
production database. You propose a primary database with one physical standby database configured in
Maximum Protection mode.
Which requirements do you meet?
A. 2,3, 4, and 5
B. 1,2, 3,4, and 5
C. 1 and 2
D. only requirement 5
E. only requirement 1
Option C is correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com


Q10.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
Option D is correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com