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

Private data can be inherited.

  1. True

  2. False

  3. Sometimes true

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Private members are NOT accessible in derived classes through inheritance. They remain private to the base class. Inheritance gives access to public and protected members, not private ones.

Multiple choice

Microsoft Access is a/an

  1. DBMS

  2. RDBMS

  3. SQL Language

  4. 4GL Language
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Microsoft Access is a Relational Database Management System (RDBMS). It allows users to create and manage relational databases with tables, queries, forms, and reports. While it has DBMS capabilities, it specifically implements the relational model and uses SQL as its query language. It's not just a generic DBMS, a programming language, or a 4GL language.

Multiple choice

Oracle can be compared to

  1. Access

  2. Dbase

  3. SQL Server

  4. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Oracle and Microsoft SQL Server are both enterprise-grade relational database management systems (RDBMS) designed for large-scale data management. They offer similar core functionality including SQL support, transaction management, and robust security features, making them direct competitors in the database market.

Multiple choice

An application program that stores data in columns and rows and permits calculations with the data is known as

  1. sheet

  2. spreadsheet

  3. file

  4. column
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A spreadsheet is application software designed to organize data in tabular format (rows and columns) and perform calculations on that data. Examples include Microsoft Excel and Google Sheets. A sheet is a component within a spreadsheet. A file is a generic storage container. A column is just one dimension of the tabular structure.

Multiple choice

The information in which of the following files is used only to recover the database from a system failure that prevents database data from being written to the data files?

  1. Instance creation

  2. Redo log file

  3. The archive file

  4. The parameter file

  5. Read Only
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The information in a redo log file is used only to recover the database from a system failure that prevents database data from being written to the data files.