Oracle Data Guard Broker Administration Quiz

1. Which DGMGRL command displays the current Data Guard configuration status?

SHOW CONFIGURATION

DISPLAY STATUS

VIEW CONFIGURATION

LIST CONFIGURATION

2. The broker automatically manages the fast-start failover (FSFO) feature when configured. True or False?

True

False

3. Which DGMGRL command starts the broker on a database instance?

START BROKER

ENABLE BROKER

STARTUP BROKER

INITIALIZE BROKER

4. Data Guard Broker can manage multiple standby databases in a single configuration. True or False?

True

False

5. Which protection mode ensures zero data loss during a failover?

Maximum Protection

Maximum Availability

Maximum Performance

Standard Protection

6. What is the purpose of the 'EDIT CONFIGURATION' command in DGMGRL?

Modify broker configuration properties

Edit database parameter files

Change database passwords

Modify listener configuration

7. The broker configuration file is binary and cannot be directly edited by users. True or False?

True

False

8. Which parameter specifies the location of Data Guard broker configuration files?

Dg_broker_config_file1 and dg_broker_config_file2

Broker_config_location

Dg_config_path

Standby_config_file

9. Data Guard Broker requires a static listener configuration on all databases. True or False?

True

False

10. What is the role of the broker monitor process (DMON) in Data Guard?

Manages configuration and monitors database health

Applies redo logs to standby

Performs incremental backups

Encrypts network traffic

11. What is the primary purpose of Oracle Data Guard Broker?

Automate and simplify Data Guard configuration and management

Replace the listener in Oracle Net Services

Manage only standby database backups

Monitor only alert log messages

12. The broker can automatically initiate a failover if the primary database becomes unavailable. True or False?

True

False

13. What is a 'failover' in Data Guard Broker context?

A planned role reversal

An unplanned transition when primary is unavailable

A backup operation

A database restart

14. In Data Guard Broker, what is a 'switchover'?

A planned role change between primary and standby

An unplanned failover to standby

Stopping the broker service

Restarting the primary database

15. Which DGMGRL command creates a new Data Guard configuration?

CREATE CONFIGURATION

CREATE BROKER CONFIG

SETUP CONFIGURATION

INITIALIZE CONFIGURATION

16. The Data Guard broker automatically manages redo log archiving on the primary database. True or False?

True

False

17. Which type of standby database can be opened for read-only access while Data Guard is active?

Physical standby only

Logical standby only

Active Data Guard standby

All standby types

18. What does a Data Guard Broker configuration require to operate?

A primary database and at least one standby database

Three standby databases minimum

Only the primary database

A separate metadata repository

19. The DGMGRL command-line tool is used to manage Data Guard Broker configurations. True or False?

True

False

20. Which parameter must be set to enable Data Guard Broker on a database?

Dg_broker_enabled = true

Dg_broker_start = 1

Dg_broker_config_file1 and dg_broker_config_file2

Standby_role_parameter = 1

Oracle DBA Professional Data Guard Broker Administration Quiz

1. Which DGMGRL command displays the current Data Guard configuration status?

2.

What first name or nickname would you like us to use?

2. The broker automatically manages the fast-start failover (FSFO) feature when configured. True or False?

3. Which DGMGRL command starts the broker on a database instance?

4. Data Guard Broker can manage multiple standby databases in a single configuration. True or False?

5. Which protection mode ensures zero data loss during a failover?

6. What is the purpose of the 'EDIT CONFIGURATION' command in DGMGRL?

7. The broker configuration file is binary and cannot be directly edited by users. True or False?

8. Which parameter specifies the location of Data Guard broker configuration files?

9. Data Guard Broker requires a static listener configuration on all databases. True or False?

10. What is the role of the broker monitor process (DMON) in Data Guard?

11. What is the primary purpose of Oracle Data Guard Broker?

12. The broker can automatically initiate a failover if the primary database becomes unavailable. True or False?

13. What is a 'failover' in Data Guard Broker context?

14. In Data Guard Broker, what is a 'switchover'?

15. Which DGMGRL command creates a new Data Guard configuration?

16. The Data Guard broker automatically manages redo log archiving on the primary database. True or False?

17. Which type of standby database can be opened for read-only access while Data Guard is active?

18. What does a Data Guard Broker configuration require to operate?

19. The DGMGRL command-line tool is used to manage Data Guard Broker configurations. True or False?

20. Which parameter must be set to enable Data Guard Broker on a database?