Vaidikalaya

MCQ On DBMS Basic

Q1. What is the full form of DBMS?.
  1. Data of Binary Management System
  2. Database Management System
  3. Database Management Service
  4. Data Backup Management System

Answer: b, Database Management System

Solution: DBMS stands for Database Management System. It stores and allows manipulation of data efficiently.

Q2. What is DBMS?.
  1. DBMS is a collection of queries
  2. DBMS is a high-level language
  3. DBMS is a programming language
  4. DBMS stores, modifies and retrieves data

Answer: d, DBMS stores, modifies and retrieves data

Solution: DBMS is a system that stores, modifies, and retrieves organized data.

Q3. Which type of data can be stored in the database?.
  1. Image oriented data
  2. Text, files containing data
  3. Data in the form of audio or video
  4. All of the above

Answer: d, All of the above

Solution: DBMS supports multiple data types like text, image, audio, and video.

Q4. In which format is data stored in DBMS?.
  1. Image
  2. Text
  3. Table
  4. Graph

Answer: c, Table

Solution: Data is stored in table format for easy management and access.

Q5. Which of the following is not a type of database?.
  1. Hierarchical
  2. Network
  3. Distributed
  4. Decentralized

Answer: d, Decentralized

Solution: Common database types: Centralized, Distributed, Relational, NoSQL, etc. Decentralized is not one.

Q6. Which of the following is not an example of DBMS?.
  1. MySQL
  2. Microsoft Access
  3. IBM DB2
  4. Google

Answer: d, Google

Solution: Google is a search engine, not a DBMS.

Q7. Which of the following is not a feature of DBMS?.
  1. Minimum Duplication and Redundancy of Data
  2. High Level of Security
  3. Single-user Access only
  4. Support ACID Property

Answer: c, Single-user Access only

Solution: DBMS supports multiple-user access; single-user access is not a feature.

Q8. Which of the following is a feature of the database?.
  1. No-backup for the data stored
  2. User interface provided
  3. Lack of Authentication
  4. Store data in multiple locations

Answer: b, User interface provided

Solution: Database provides user interface, authentication, and backup mechanisms.

Q9. Which of the following is not a function of the database?.
  1. Managing stored data
  2. Manipulating data
  3. Security for stored data
  4. Analysing code

Answer: d, Analysing code

Solution: DBMS manages, stores, manipulates, and secures data but doesn’t analyze code.

Q10. Which of the following is known as a set of entities of the same type that share same properties or attributes?.
  1. Relation set
  2. Tuples
  3. Entity set
  4. Entity Relation model

Answer: c, Entity set

Solution: Entity set represents entities of the same type sharing common attributes.

Q11. What is information about data called?.
  1. Hyper data
  2. Tera data
  3. Meta data
  4. Relations

Answer: c, Meta data

Solution: Metadata is information describing data, such as its type, format, and meaning.

Q12. What does an RDBMS consist of?.
  1. Collection of Records
  2. Collection of Keys
  3. Collection of Tables
  4. Collection of Fields

Answer: c, Collection of Tables

Solution: RDBMS organizes data into tables containing fields (columns) and records (rows).

Q13. According to which integrity constraint must values in referencing attributes match specified attributes in referenced relation?.
  1. Referential
  2. Primary
  3. Referencing
  4. Specific

Answer: a, Referential

Solution: Referential integrity ensures relationships between tables are consistent.

Q14. _____________ is a hardware component important for DBMS operation..
  1. Microphone
  2. High speed, large capacity disk to store data
  3. High-resolution video display
  4. Printer

Answer: b, High speed, large capacity disk to store data

Solution: Databases require large-capacity, high-speed disks for data storage.

Q15. The DBMS acts as an interface between ________________ and ________________..
  1. Data and the DBMS
  2. Application and SQL
  3. Database application and the database
  4. The user and the software

Answer: c, Database application and the database

Solution: DBMS acts as a bridge between database applications and the actual database.

Q16. Procedural language among the following is __________.
  1. Domain relational calculus
  2. Tuple relational calculus
  3. Relational algebra
  4. Query language

Answer: c, Relational algebra

Solution: Relational algebra is a procedural language used in database queries.

Q17. Which of the following is not a utility of DBMS?.
  1. Backup
  2. Data Loading
  3. Process Organization
  4. File organization

Answer: c, Process Organization

Solution: Backup and file organization are DBMS utilities; process organization is not.

Q18. Which of the following is the best way to represent attributes in a large DB?.
  1. Dot representation
  2. Concatenation
  3. Relational-and
  4. All of the mentioned

Answer: b, Concatenation

Solution: Concatenation helps join two or more fields to form a combined attribute.

Q19. The oldest DB model is _______________.
  1. Network
  2. Physical
  3. Hierarchical
  4. Relational

Answer: c, Hierarchical

Solution: Hierarchical DB model (1960s, IBM) used a parent-child structure.

Q20. Which of the following establishes a top-to-bottom relationship among the items?.
  1. Relational schema
  2. Network schema
  3. Hierarchical schema
  4. All of the mentioned

Answer: c, Hierarchical schema

Solution: Hierarchical schema represents data in a tree-like parent-child relationship.

Q21. The logical design and the snapshot of data at a given time is known as?.
  1. Instance & Relation
  2. Relation & Schema
  3. Domain & Schema
  4. Schema & Instance

Answer: d, Schema & Instance

Solution: Schema defines structure; instance is the data at a particular moment.