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

Which of the following is an example of a semi-structured data type?

  1. JSON

  2. XML

  3. CSV

  4. Images
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

JSON (JavaScript Object Notation) is a semi-structured data format that uses key-value pairs to represent data.

Multiple choice

What is the term used to describe data that is stored in a relational database management system?

  1. Structured Data

  2. Semi-Structured Data

  3. Unstructured Data

  4. Relational Data
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Relational Data refers to data that is stored in tables, with rows and columns, and related to each other through primary and foreign keys.

Multiple choice

Which of the following is an example of a NoSQL database?

  1. MySQL

  2. PostgreSQL

  3. MongoDB

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

MongoDB is a NoSQL database that uses a document-oriented data model, where data is stored in JSON-like documents.

Multiple choice

Which of the following is an example of a data lake?

  1. Hadoop Distributed File System (HDFS)

  2. Amazon S3

  3. Microsoft Azure Data Lake Store

  4. Google Cloud Storage
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Hadoop Distributed File System (HDFS) is a distributed file system that is commonly used as a data lake for storing large volumes of data.

Multiple choice

What are some of the most important legal research databases?

  1. LexisNexis

  2. Westlaw

  3. Bloomberg Law

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

LexisNexis, Westlaw, and Bloomberg Law are all major legal research databases that provide access to a wide range of legal materials.

Multiple choice

Which preservation strategy involves converting digital data into a standardized format?

  1. Normalization.

  2. Digitization.

  3. Migration.

  4. Emulation.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Normalization is a preservation strategy that involves converting digital data into a standardized format, often based on open standards, to ensure its long-term accessibility and compatibility with different systems.

Multiple choice

Which preservation approach involves creating multiple copies of digital data and storing them in different locations?

  1. Data Replication.

  2. Data Migration.

  3. Data Encryption.

  4. Data Compression.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data Replication is a preservation approach that involves creating multiple copies of digital data and storing them in different locations to ensure redundancy and protect against data loss or corruption.

Multiple choice

What is the primary purpose of a database management system (DBMS)?

  1. To store and manage data

  2. To process data

  3. To retrieve data

  4. To update data
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A DBMS is a software system that allows users to create, manage, and access data in a database.

Multiple choice

Which of the following is a type of database model?

  1. Relational

  2. Hierarchical

  3. Network

  4. Object-oriented
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A relational database model is a type of database model that represents data in the form of tables, where each table consists of rows and columns.

Multiple choice

What is the purpose of a view in a database?

  1. To store data

  2. To process data

  3. To retrieve data

  4. To update data
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A view is a virtual table that is defined by a query. Views are used to retrieve data from a database.

Multiple choice

What is the purpose of a stored procedure in a database?

  1. To store data

  2. To process data

  3. To retrieve data

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

A stored procedure is a set of SQL statements that are stored in the database and can be executed as a single unit.

Multiple choice

What is the purpose of a lock in a database?

  1. To prevent other users from accessing data

  2. To prevent other users from updating data

  3. To prevent other users from deleting data

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

A lock is a mechanism that prevents other users from accessing, updating, or deleting data.

Multiple choice

What is the purpose of a database administrator (DBA)?

  1. To manage the database

  2. To design the database

  3. To implement the database

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

A DBA is responsible for managing, designing, and implementing a database.

Multiple choice

Which of the following is NOT a dimension of data quality?

  1. Accuracy

  2. Completeness

  3. Consistency

  4. Timeliness

  5. Relevance
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Relevance is not a dimension of data quality. The dimensions of data quality are accuracy, completeness, consistency, and timeliness.

Multiple choice

What is the process of ensuring that data is accurate, complete, consistent, and timely?

  1. Data profiling

  2. Data cleansing

  3. Data validation

  4. Data governance

  5. Data integration
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Data cleansing is the process of ensuring that data is accurate, complete, consistent, and timely.