MCQs on Data Backup, Recovery, and Export/Import | Data Protection
Topic 1: Understanding Oracle Backup Strategies
- What is the primary purpose of an Oracle database backup?
- A) To optimize performance
- B) To recover lost or damaged data
- C) To generate reports
- D) To enhance security
- Which of the following is a type of backup strategy in Oracle?
- A) Full backup
- B) Incremental backup
- C) Cumulative backup
- D) All of the above
- What is the difference between a full backup and an incremental backup?
- A) A full backup copies all database files, while an incremental backup copies only the changes made since the last backup
- B) A full backup copies only modified data, while an incremental backup copies all data
- C) A full backup does not include database logs
- D) There is no difference
- Which backup strategy involves backing up only the changes since the last backup, regardless of the type of previous backup?
- A) Cumulative backup
- B) Incremental backup
- C) Differential backup
- D) Full backup
- Oracle database backups can be stored in:
- A) Tape storage
- B) Disk storage
- C) Cloud storage
- D) All of the above
- What is the key benefit of using a backup and recovery strategy in Oracle?
- A) Increased query performance
- B) Protection against data loss due to failures
- C) Optimizing disk space usage
- D) Reducing maintenance costs
- Which of the following backup types can be performed while the database is online?
- A) Full backup
- B) Incremental backup
- C) Hot backup
- D) Cold backup
- Which type of backup does not lock the database and can be performed while the database is in use?
- A) Cold backup
- B) Incremental backup
- C) Hot backup
- D) Archive backup
- What does an Oracle “archive log” backup include?
- A) Backup of data files
- B) Backup of redo logs
- C) Backup of system parameters
- D) Backup of control files
- Which strategy is recommended for ensuring that backups are available for point-in-time recovery?
- A) Differential backup
- B) Incremental backup
- C) RMAN backup
- D) Cold backup
Topic 2: Using RMAN (Recovery Manager)
- What is the primary function of RMAN (Recovery Manager)?
- A) To generate data reports
- B) To perform database backups and recovery
- C) To configure user accounts
- D) To manage network traffic
- RMAN backups can be:
- A) Full or incremental
- B) Online or offline
- C) Both A and B
- D) Only full backups
- Which of the following is used by RMAN to back up the Oracle database?
- A) Control files
- B) Data files
- C) Redo logs
- D) All of the above
- Which command in RMAN is used to perform a backup?
- A) BACKUP DATABASE
- B) BACKUP ARCHIVE LOG
- C) BACKUP RECOVERY
- D) Both A and B
- RMAN is used to back up:
- A) Entire database
- B) Specific tablespaces
- C) Control files and redo logs
- D) All of the above
- Which command restores a database from a backup using RMAN?
- A) RESTORE DATABASE
- B) RESTORE RECOVERY
- C) RESTORE ARCHIVE LOG
- D) None of the above
- Which of the following is an advantage of using RMAN for database backup?
- A) RMAN can automatically perform a backup and delete old backups
- B) RMAN backups are slower than manual backups
- C) RMAN is not compatible with Oracle RAC
- D) RMAN requires the database to be offline for backups
- RMAN can be used for:
- A) Backing up only data files
- B) Backing up entire databases
- C) Managing archive logs
- D) Both B and C
- Which option is used to configure RMAN to back up to a specific location?
- A) CONFIGURE BACKUP LOCATION
- B) CONFIGURE BACKUP DEVICE
- C) CONFIGURE CHANNEL
- D) CONFIGURE DATABASE
- What is the primary purpose of the RMAN “crosscheck” command?
- A) To validate backup integrity
- B) To delete expired backups
- C) To verify database consistency
- D) To check disk space
Topic 3: Data Pump (EXPDP and IMPDP)
- What is Oracle Data Pump (EXPDP and IMPDP) used for?
- A) Data backup and recovery
- B) Data migration and export/import
- C) Query optimization
- D) System performance tuning
- Which utility is used to export data from an Oracle database using Data Pump?
- A) EXP
- B) IMP
- C) EXPDP
- D) IMPDP
- Which of the following is a benefit of using Data Pump over traditional export/import methods?
- A) Faster data transfer
- B) More granular control over export/import
- C) Ability to export/import metadata separately
- D) All of the above
- Which Data Pump command is used to import data into an Oracle database?
- A) IMP
- B) EXP
- C) EXPDP
- D) IMPDP
- What does the Data Pump “ACCESS_METHOD” parameter define?
- A) The method of accessing data for export or import
- B) The type of backup to use
- C) The security level for data export/import
- D) The type of log file generated during export/import
- Which of the following is a valid option for exporting data using Data Pump?
- A) Exporting a single table
- B) Exporting an entire database
- C) Exporting a schema
- D) All of the above
- Which feature of Data Pump allows the export/import process to be resumed after an interruption?
- A) Job restart
- B) Parallel processing
- C) Data Partitioning
- D) Flashback
- What is the default method of export used by Data Pump?
- A) Direct path export
- B) Conventional export
- C) Parallel export
- D) Network export
- What does the Data Pump “NETWORK_LINK” parameter allow?
- A) Exporting data over a network
- B) Exporting data from a remote database
- C) Importing data to a remote database
- D) Both B and C
- What is the “QUERY” parameter in Data Pump used for?
- A) Filtering the data to be exported/imported based on a specific condition
- B) Defining the data types to be exported
- C) Controlling export/import permissions
- D) Specifying the output file name
Answers
| Qno | Answer |
|---|---|
| 1 | B) To recover lost or damaged data |
| 2 | D) All of the above |
| 3 | A) A full backup copies all database files, while an incremental backup copies only the changes made since the last backup |
| 4 | B) Incremental backup |
| 5 | D) All of the above |
| 6 | B) Protection against data loss due to failures |
| 7 | C) Hot backup |
| 8 | C) Hot backup |
| 9 | B) Backup of redo logs |
| 10 | C) RMAN backup |
| 11 | B) To perform database backups and recovery |
| 12 | C) Both A and B |
| 13 | D) All of the above |
| 14 | D) Both A and B |
| 15 | D) All of the above |
| 16 | A) RESTORE DATABASE |
| 17 | A) RMAN can automatically perform a backup and delete old backups |
| 18 | D) Both B and C |
| 19 | C) CONFIGURE CHANNEL |
| 20 | A) To validate backup integrity |
| 21 | B) Data migration and export/import |
| 22 | C) EXPDP |
| 23 | D) All of the above |
| 24 | D) IMPDP |
| 25 | A) The method of accessing data for export or import |
| 26 | D) All of the above |
| 27 | A) Job restart |
| 28 | A) Direct path export |
| 29 | D) Both B and C |
| 30 | A) Filtering the data to be exported/imported based on a specific condition |