Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-066

Oracle 1z0-066 Exam Practice Questions (P. 2)

  • Full Access (112 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #6
You are required to change the Data Guard Configuration protection mode from MAXPERFORMANCE to MAXAVAILABILITY using Enterprise Manager Cloud
Control.
Which two are true about this change?
  1. A
    If the primary database cannot write its redo to at least one synchronized standby database, then the protection level remains unchanged.
  2. B
    The primary database instance will remain up and running, if it cannot write redo to at least one synchronized standby database.
  3. 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.
  4. D
    Fast start failover can be enabled when making the chance.
  5. E
    Real time apply will be automatically turned on.

Correct Answer:
BC
Maximum Availability -
This protection mode provides the highest level of data protection that is possible without compromising the availability of a primary database. Transactions do not commit until all redo data needed to recover those transactions has been written to the online redo log and to at least one synchronized standby database.
If the primary database cannot write its redo stream to at least one synchronized standby database, it operates as if it were in maximum performance mode to preserve primary database availability until it is again able to write its redo stream to a synchronized standby database.
References:
https://docs.oracle.com/cd/B28359_01/server.111/b28294/protection.htm

Question #7
Which four database parameters might be affected by or influence the creation of standby databases?
  1. A
    DB_NAME
  2. B
    ARCHIVE_LAG_TARGET
  3. C
    COMPATIBLE
  4. D
    DB_FILE_NAME_CONVERT
  5. E
    DB_UNIQUE_NAME
  6. F
    FAL_SERVER
  7. G
    STANDBY_ARCHIVE_DEST

Correct Answer:
ADEF
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 #8
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?

  1. A
    Option A
  2. B
    Option B
  3. C
    Option C
  4. D
    Option D

Correct Answer:
C

Question #9
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?
  1. A
    2, 3, 4, and 5
  2. B
    1, 2, 3, 4, and 5
  3. C
    1 and 2
  4. D
    only requirement 5
  5. E
    only requirement 1

Correct Answer:
C
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

Question #10
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. Three Physical Standby Databases
You must meet these requirements:
1. A designated physical standby database should become the primary database automatically whenever the primary database falls.
2. 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?
  1. A
    SYNC NOAFFRIM and Maximum Protection
  2. B
    SYNC NOAFFIRM and Maximum Availability
  3. C
    ASYNC and Maximum Performance
  4. D
    SYNC AFFIRM and Maximum Availability
  5. E
    SYNC AFFIRM and Maximum Protection

Correct Answer:
D
The Maximum Availability protection mode provides the highest level of data protection that is possible without compromising the availability of a primary database.
When a transport is performed using SYNC/AFFIRM, the primary performs write operations and waits for acknowledgment that the redo has been transmitted synchronously to the physical standby and written to disk. A SYNC/AFFIRM transport provides an additional protection benefit at the expense of a performance impact caused by the time required to complete the I/O to the standby redo log.
Incorrect Answers:
B: When a transport is performed using SYNC/NOAFFIRM, the primary performs write operations and waits only for acknowledgement that the data has been received on the standby, not that it has been written to disk. The SYNC/NOAFFIRM transport can provide a performance benefit at the expense of potential exposure to data loss in a special case of multiple simultaneous failures.
References:
https://docs.oracle.com/cd/B28359_01/server.111/b28294/protection.htm

Previous Questions Next Questions

All Pages