What is a data dictionary in a DBMS? MCQ with Answer and Explanation

Question
What is a data dictionary in a DBMS?
A. A backup of the database
B. A repository of metadata about the database
C. A table containing user data
D. A log file
Answer: Option B
Solution (By JKSSB Mock Tests)
The data dictionary stores metadata such as table definitions, column types, constraints, and other database objects.
This question belongs to: Computer Database Management System (DBMS)
Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
Which of the following is an example of a relational database management system (RDBMS)?
A. Redis
B. MongoDB
C. Cassandra
D. Oracle Database
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Oracle Database is a well-known RDBMS. MongoDB, Redis, and Cassandra are NoSQL databases.
This question belongs to: Computer Database Management System (DBMS)
Question #2
What is the purpose of a Foreign Key?
A. To uniquely identify records
B. To create indexes
C. To link two tables and enforce referential integrity
D. To sort data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A foreign key establishes a relationship between tables and maintains referential integrity.
This question belongs to: Computer Database Management System (DBMS)
Question #3
Which operator is used to combine the distinct result sets of two or more SELECT queries into a single output, automatically filtering out duplicate rows?
A. UNION ALL
B. UNION
C. EXCEPT
D. INTERSECT
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The UNION operator merges the result sets of two queries, removing any duplicate records. UNION ALL performs a similar merge but retains duplicates.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Computer Software 347 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?