File Info
| Exam | Oracle Database 12c: Data Guard Administration |
| Number | 1z0-066 |
| File Name | Oracle.1z0-066.PrepAway.2018-12-03.53q.tqb |
| Size | 557 KB |
| Posted | Dec 03, 2018 |
| Download | Oracle.1z0-066.PrepAway.2018-12-03.53q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Which four database parameters might be affected by or influence the creation of standby databases?
- DB_NAME
- ARCHIVE_LAG_TARGET
- COMPATIBLE
- DB_FILE_NAME_CONVERT
- DB_UNIQUE_NAME
- FAL_SERVER
- STANDBY_ARCHIVE_DEST
Correct answer: ADEF
Explanation:
A: DB_NAMEOn a primary database, specify the name used when the database was created. On a physical standby database, use the DB_NAME of the primary database. C: Ensure the COMPATIBLE initialization parameter is set to the same value on both the primary and standby databases. If the values differ, redo transportservices may be unable to transmit redo data from the primary database to the standby databases. D: DB_FILE_NAME_CONVERTSpecify the path name and filename location of the primary database data files followed by the standby location. This parameter converts the path names of the primary database data files to the standby data file path names. E: DB_UNIQUE_NAMESpecify a unique name for each database. This name stays with the database and does not change, even if the primary and standby databases reverse roles. F: FAL_SERVERSpecify the Oracle Net service name of the FAL server (typically this is the database running in the primary role). References: https://docs.oracle.com/database/121/SBYDB/create_ps.htm#SBYDB4720 A: DB_NAME
On a primary database, specify the name used when the database was created. On a physical standby database, use the DB_NAME of the primary database.
C: Ensure the COMPATIBLE initialization parameter is set to the same value on both the primary and standby databases. If the values differ, redo transport
services may be unable to transmit redo data from the primary database to the standby databases.
D: DB_FILE_NAME_CONVERT
Specify the path name and filename location of the primary database data files followed by the standby location. This parameter converts the path names of the
primary database data files to the standby data file path names.
E: DB_UNIQUE_NAME
Specify a unique name for each database. This name stays with the database and does not change, even if the primary and standby databases reverse roles.
F: FAL_SERVER
Specify the Oracle Net service name of the FAL server (typically this is the database running in the primary role).
References: https://docs.oracle.com/database/121/SBYDB/create_ps.htm#SBYDB4720
Question 2
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
Correct answer: C
Question 3
You must propose an Oracle Data Guard configuration for a database supporting an OLTP workload 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:
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?
- 2, 3, 4, and 5
- 1, 2, 3, 4, and 5
- 1 and 2
- only requirement 5
- only requirement 1
Correct answer: C
Explanation:
Maximum Protection mode ensures that zero data loss occurs if a primary database fails. Because this data protection mode prioritizes data protection over primary database availability, Oracle recommends that a minimum of two standby databases be used to protect a primary database that runs in maximum protection mode to prevent a single standby database failure from causing the primary database to shut down. Incorrect Answers:A, D: Maximum Protection mode ensures that zero data loss occurs if a primary database fails.References: https://docs.oracle.com/cd/B28359_01/server.111/b28294/protection.htm Maximum Protection mode ensures that zero data loss occurs if a primary database fails.
Because this data protection mode prioritizes data protection over primary database availability, Oracle recommends that a minimum of two standby databases be used to protect a primary database that runs in maximum protection mode to prevent a single standby database failure from causing the primary database to shut down.
Incorrect Answers:
A, D: Maximum Protection mode ensures that zero data loss occurs if a primary database fails.
References: https://docs.oracle.com/cd/B28359_01/server.111/b28294/protection.htm
