최신 1z0-076 무료덤프 - Oracle Database 19c: Data Guard Administration

A. The switchover TO command allows a switchover operation to a snapshot standby database.

B. Tablespaces can be created.

C. A logical standby database can be converted into a snapshot standby database.

D. Tables can be dropped.

E. The FATLOVER TO command results in a transition of a snapshot standby database to the primary role.

F. Tablespaces can be dropped.

A. Online logs

B. Control files

C. Broker configuration files

D. Password files

E. Archive logs

F. Data files

A. Logical standby databases can be the target database for the dbms_dbcomp.dbcomp procedure.

B. It requires that the DB_LOST_WKITE_protect initialization parameter be enabled.

C. The databases should be at least mounted before block comparison.

D. It can be used to detect lost writes and inconsistencies between the primary database and the cascaded standbys.

E. You can monitor the progress of an ongoing block comparison operation by querying VS SES SION_LONGOPS.

A. A snapshot standby database may be opened read-write.

B. FLASHBACK DATABASE is enabled automatically on a snapshot standby database after converting it from a physical standby database if not already enabled.

C. FLASHBACK DATABASE is enabled automatically on a physical standby database as part of the conversion into a snapshot standby database, if not already enabled.

D. A snapshot standby database may be opened read-only.

E. A snapshot standby database can have Real-Time apply enabled.

F. FLASHBACK DATABASE must be manually enabled on a physical standby database before converting it into a snapshot standby database.

A. It can be used to create additional tables.

B. It can be used to create additional schemas.

C. It can be used for Real Application Testing without affecting the disaster recovery capabilities.

D. It must have the same physical structure as the primary database.

E. Support for workloads requiring additional indexes.

F. It must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.

G. Support for workloads requiring additional materialized views.

A. Increase the size of the buffer cache on the physical standby database instances.

B. Decrease the redo log file size on the primary database.

C. Increase the number of standby redo log files on the standby databases.

D. Increase the size of standby redo log files on the standby databases.

E. Lower DB_BLOCK_CHECKING to MEDIUM or low on the standby databases.

A. They can only be used to skip DML statements on a table.

B. They can be used to skip execution of DML triggers on a table while allowing the DML to execute.

C. They can be used to skip all SQL statements executed on a specific pluggable database (PDB) within a standby multitenant container database (CDB).

D. They can be used to skip ALTER TABLE commands on specific tables.

E. They can be used to skip ALTE1 STEM and ALTER DATABASE commands.

F. They can be used to stop SQL apply if it encounters an error.

G. They can be used to skip CREATE TABLE commands.