1z0-497 無料問題集「Oracle Database 12c Essentials」

（A）GDS helps in performing data replication.

（B）GDS allows scaling replication-aware application workloads beyond the cluster (that is, across replicated clusters).

（C）GDS works seamlessly with any combination of Oracle RAC databases, single-instance databases, Oracle Data Guard, Oracle Active Data Guard, and Oracle Golden Gate.

（D）GDS helps to perform database failovers, and does not require Data Guard Broker.

（E）The GDSMGRL utility is a command-line interface for configuring and managing the Global Data Services framework.

（A）SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.

（B）SCOTT has to re-execute the last command in the transaction after he commits the transaction.

（C）The session is terminated after receiving the error and JIM can continue with his transaction.

（D）The session is rolled back after receiving the error and JIM can continue with his transaction.

（A）For fast-start failover, you must preselect the target standby database that will be used.

（B）Neither a switchover nor a failover is possible to a far sync instance.

（C）You can activate a standby database to test whether it is being updated correctly.

（D）A snapshot standby can be the target of a switchover or fast-start failover operation.

（A）It configures Oracle Net Services.

（B）It configures Oracle Messaging Gateway.

（C）It enables the Oracle Data Mining option in your Oracle binary files.

（D）It generates Client Static Library.

（E）It configures one of the Oracle user accounts.

（F）It creates the Fast Recovery Area disk group.

（A）shared UNDO and default database temporary tablespace

（B）local users and local roles

（C）local temporary tablespaces

（D）Oracle-supplied metadata

（E）CDB views providing information across PDBs

（F）application tablespaces

（G）shared Oracle-supplied data

（H）non-shared local metadata

（A）The database must advance the checkpoint.

（B）The buffer must be written to flash cache.

（C）The modified data block must be moved from the LRU list to the write queue.

（D）A log writer (LGWR) must write all redo entries that have been copied into the buffer since the last time it wrote.

（A）They are required to support Flashback features.

（B）They are not required if Flashback features are enabled.

（C）They are retained until the session making the changes ends.

（D）Undo records contain copies of data as it appears before a change is made.

（E）Undo records contain copies of data as it appears after a change is made.

（A）Buffer access is kept efficient by maintaining a least recently used (LRU) list for dirty and clean buffers.

（B）A buffer cache contains exactly three pools: default, keep, and recycle pool.

（C）A buffer cache always resides completely in System Global Area (SGA).

（D）A buffer cache stores copies of data blocks from all files of the database.

（E）When a buffer is read from a buffer cache, it may be inconsistent and require undo data to make it consistent.

（A）serializable

（B）read uncommitted

（C）read-only

（D）read committed

（A）Shared Pool

（B）Private SQL Area

（C）Undo Log Buffer

（D）Small Pool

（E）Database Buffer Cache

（F）Java Pool