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

Which of the following is a definition of Dense index?

  1. The entry contains the search key and a pointer in the first data record with that search key value.

  2. Adding other extra overheads

  3. This index entry is not created for every value.

  4. None of these
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Dense index is an entry which contains the search key and a pointer in the first data record with that search key value.

Multiple choice

Data and information with respect to computers mean

  1. data retains information in it

  2. similar concepts

  3. the information is generated from data

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

In computing, data refers to raw facts and figures, while information is the processed, organized, and meaningful output derived from that data.

Multiple choice

Information Technology can be referred to

  1. data storage

  2. data retrieval

  3. data communication

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

Information Technology (IT) encompasses the entire spectrum of managing data, including its storage, retrieval, and communication across systems.

Multiple choice

Structure chart is

  1. a document of what has to be accomplished

  2. a statement of information processing requirement

  3. a hierarchical partitioning of the program

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

A structure chart is a design tool that represents the hierarchical organization of modules in a program, showing the relationship and data flow between them.

Multiple choice

An entry in a telephone book can be compared to a

  1. database

  2. file

  3. record

  4. field
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In database terminology, a single entry in a telephone book, containing information about one person, is analogous to a record. A database is the entire book, and a field is a specific piece of data like a name or phone number.

Multiple choice

A schema describes

  1. record and files

  2. data and elements

  3. record and relationships

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

A database schema provides the blueprint for the database, defining the structure of records, the data elements contained within them, and the relationships between different data entities.

Multiple choice

The distinguishable parts of a record are called

  1. data

  2. files

  3. fields

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

A record is composed of several distinct data items, each of which is stored in a specific field. Fields represent the individual attributes of the record.