Computer Knowledge

Database Management Systems

5,543 Questions

Database Management Systems (DBMS) form the core framework for data storage, retrieval, and security in modern software applications. Concepts such as the E-R model, backup planning, SQL integration, and big data architecture are essential for computer knowledge sections. This hub offers a comprehensive set of practice questions to master DBMS fundamentals and advanced database operations.

E-R Model ConceptsBackup and RecoverySQL Server UpgradesJDBC and ODBCBig Data CharacteristicsData VirtualizationOracle Database

Database Management Systems Questions

Multiple choice

The JDBC classes are present in ____ package.

  1. java.dbms

  2. java.Odbc

  3. java.Jdbc

  4. java.sql
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Java.Sql provides the API for accessing and processing data stored in a data source (usually a relational database) using the JavaTM programming language.

Multiple choice

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)
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

These are the true statements.

Multiple choice

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)
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This is false as the autobackup can be set manually if it is not set.

Multiple choice

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)
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

These are the correct statements.

Multiple choice

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)
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

These are the correct statement about consistent backups with RMAN.

Multiple choice

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
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

All of the above are the correct statements.

Multiple choice

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)
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

AWR maintains the statistics report for the processes and their related problems.