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

What is a data record?

  1. Total information

  2. Complete set of related information

  3. All font styles

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

Complete test of selected information

Multiple choice

The entity- relationship model comes under

  1. object based logical model

  2. record based logical model

  3. physical data model

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

The E-R model is classified as an object-based logical model because it describes data in terms of entities and relationships rather than tables or records.

Multiple choice

Loss of data integrity implies that data is

  1. not suitable for running in an integrated environment

  2. inconsistent

  3. repeated

  4. outdated

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

Data integrity refers to the accuracy, completeness, and consistency of data over its lifecycle. When data is inconsistent, it means the integrity has been compromised.

Multiple choice

In a hospital data base system, the data relationship between the entity “Patient” and the entity “ward” would be

  1. one-to-one

  2. one-to-many

  3. many-to-one

  4. many-to-many
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In a hospital database, one ward contains many patients, and a patient is typically assigned to one ward. However, if the system tracks patient history across multiple wards or multiple patients per ward, it is often modeled as a many-to-many relationship depending on the specific business rules.

Multiple choice

Data integrity stands for

  1. thoroughly validated data

  2. data stored in different files showing consistency

  3. data fields integrated to provide summary

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

Data integrity refers to the accuracy and consistency of data. Since none of the provided options fully define the concept, 'None of these' is the most appropriate choice.

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.