Computer Knowledge

Database Management Systems

5,344 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

Data dictionary keeps details of the contents of

  1. data flows

  2. data stores

  3. both (1) and (2)

  4. neither (1) nor (2)
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A data dictionary is a centralized repository that stores metadata about data elements, including their definitions, data flows, and data stores.

Multiple choice

A distinguishing feature of strategic information systems is

  1. end-user computing

  2. transaction processing

  3. information for top management

  4. none of these
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Strategic information systems are designed to support long-term goals and decision-making at the highest levels of an organization. Providing information for top management is a primary characteristic of these systems.

Multiple choice

Entities, attributes and relationship are associated with

  1. logical concepts of data

  2. physical concepts of data

  3. person of an organization

  4. none of these

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Entities, attributes, and relationships are the fundamental building blocks of data modeling, which is a logical representation of data before it is physically implemented in a database.

Multiple choice

A software design description document includes

  1. Data dictionary

  2. ER diagram

  3. DFD

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A software design description (SDD) is a comprehensive document that captures the architecture and design details, including data dictionaries, ER diagrams, and data flow diagrams (DFD).

Multiple choice

A data dictionary

  1. gives the meaning of the data names used in the system

  2. defines the data type

  3. defines all data elements and structures used in DFD

  4. none of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Multiple choice

Backup and recovery procedures are necessary to

  1. reorganize the disk

  2. control the DBA

  3. handle contingencies like files getting corrupt or becoming irretrievable

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

Backup and recovery are essential data management practices designed to restore data integrity and availability in the event of hardware failure, corruption, or human error.

Multiple choice

Which of the following is not a function of RDBMS?

  1. Audit trail

  2. Security

  3. File and data integrity

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

Audit trails, security, and data integrity are all standard features and functions provided by modern Relational Database Management Systems (RDBMS).

Multiple choice

____ is known as a set of data.

  1. Field

  2. Record

  3. File

  4. Directory

  5. _
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data has several parts, known as a record, which can be divided into fields. It is an area in a fixed location in a unit of data. It is also known as a set of data.