DBMS MIDTERM EXAM MCQ (2024-25)
Authored by JONARD LOPEZ
Information Technology (IT)
University
Used 3+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
30 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following best explains the primary purpose of normalization in database design?
To speed up query execution
To remove the need for primary keys
To minimize redundancy and maintain integrity
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a characteristic of a weak entity in an ER diagram?
Has its own unique primary key
Depends on a related strong entity for identification
Cannot be connected to other entities
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which schema focuses purely on the actual storage of data?
Conceptual Schema
Physical Schema
Logical Schema
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a potential disadvantage of database normalization?
Reduces data integrity
Increases query complexity
Leads to data redundancy
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the ACID properties of a DBMS, what does 'Atomicity' ensure?
Transactions are always fast
A transaction is fully completed or not executed at all
All users have equal access
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is NOT a correct description of a multivalued attribute?
It stores multiple values
It is represented by double ellipses in ERD
It can act as a unique identifier
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following best defines a foreign key?
A column that stores unique values only
A reference to the primary key of another table
A key used for encryption purposes
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
