Home › Quizzes › Oracle Database: Backup, Recovery and Performance Tuning

Oracle Database: Backup, Recovery and Performance Tuning

Test your knowledge of Oracle database administration including RMAN backup and recovery procedures, automatic performance tuning tools (AWR, ADDM), and instance optimization techniques for CS and GATE aspirants.

16 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following is/are true about incremental back up of RMAN in oracle database recovery?

  1. It includes all used data blocks in the datafiles.
  2. It includes a backup of datafiles that includes only the blocks that have changed since a previous incremental backup.
  3. Incremental backups of control files and archived logs always include all blocks in the files.
  4. Incremental backups require a full or incremental level 0 backup to serve as a basis.
  5. Both (2) and (4)
Question 2 Multiple Choice (Single Answer)

Which of the following is false about backing up control files with RMAN?

  1. Backing up the control file can be done only when the database is mounted or open.
  2. The control file autobackup contains metadata about the previous backup.
  3. We can not manually set the autobackup.
  4. BACKUP CURRENT CONTROLFILE command is used to run the backup.
  5. Both (2) and (3)
Question 3 Multiple Choice (Single Answer)

Which of the following is/are true about 'Image copies' back up in RMAN recovery?

  1. In this recovery, RMAN is responsible for creating the copes of datafiles and control files.
  2. In this backup, RMAN only records backup sets in the repository that complete successfully.
  3. Image copy backups can only be created on disk.
  4. All of the above
  5. Both (1) and (3)
Question 4 Multiple Choice (Single Answer)

Which of the following is/are applicable in backup sets in RMAN backup?

  1. A backup set consists of one or more files.
  2. In this backup, RMAN only records backup sets in the repository that complete successfully.
  3. In this backup, RMAN also supports binary compression of backup sets.
  4. All of the above
  5. Both (1) and (3)
Question 5 Multiple Choice (Single Answer)

Which of the following is/are true about consistent backups with RMAN?

  1. A consistent database will be in consistent state when the database is shut down normally.
  2. At consistent state, all the changes in the redo log have been applied to the datafiles.
  3. For a consistent database state, Oracle must perform media recovery before the database can be opened.
  4. All of the above
  5. Both (1) and (2)
Question 6 Multiple Choice (Single Answer)

What information needs to be checked during validation of datafiles using RMAN?

  1. Datafiles exist or not.
  2. This backup validation discovers corrupt blocks.
  3. RMAN can issues an error message, in case if it cannot validate the backup of one or more of the files.
  4. All of the above
  5. Both (1) and (3)
Question 7 Multiple Choice (Single Answer)

Which of the following is incorrect statement about backing up database files using RMAN recovery?

  1. Backing Up database files using RMAN, we can backup one or more individual tablespaces.
  2. Backing Up database files using RMAN , we can back up datafiles and datafile copies when the database is mounted or open.
  3. In this backup, RMAN uses a snapshot control file to ensure a read-consistent version.
  4. In this back up, datafile copies exist on disk only.
  5. None of the above
Question 8 Multiple Choice (Single Answer)

Which of the following information is contained by the RMAN report?

  1. Information related to the datafiles backup
  2. Information related to datafiles recoverability
  3. Information related to current physical schema of the database
  4. All of the above
  5. Both (2) and (3)
Question 9 Multiple Choice (Single Answer)

Which of the following is/are false about RMAN LIST command?

  1. The LIST command is used to query the RMAN repository.
  2. This command is used to backup sets and image copies.
  3. RMAN LIST output is sent either to standard output or to the message log.
  4. This command can cause the deletion of backups or archived logs.
  5. Both (2) and (4)
Question 10 Multiple Choice (Single Answer)

Which of the following is/are true about Automatic Workload Repository (AWR) in automatic performance tuning ?

  1. It is responsible for maintaining performance statistics for problem detection and self-tuning purposes.
  2. It provides a quick and efficient technique for optimizing SQL statements without modifying any statements.
  3. It provides advice on materialized views, indexes, and materialized view logs.
  4. It provides server generated alerts.
  5. Both (1) and (2)
Question 11 Multiple Choice (Single Answer)

Which of the following is/are true about Automatic Database Diagnostic Monitor (ADDM) in automatic performance tuning of oracle database?

  1. It is used to collect, process, and maintain performance statistics for problem detection and self-tuning purposes
  2. It is used to analyse the information collected by the AWR for possible performance problems with the Oracle database.
  3. It provides a quick and efficient technique for optimizing SQL statements without modifying any statements.
  4. It provides end-to-end application tracing.
  5. Both (1) and (2)
Question 12 Multiple Choice (Single Answer)

Which of the following baselines is/are necessary during performance tuning planning of oracle database?

  1. Database statistics
  2. Operating system statistics
  3. Application statistics
  4. Network statistics
  5. All of the above
Question 13 Multiple Choice (Single Answer)

Which of the following is/are applicable for SQL tuning advisor in automatic performance tuning of oracle database?

  1. It allows a quick and efficient technique for optimizing SQL statements.
  2. It collects, processes and maintains performance statistics for problem detection.
  3. It provides advice on materialized views, indexes, and materialized view logs.
  4. It analyses the information from the Automatic Workload Repository (AWR) for possible performance problems with the Oracle database.
  5. Both (1) and (3)
Question 14 Multiple Choice (Single Answer)

Which of the following problems occur(s) in performance tuning of oracle database?

  1. Latch contention
  2. Slow physical I/O
  3. Excessive CPU usage
  4. All of the above
  5. Both (2) and (3)
Question 15 Multiple Choice (Single Answer)

Which of the following is/are true about instance tuning in oracle database?

  1. It considers allocation of memory to database structures.
  2. It determine the I/O requirements of different parts of the database.
  3. It tunes the operating system for optimal performance of the database.
  4. All of the above
  5. Both (2) and (3)
Question 16 Multiple Choice (Single Answer)

Which of the following factors can affect the scalability in performance tuning in oracle database?

  1. Data consistency
  2. Operating system workload
  3. Reduced availability
  4. All of the above
  5. Both (2) and (3)
← Back to Quizzes