Here are 50 Objective (MCQ) Questions on Introduction to DBMS (for BCA students) with
answers:
1. DBMS stands for:
A) Data Backup Management System
B) Database Management System
C) Data Basic Management System
D) Database Managing Service
Answer: B
2. A database is:
A) Collection of programs
B) Collection of data
C) Collection of hardware
D) Collection of users
Answer: B
3. Which of the following is an example of DBMS?
A) MS Word
B) MS Excel
C) MySQL
D) Paint
Answer: C
4. Which model organizes data into tables?
A) Hierarchical Model
B) Network Model
C) Relational Model
D) ER Model
Answer: C
5. Who is known as the father of the Relational Model?
A) Charles Babbage
B) E. F. Codd
C) Dennis Ritchie
D) Bill Gates
Answer: B
6. A table in a relational database is also called:
A) Tuple
B) Relation
C) Attribute
D) Instance
Answer: B
7. A row in a table is called:
A) Attribute
B) Field
C) Tuple
D) Domain
Answer: C
8. A column in a table is called:
A) Record
B) Tuple
C) Attribute
D) File
Answer: C
9. Which language is used to interact with DBMS?
A) C++
B) Java
C) SQL
D) HTML
Answer: C
10. SQL stands for:
A) Structured Question Language
B) Structured Query Language
C) System Query Language
D) Sequential Query Language
Answer: B
11. Which of the following is a primary key property?
A) Can be duplicate
B) Can be NULL
C) Unique
D) Optional
Answer: C
12. A foreign key is used to:
A) Uniquely identify records
B) Link two tables
C) Delete records
D) Sort records
Answer: B
13. Which of the following is NOT a DBMS?
A) Oracle Database
B) Microsoft Access
C) Microsoft Word
D) PostgreSQL
Answer: C
14. DBMS reduces:
A) Data redundancy
B) Data size
C) Hardware cost
D) CPU speed
Answer: A
15. Data redundancy means:
A) Data duplication
B) Data security
C) Data sharing
D) Data encryption
Answer: A
16. Which model represents relationships using tree structure?
A) Network
B) Relational
C) Hierarchical
D) ER
Answer: C
17. Which model uses graph structure?
A) Hierarchical
B) Network
C) Relational
D) ER
Answer: B
18. ER model stands for:
A) Entity Relation
B) Entity Relationship
C) Entry Relation
D) Entity Record
Answer: B
19. In ER model, rectangle represents:
A) Attribute
B) Relationship
C) Entity
D) Key
Answer: C
20. Oval represents in ER diagram:
A) Entity
B) Attribute
C) Relationship
D) Key
Answer: B
21. Diamond represents in ER diagram:
A) Attribute
B) Entity
C) Relationship
D) Domain
Answer: C
22. The full form of DDL is:
A) Data Definition Language
B) Data Delete Language
C) Data Derive Language
D) Data Duplicate Language
Answer: A
23. Which command is DDL?
A) SELECT
B) INSERT
C) CREATE
D) UPDATE
Answer: C
24. Which command is DML?
A) DROP
B) INSERT
C) ALTER
D) TRUNCATE
Answer: B
25. SELECT command is used to:
A) Delete data
B) Modify data
C) Retrieve data
D) Create table
Answer: C
26. Which constraint ensures uniqueness?
A) NOT NULL
B) UNIQUE
C) DEFAULT
D) CHECK
Answer: B
27. Which constraint prevents NULL values?
A) PRIMARY KEY
B) NOT NULL
C) UNIQUE
D) CHECK
Answer: B
28. The overall description of database is called:
A) Schema
B) Instance
C) Tuple
D) Domain
Answer: A
29. The actual data in database at a particular time is called:
A) Schema
B) Instance
C) Domain
D) Key
Answer: B
30. Data independence means:
A) Data is independent of users
B) Data is independent of hardware
C) Data is independent of application programs
D) Data is independent of DBMS
Answer: C
31. Which of the following ensures security in DBMS?
A) Authorization
B) Backup
C) Recovery
D) Redundancy
Answer: A
32. Which of the following is a disadvantage of file system?
A) Data redundancy
B) Data sharing
C) Data security
D) Data integrity
Answer: A
33. DBA stands for:
A) Database Administrator
B) Data Backup Administrator
C) Database Analyst
D) Data Base Agent
Answer: A
34. Which key uniquely identifies a record?
A) Foreign Key
B) Candidate Key
C) Primary Key
D) Composite Key
Answer: C
35. A candidate key is:
A) Primary key
B) Foreign key
C) Possible primary key
D) Duplicate key
Answer: C
36. Composite key is:
A) Single attribute key
B) Two or more attributes as key
C) Foreign key
D) Duplicate key
Answer: B
37. Which of the following is a relational DBMS?
A) IBM Db2
B) MS Paint
C) Notepad
D) Calculator
Answer: A
38. Database system is combination of:
A) Data only
B) Hardware only
C) Database and DBMS
D) Software only
Answer: C
39. Which normal form removes partial dependency?
A) 1NF
B) 2NF
C) 3NF
D) BCNF
Answer: B
40. Which normal form removes transitive dependency?
A) 1NF
B) 2NF
C) 3NF
D) 4NF
Answer: C
41. Backup is used for:
A) Security
B) Recovery
C) Storage
D) Deletion
Answer: B
42. Which language is used to control access?
A) DDL
B) DML
C) DCL
D) TCL
Answer: C
43. GRANT command belongs to:
A) DDL
B) DML
C) DCL
D) TCL
Answer: C
44. COMMIT command is part of:
A) DDL
B) DML
C) TCL
D) DCL
Answer: C
45. Which level describes logical structure of database?
A) Physical level
B) Logical level
C) View level
D) File level
Answer: B
46. Which level describes how data is stored physically?
A) Physical level
B) Logical level
C) View level
D) External level
Answer: A
47. Which of the following improves performance?
A) Redundancy
B) Indexing
C) Duplication
D) NULL values
Answer: B
48. Index is used to:
A) Delete data
B) Speed up search
C) Insert data
D) Drop table
Answer: B
49. Which of the following is NOT a type of database model?
A) Relational
B) Hierarchical
C) Network
D) Linear
Answer: D
50. DBMS provides:
A) Data security
B) Data integrity
C) Data sharing
D) All of the above
Answer: D