Oracle 1Z0-066 Online Practice Questions and Exam Preparation

Oracle 1Z0-066 Online Questions & Answers

• Question 71:

  Which three are true regarding prerequisites for a logical standby database as a disaster recovery solution? (Choose three.)

  A. Ensure that no ROWID data types are contained in the primary database.
  B. Ensure that flashback is enabled on the primary database.
  C. Ensure that supplemental logging is enabled on the primary database.
  D. Do not perform any nologging operations on the primary.
  E. Ensure that no BFILE LOB data types are contained in the primary database.
  B. Ensure that flashback is enabled on the primary database.
  E. Ensure that no BFILE LOB data types are contained in the primary database.

• Question 72:

  Which two are prerequisites for configuring Transaction Guard in a Data Guard environment?

  A. Grant execute permission on the DBMS_APP_CONT package to relevant database schema owners
  B. Create a database service with COMMIT_OUTCOME set to TRUE, and ensure clients use that service to connect to the database instance.
  C. Ensure that connection descriptors for database clients use the failover clause with the COMMIT_OUTCOME parameter set to TRUE
  D. Set INSTANCE_NAME identically on all the Data Guard Configuration databases and modify the local service name on the client to include a CONNECTION_LIST containing all the standby hosts.
  E. Create a database service with COMMIT_OUTCOME set to TRUE and ensure that the service is statically registered with the default listener on the primary host
  A. Grant execute permission on the DBMS_APP_CONT package to relevant database schema owners
  B. Create a database service with COMMIT_OUTCOME set to TRUE, and ensure clients use that service to connect to the database instance.

• Question 73:

  Which two are prerequisites for creating a standby database using Enterprise Manager cloud control?

  A. The primary database must have FORCE LOGGING enabled.
  B. The primary database must be in archive log mode
  C. A backup of the primary database must exist.
  D. The primary host and the proposed standby database host must run the same operating system.
  E. The primary database instance must be started using an SPFILE.
  F. The primary database must have flashback enabled
  A. The primary database must have FORCE LOGGING enabled.
  B. The primary database must be in archive log mode

• Question 74:

  Which three statements are true about snapshot standby databases?

  A. Tablespaces can be dropped.
  B. Tables can be dropped
  C. The broker may be used to fail over to a snapshot standby database.
  D. A logical standby database can be converted into a snapshot standby database.
  E. Tablespaces can be created.
  A. Tablespaces can be dropped.
  B. Tables can be dropped
  E. Tablespaces can be created.

• Question 75:

  Which two are true about Data Guard Broker configuration parameter administration? (Choose two.)

  A. Changes to database properties always result in immediate updates to initialization parameters in the SPFILE even when the configuration is disabled.
  B. Changes to database properties that might result in changes to static initialization parameters may not be done using the Data Guard Broker.
  C. Changes to database properties that might result in changes to dynamic initialization parameters may be done using the Data Guard Broker when the configuration is disabled.
  D. An SPFILE must be used for all the databases in a configuration.
  E. Changes to database initialization parameters cannot be done directly for properties that are controlled by the Data Guard Broker.
  D. An SPFILE must be used for all the databases in a configuration.
  E. Changes to database initialization parameters cannot be done directly for properties that are controlled by the Data Guard Broker.

• Question 76:

  You must propose an Oracle Data Guard configuration for a database supporting a DSS workload that meets these permanent requirements:

  1.

  The performance impact on the primary database should be kept to a minimum.

  2.

  Creating and maintaining materialized views should not impact the performance of the primary database. Additionally, there are these requirements, only the one of which is ever done at any one time:

  3.

  It should be possible to apply 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 configuration operating in Maximum Performance mode with a primary database and one logical standby database. Which requirements do you meet?

  A. 1, 2, and 3
  B. 2 and 5
  C. 1 and 5
  D. 1, 2, 3, 4, and 5
  E. 1, 2, and 4
  F. 2, 3, and 5
  E. 1, 2, and 4

• Question 77:

  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.
  A. Archive logs on the primary database may be deleted once they are applied on all standby databases.
  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.

• Question 78:

  Examine the Data Guard configuration:

  

  Identify two possible reasons for this error.

  A. The FastStartFailoverTarget property is not set on Sheep.
  B. The FastStartFailoverTarget property is not set on Dogs.
  C. The FastStartFailoverTarget property is not set on DogsFSI.
  D. The LogXptMode property is set to ASYNC on Dogs.
  E. The RedoRoutes property is not set on Dogs
  F. The RedoRoutes property is not set on DogsFSI
  A. The FastStartFailoverTarget property is not set on Sheep.
  D. The LogXptMode property is set to ASYNC on Dogs.

• Question 79:

  Which four database parameters might be affected by or influence the creation of standby databases?

  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
  A. DB_NAME
  D. DB_FILE_NAME_CONVERT
  E. DB_UNIQUE_NAME
  F. FAL_SERVER

• Question 80:

  Which two are true about management of a far sync instance when using the Data Guard Broker?

  A. A far sync instance is in a disabled state in the broker configuration immediately after adding it
  B. A far sync instance that has its RedoRoutes property set may not be disabled in the broker configuration.
  C. Broker management of a far sync instance may only be disabled with the disable configuration DGMGRL command.
  D. A far sync instance need not exist before adding it to the broker configuration but may not be enabled until created
  A. A far sync instance is in a disabled state in the broker configuration immediately after adding it
  B. A far sync instance that has its RedoRoutes property set may not be disabled in the broker configuration.