Database Management Systems: Master Data Storage and Retrieval

Question 1

Which of the following is **NOT** a type of database management system (DBMS)?

Accepted Answer

Flat-file DBMS

Answer

Relational DBMS

Answer

Object-oriented DBMS

Answer

Cloud-based DBMS

Question 2

Which of the following is a key characteristic of a relational DBMS?

Accepted Answer

Data is stored in tables with rows and columns

Answer

Supports advanced data types and relationships

Answer

Provides a user-friendly graphical interface

Answer

Designed for handling small datasets

Question 3

What is the key difference between a table and a view in a database?

Accepted Answer

A table is a physical data structure, while a view is a virtual representation of data

Answer

A view is a physical data structure, while a table is a virtual representation of data

Answer

A table and a view are interchangeable concepts

Answer

A view is a type of table that can be updated

Question 4

Which database constraint ensures that a foreign key value in one table matches a primary key value in another table?

Accepted Answer

Foreign Key

Answer

Primary Key

Answer

Unique

Answer

Not Null

Question 5

Which database storage model organizes data in a hierarchical structure, where each parent node can have multiple child nodes?

Accepted Answer

Hierarchical Model

Answer

Relational Model

Answer

Network Model

Answer

Object-Oriented Model

Question 6

What is the primary purpose of a primary key in a database table?

Accepted Answer

To uniquely identify each record within the table

Answer

To determine the most significant data in the table

Answer

To establish relationships with other tables

Answer

To enforce data accuracy and completeness

Question 7

Which Structured Query Language (SQL) statement would you use to retrieve data from a database?

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 8

What is the primary responsibility of a database administrator (DBA)?

Accepted Answer

Managing and maintaining the operational efficiency of database systems

Answer

Designing and implementing database applications

Answer

Utilizing SQL to query and manipulate database information

Answer

Providing technical support to database users

Question 9

Which of the following data types is designed to represent dates and times?

Accepted Answer

Date

Answer

Integer

Answer

String

Answer

Float

Question 10

What is the purpose of a transaction in the context of a database system?

Accepted Answer

To ensure that all operations within a transaction are executed as a single unit

Answer

To allow multiple users to access the database simultaneously

Answer

To create a backup of the database

Answer

To restore the database in the event of a failure

Question 11

Which component is NOT found in a relational database management system (RDBMS)?

Accepted Answer

Information Processor

Answer

Data

Answer

Metadata

Answer

Storage

Question 12

What is the primary purpose of a primary key in a database table?

Accepted Answer

To ensure that each row has a unique identifier

Answer

To link to related data in other tables

Answer

To store the most critical data

Answer

To enhance data retrieval speed

Question 13

Which SQL statement is used to retrieve data from a database?

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 14

What is the primary goal of normalization in database design?

Accepted Answer

To reduce data redundancy and improve accuracy

Answer

To simplify data retrieval and update operations

Answer

To ensure consistent data storage formats

Answer

To enhance database performance

Question 15

What is the purpose of a primary key in a database table?

Accepted Answer

To uniquely identify each row

Answer

To store the most important data in the table

Answer

To enforce referential integrity in related tables

Answer

To provide a unique index for faster sorting

Question 16

Which of the following is a data manipulation language (DML)?

Accepted Answer

SQL

Answer

HTML

Answer

XML

Answer

C++

Question 17

What is the fundamental difference between a flat-file database and a relational database?

Accepted Answer

Flat-file databases store data in a single table, while relational databases store data in multiple tables linked by relationships.

Answer

Relational databases are more efficient than flat-file databases.

Answer

Flat-file databases are easier to design than relational databases.

Answer

There is no fundamental difference between flat-file databases and relational databases.

Question 18

Which of the following is NOT a primary component of a Database Management System (DBMS)?

Accepted Answer

Spreadsheet

Answer

Database engine

Answer

Query language

Answer

Data dictionary

Question 19

What is the primary purpose of a primary key in a relational database?

Accepted Answer

To uniquely identify each row in a table

Answer

To enforce relationships between tables

Answer

To improve the performance of queries

Answer

To store the most important data in the table

Question 20

Which SQL statement is primarily used to retrieve data from a database?

Accepted Answer

SELECT

Answer

INSERT

Answer

DELETE

Answer

UPDATE

Question 21

Which of the following is a significant benefit of utilizing a DBMS?

Accepted Answer

Improved data security

Answer

More complex data access

Answer

Increased data redundancy

Answer

Reduced data consistency

Question 22

What is the primary purpose of a database index?

Accepted Answer

To enhance the speed of data retrieval

Answer

To enforce data integrity

Answer

To store metadata about the database

Answer

To delete duplicate data

Question 23

What is the fundamental purpose of a database transaction?

Accepted Answer

To maintain the integrity of data during multiple database operations

Answer

To allow multiple users to access the database concurrently

Answer

To create backups of the database

Answer

To speed up data processing

Question 24

Which of the following is an example of a cloud-based database service?

Accepted Answer

Amazon Relational Database Service (RDS)

Answer

Microsoft Access

Answer

Oracle Database

Answer

MySQL Workbench

Question 25

What is the key difference between structured and unstructured databases?

Accepted Answer

Structured data is organized in a fixed format, while unstructured data is not.

Answer

Structured data is more secure than unstructured data.

Answer

Structured data is easier to query than unstructured data.

Answer

Structured data is typically stored in relational databases, while unstructured data is stored in flat files.