Oracle 1Z0-066 Online Practice Questions and Exam Preparation

Oracle 1Z0-066 Online Questions & Answers

• Question 151:

  Examine the Data Guard configuration:

  Properties:

  FastStartFailoverThreshold = `30'

  OperationTimeout = `30'

  TraceLevel = `USER'

  FastStartFailoverLagLimit = `30'

  CommunicationTimeout = `180'

  ObserverReconnect = `10'

  FastStartFailoverAutReinstate = `TRUE'

  FastStartFailoverPmyShutdown = `TRUE'

  BystandersFollowRoleChange = `all'

  ObserverOverride = `FALSE'

  Fast-Start Failover: ENABLED

  Threshold: 30 seconds

  Target: dogs

  Observer: prutser6.example.com

  Lag Limit: 30 seconds (not in use)

  Shutdown Primary: TRUE

  Auto-reinstate: TRUE

  Observer Reconnect: 10 seconds

  Observer Override:

  Configuration Status:

  SUCCESS

  What happens if you issue "failover to dogs;" at the DGMGRL prompt while connected to Dogs?

  A. The failover succeeds, Sheep becomes the new target standby database, and Cats is automatically reinstated.
  B. The failover succeeds and Cats is automatically reinstated.
  C. The failover succeeds and Cats is left running.
  D. The failover succeeds and Cats is terminated.
  E. It results in an error indicating that a failover is not allowed.
  D. The failover succeeds and Cats is terminated.

• Question 152:

  Examine the Data Guard configuration:

  

  Which three will be true after a switchover to Dogs?

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

• Question 153:

  Examine the Data Guard configuration: DGMGRL> show configuration Configuration-Animals Protection Mode: MaxAvailability Databases: Sheep- Primary database Warning: ORA-16817: unsynchronized fast-start failover configuration Dogs - (*) Physical standby database (disabled) ORA-16661: the standby database needs to be reinstated Fast-Start Failover: ENABLED Configuration Status: WARNING And the fast-start failover configuration: DGMGRL> show fast_start failover; Fast-Start Failover: ENABLED Threshold: 30 seconds Target: dogs

  Observer: 017.example.com Lag Limit: 30 seconds (not in use) Shutdown Primary: TRUE Auto-reinstate: TRUE Observer Reconnect 10 seconds Observer Override: FALSE Configurable Failover Conditions Hearth Conditions: Corrupted Controlfile YES Inaccessible Logfile NO Stuck Archiver NO Datafile Offline YES Oracle error Conditions ORA-01578: ORACLE data block corrupted (file # %s, block # %s) And finally the reason for the fail over: SQL> select last_failover_reason from v$fs_failover_stats; LAST_FAILOVER_REASON ORA-01578: ORACLE data block corrupted (file # %s, block # %s) Identify the task, or sequence of tasks, to bring the configuration into the SUCCESS state.

  A. Bring Dogs to the NOMOUNT state and let the broker reinstate Dogs automatically.
  B. MOUNT DOGS and issue ''reinstate database dogs:" at the DGMGRL prompt while connected to Dogs.
  C. MOUNT DOGS and issue "reinstate database dogs:" at the DGMGRL prompt while connected to Sheep
  D. Open Dogs and let the broker reinstate Dogs automatically.
  C. MOUNT DOGS and issue "reinstate database dogs:" at the DGMGRL prompt while connected to Sheep

• Question 154:

  Which four factors can influence the rate of SQL apply on a logical standby database?

  A. the size of the undo tablespace on the logical standby database
  B. the number of full table scans performed by SQL apply
  C. the number of coordinator processes on the standby database instance
  D. the size of the shared pool
  E. the number of APPLIER processes
  F. the number of PREPARER processes
  B. the number of full table scans performed by SQL apply
  D. the size of the shared pool
  E. the number of APPLIER processes
  F. the number of PREPARER processes

• Question 155:

  Which three steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?

  A. Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME parameter.
  B. Put the primary database into archivelog mode
  C. Startup nomount the standby database instance.
  D. Configure Oracle Net connectivity on the primary host to the standby database instance.
  E. Establish user equivalence for the database software owner between the primary host and standby host.
  C. Startup nomount the standby database instance.
  D. Configure Oracle Net connectivity on the primary host to the standby database instance.
  E. Establish user equivalence for the database software owner between the primary host and standby host.

• Question 156:

  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 157:

  Which two statements are true regarding Data Guard Broker?

  A. It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby
  B. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
  C. it can be used to perform failovers and switchovers.
  D. It can be used to create and manage standby databases.
  E. It can be used to monitor redo transport and log apply services.
  B. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
  C. it can be used to perform failovers and switchovers.

• Question 158:

  The Oracle database 12c Observer is currently running on host1 and you wish to have it running on host2.

  Examine this list of possible steps:

  1) Stop the observer on host1.

  2) Disable Fast-Start Failover.

  3) Update the broker configuration with the new observer hostname.

  4) Enable Fast-Start Failover.

  5) Start the Observer on host2.

  Which contains the minimum required steps to move the observer to host2?

  A. Execute only task 5.
  B. Execute tasks 1, 3, and 5.
  C. Execute tasks 1, 2, 3, 4, and 5.
  D. Execute tasks 1 and 5.
  D. Execute tasks 1 and 5.

• Question 159:

  Which three types of backups taken in which situations may be used to perform restore operations to a logical standby database in a Data Guard environment?

  A. backups of data files taken on the primary database if connected to the recovery catalog where the logical standby database is registered
  B. backups of data files taken on the standby database if connected to the recovery catalog where the logical standby database is registered
  C. backups of control files taken on the primary database if connected to the recovery catalog where the logical standby database is registered
  D. backups of data files taken on the logical standby database, if not connected to a recovery catalog
  E. backups of control files taken on the logical standby database if not connected to a recovery catalog
  A. backups of data files taken on the primary database if connected to the recovery catalog where the logical standby database is registered
  D. backups of data files taken on the logical standby database, if not connected to a recovery catalog
  E. backups of control files taken on the logical standby database if not connected to a recovery catalog

• Question 160:

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

  A. in a broker configuration, the primary database name must match the DB_UNIQUE_NAME value in the database initialization parameter file.
  B. A primary database profile may be added to the configuration prior to creating the primary database.
  C. A standby database profile may be added to the configuration prior to creating that standby database.
  D. A newly created broker configuration requires at least one standby database profile to be specified at the time the configuration is created.
  E. A newly created broker configuration is in the disabled state
  D. A newly created broker configuration requires at least one standby database profile to be specified at the time the configuration is created.
  E. A newly created broker configuration is in the disabled state