Oracle 1Z0-066 Online Practice Questions and Exam Preparation

Oracle 1Z0-066 Online Questions & Answers

• Question 181:

  Your Data Guard environment has two remote physical standby databases.

  Client applications use the local naming method to define connectivity to the primary database instance.

  Which will automatically redirect clients to the new primary database in case of a switchover or failover?

  A. Create a database service on the standby databases; automate the start of the service after a role change, and modify the connection description on the clients to use that service.
  B. Configure a PRIMARY role service on the Primary and Standby and modify the Client connect descriptor to include both Primary and the Standby.
  C. Set the DB_NAME parameter identically on all databases; modify the connection descriptor on the clients to use DB_NAME to connect to the primary database instance.
  D. Set the LOCALJJSTENER parameter for all the database instances, to register services with the default listener on the primary database host.
  C. Set the DB_NAME parameter identically on all databases; modify the connection descriptor on the clients to use DB_NAME to connect to the primary database instance.

• Question 182:

  Examine the Data Guard configuration after an accidental switchover to Sheep:

  

  Which three will be true after a switchover to Dogs?

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

• Question 183:

  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. Option A
  B. Option B
  C. Option C
  D. Option D
  C. Option C

• Question 184:

  Which three statements are true about Far Sync instances?

  A. The Data Guard Broker must be used to deploy and manage Far Sync instances.
  B. They enable standby database to be configured at remote distances from the primary without impacting performance on the primary.
  C. A primary database can ship redo directly to multiple Far Sync instances.
  D. They use as spfile, a standby controlfile, and standby redo logs.
  E. They work with any protection level.
  A. The Data Guard Broker must be used to deploy and manage Far Sync instances.
  B. They enable standby database to be configured at remote distances from the primary without impacting performance on the primary.
  D. They use as spfile, a standby controlfile, and standby redo logs.

• Question 185:

  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
  D. a primary database with one logical and one physical standby database

• Question 186:

  Examine the Data Guard configuration:

  

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

  A. Sheep will be in the disabled state.
  B. Sheep will be in the enabled state.
  C. Dogs will be in the disabled state and has to be manually reinstated
  D. The configuration will be in Maximum Performance mode.
  E. The configuration will be in Maximum Availability mode.
  B. Sheep will be in the enabled state.
  C. Dogs will be in the disabled state and has to be manually reinstated
  D. The configuration will be in Maximum Performance mode.

• Question 187:

  Which three are true about the use of the VALID_FOR clause of the LOG_ARCHIVE_DEST_N parameter, in determining whether archive logs should be written to a particular destination by a database in a Data Guard environment? (Choose three.)

  A. whether the database at the destination is reached by using a far sync instance
  B. whether the database at the destination is a primary or a standby
  C. whether online redo logs are to be archived at a specific destination
  D. whether standby redo logs are to be archived at a specific destination
  E. whether the database at the source is a primary or a standby
  A. whether the database at the destination is reached by using a far sync instance
  D. whether standby redo logs are to be archived at a specific destination
  E. whether the database at the source is a primary or a standby

• Question 188:

  Which three are true concerning database states after a successful switchover?

  A. If the former primary database became a logical standby database it will be in mount state
  B. The new primary database will be open read-write.
  C. The former primary database will always be open.
  D. If the former primary database became a logical standby database it will be open read- write.
  E. if the former primary database became a physical standby database it will always be open read-only.
  F. If the former primary database became a physical standby database it will be in the same state as the former physical standby database
  A. If the former primary database became a logical standby database it will be in mount state
  B. The new primary database will be open read-write.
  E. if the former primary database became a physical standby database it will always be open read-only.

• Question 189:

  Which two Data Guard features require the use of flashback database by the broker?

  A. Read-Mostly physical standby implementations
  B. Far Sync Instances
  C. Fast-Start Failover
  D. Real Time Query
  E. Snapshot Standby databases
  C. Fast-Start Failover
  E. Snapshot Standby databases

• Question 190:

  Which two statements are true about Far Sync instances? (Choose two.)

  A. They work in Maximum Availability mode.
  B. They work in Maximum Performance mode.
  C. They work in Maximum Protection mode.
  D. They do not work with Logical Standby databases.
  E. They do not work with Snapshot Standby databases.
  A. They work in Maximum Availability mode.
  C. They work in Maximum Protection mode.