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 ____________ component is used by the data analyst to create the queries that access the database.

  1. data extraction

  2. end-user query tool

  3. end-user presentation tool

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

End-user query tools provide graphical interfaces or wizards that allow data analysts to construct database queries and retrieve data without writing raw SQL code. Data extraction and data stores are backend processes, not user-facing tools.

Multiple choice

______ describe what are database fields.

  1. Structures

  2. Field markers

  3. Field definitions

  4. Field names

  5. None of these
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Field names are the identifiers that describe what each database field represents. While 'Field definitions' would be more comprehensive, 'Field names' is the most appropriate answer among the given choices as it directly addresses what fields are called.

Multiple choice

When data changes in multiple lists and all lists are not updated, this causes

  1. data redundancy

  2. information overload

  3. duplicate data

  4. data inconsistency

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

Data inconsistency occurs when the same data exists in multiple locations and only some of those locations are updated during a change. This is a common problem in poorly designed databases that lack proper normalization or update mechanisms.

Multiple choice

The code that relational database management systems use to perform their database task is referred to as

  1. QBE

  2. SQL

  3. OLAP

  4. OLTP

  5. None of these
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SQL (Structured Query Language) is the standard programming language that relational database management systems use to perform their database tasks including querying, updating, and managing data. QBE is an alternative query interface, OLAP is for analytical processing, and OLTP refers to transaction processing systems.

Multiple choice

A database management system (DBMS) is a

  1. hardware system used to create, maintain and provide controlled access to a database

  2. hardware system used to create, maintain and provide uncontrolled access to a database

  3. software system used to create, maintain and provide uncontrolled access to a database

  4. software system used to create, maintain and provide controlled access to a database

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

A database management system (DBMS) is a software system used to create, maintain and provide controlled access to a database.

Multiple choice

The ____________ contains data descriptions and defines the name, data type and length of each field in the database.

  1. data dictionary

  2. data table

  3. data record

  4. data field

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

A data dictionary (or metadata repository) is a centralized repository that stores comprehensive descriptions of data elements including names, data types, lengths, constraints, and relationships. Unlike data tables (which store actual data), data records (rows), or data fields (individual cells), the data dictionary stores metadata about the database structure itself.

Multiple choice

Which of the following does not describe a data warehouse?

  1. Subject oriented

  2. Integrated

  3. Time variant

  4. Updateable

  5. None of these
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The four key characteristics of data warehouses are: subject-oriented (organized by subject), integrated (consistent data from multiple sources), time-variant (historical perspective), and NON-VOLATILE (not updateable). Data warehouses are designed for read-heavy analytical queries, not transactional updates. Updateable is the characteristic that does NOT apply to traditional data warehouses.

Multiple choice

Which of the following is true?

  1. Logical design is software dependent.

  2. In a distributed database, database is stored in one physical location.

  3. Conceptual design translates the logical design into internal model.

  4. Logical design is software independent.

  5. None of these
Reveal answer Fill a bubble to check yourself
A Correct answer
Multiple choice

Which of the following statements is incorrect about Decision Support System?

  1. Decision Support System is computer based information system.

  2. Decision Support System uses analytical models and specialised databases.

  3. Decision Support System is necessary for the manager's perspective.

  4. Decision Support System is needed at each step in the organisational task.

  5. Decision Support System can be performed by any member in the business hierarchy.
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

DSS can be performed by the manager or the topmost employee of the organisational hierarchy.