Module0: Introduction

Question 1

What is database?
A) A random collection of data.
B) An organized collection of unrelated data.
C) An organized collection of related data.
D) A digital storage of images.

Answer 1

C: An organized collection of related data.

Question 2

What does a database typically represent?
A) A fictional scenario.
B) An aspect of the real world.
C) Abstract concepts without real-world application.
D) A collection of computer programs.

Answer 2

B: An aspect of the real world.

Question 3

The term “Universe of Discourse” (UoD) in the context of a database refers to what?
A) The entire universe and its elements.
B) The specific real-world aspect a database represents.
C) The discourse of the database development team.
D) The programming languages used in databases.

Answer 3

B: The specific real-world aspect a database represents.

Question 4

A database should be:
A) Logically incoherent and complex.
B) Logically coherent with some inherent meaning.
C) Built without a specific purpose.
D) Populated with random data.

Answer 4

B: Logically coherent with some inherent meaning.

Question 5

The size and complexity of a database:
A) Are always large and highly complex.
B) Are limited by the data it contains.
C) Can be of any size and complexity.
D) Must be small and simple.

Answer 5

C: Can be of any size and complexity.

Question 6

How may a database be maintained?
A) Manually only.
B) Computerized only.
C) Either manually or computerized.
D) Neither, it maintains itself.

Answer 6

C: Either manually or computerized.

Question 7

What does DBMS stand for?
A) DataBase Management System
B) Data Business Management Software
C) Digital Base Marketing System
D) Database Modeling Software

Answer 7

A: DataBase Management System

Question 8

What is the primary function of a DBMS?
A) To manage and organize digital marketing strategies.
B) To define, construct, and manipulate databases for various applications.
C) To exclusively handle data storage on cloud platforms.
D) To manage the financial transactions in a database.

Answer 8

B: To define, construct, and manipulate databases for various applications.

C is wrong becuase a DBMS is not limited to cloud platforms; it is a broader system for managing databases on various platforms.

Question 9

DBMSs can be categorized into which of the following?
A) Only general-purpose for business applications.
B) Only special-purpose for scientific databases.
C) General-purpose and special-purpose.
D) Solely for gaming applications.

Answer 9

C: General-purpose and special-purpose.

Question 10

What does the DBMS facilitate in terms of a database?
A) Painting
B) Defining
C) Singing
D) Dancing

Answer 10

B: Defining

Question 11

When constructing a database, what is the key activity involved?
A) Writing code for video games
B) Storing data on a storage medium
C) Performing arithmetic calculations
D) Designing graphics

Answer 11

B: Storing data on a storage medium

Question 12

Database manipulation primarily includes:
A) Querying and updating the database
B) Surfing the internet
C) Emailing clients
D) Generating powerpoints

Answer 12

A: Querying and updating the database

Question 13

What is an aspect of maintaining a database?
A) Ensuring database efficiency, correctness, and safety
B) Ensuring the database is entertaining
C) Maintaining the physical hardware only
D) Focusing on aesthetic design

Answer 13

A: Ensuring database efficiency, correctness, and safety

Question 14

What is the 4 components of database system?

Answer 14

Stored database, DBMS, applications, and users

Users
|
Application programs and Interactive Queries
|
DBMS
|
Database

Question 15

Which of the following is a function of the DBMS?
A) Data Integrity Maintenance
B) Social Media Management
C) Graphic Design
D) Website Hosting

Answer 15

A) Data Integrity Maintenance

Question 16

What is an important aspect of a DBMS in relation to data?
A) Query Processing
B) Video Editing
C) Game Development
D) Virtual Reality Creation

Answer 16

A) Query Processing

Question 17

What does DBMS provide to protect the data?
A) Security Management
B) Physical Security Guards
C) Encryption Only
D) Antivirus Software

Answer 17

A) Security Management

Question 18

How does DBMS handle simultaneous data access?
A) Concurrency Control
B) Multi-User Gaming
C) Network Traffic Management
D) Email Synchronization

Answer 18

A) Concurrency Control

Question 19

What feature of the DBMS is critical for data loss prevention?
A) Backup & Recovery
B) Cloud Storage
C) Defragmentation
D) Power Supply Management

Answer 19

A) Backup & Recovery

Question 20

Which of the following is not a function of the DBMS
A) Enforcing integrity constraints
B) Design a database
C) Backup and Recovery of Database
D) Providing secure access to the database

Answer 20

B: Design a database

Question 21

What does the External Level of a database provide?
A) The physical storage structure.
B) Access to particular parts of the database to users.
C) The structure of the whole database.
D) Mapping between the conceptual and internal levels.

Answer 21

B: Access to particular parts of the database to users.

Question 22

What is described by the Conceptual Level of a database?
A) Specific user views of the database.
B) The mapping between stored data and the user views.
C) The structure of the whole database for a community of users.
D) The location of the database servers.

Answer 22

C: The structure of the whole database for a community of users.

Question 23

Which level of a database describes the physical storage structure?
A) External Level
B) Conceptual Level
C) Internal Level
D) Data Level

Answer 23

C: Internal Level

Question 24

What is the purpose of the External Level in database architecture?

Answer 24

The External level provides a specific view of the database that is customized to meet the needs of different end users, allowing access to certain parts of the database.

Question 25

Explain the Conceptual Level in a database.

Answer 25

The conceptual level represents the entire database as a whole and defines the structure of how data is stored, accessed, and related within the database for all users.

Question 26

Describe the role of the Internal Level in database architecture.

Answer 26

The internal level outlines the physical storage of data on storage mediums, detailing how the data is actually stored, organized, and retrieved by the system.

Question 27

What is Data Independence?
A) The capability to modify a schema without affecting the user interface.
B) The dependency of data on the application programs.
C) The inability to change the database schema.
D) The connection between different databases.

Answer 27

A: The capability to modify a schema without affecting the user interface.

Question 28

What does Logical Data Independence allow for?
A) Changes to the internal schema without altering the conceptual schema.
B) Changes to the conceptual schema without altering the external views or applications.
C) Alterations to the database content.
D) Modifications to user permissions only.

Answer 28

B: Changes to the conceptual schema without altering the external views or applications.

Question 29

Physical Data Independence gives the ability to:
A) Change the external schema without changing the internal schema.
B) Modify the physical schema without changing the logical schema.
C) Alter the conceptual schema without changes to the external views.
D) Update the application programs without altering the database.

Answer 29

B: Modify the physical schema without changing the logical schema.

Question 30

Define Data Independence in the context of database systems.

Answer 30

Data Independence in the ability to change the schema at one level of a database without having to change the schema at the next higher level.

Question 31

What is Logical Data Independence and why is it important?

Answer 31

Logical Data Independence is the ability to change the conceptual schema without altering the external views or applications. It is important because it allows the database to evolve without disrupting the user experience.

Question 32

Explain Physical Data Independence.

Answer 32

Physical Data Independence is the ability to modify the physical storage of data (the internal schema) without having to change the logical structure of the database (the conceptual schema). This allows for the optimization or alteration of the physical data layout without affecting the database’s logic.

Question 33

Considering the Three-Schema Architecture,
which of the following is correct?

A) The conceptual level describes the physical storage structure of the database.
B) Logical data independence provides the ability to move the physical location of where data is stored without making changes to the applications.
C) Physical data independence provides the ability to modify physical schema without making changes to the logical schema.
D) The external level provides access to changing the schema of the relations in a database.

Answer 33

C: Physical data independence provides the ability to modify physical schema without making changes to the logical schema.

Question 34

What is an Entity-Relationship (ER) model primarily used for in a relational database?
A) To visualize the physical storage of data.
B) To encode the conceptual schema.
C) To create a backup of the database.
D) To manage the database security.

Answer 34

B) To encode the conceptual schema.

A)To visualize the physical storage of data is incorrect because the ER model is used for conceptual schema representation, not for detailing physical storage.

Question 35

The ER model is a graphical technique used to represent:
A) The programming code behind the database.
B) The main entities and their relationships within a system or enterprise.
C) The aesthetic design of the database interface.
D) The financial aspects of managing a database.

Answer 35

B) The main entities and their relationships within a system or enterprise.