In this article MCQ on DBMS we give the important MCQ on DBMS with answer and description in details. DBMS stands for Database Management System.
MCQ on DBMS:
1:- What is weak entity set represented in E-R model?
- from circle
- from rectangle
- From doubly outlined rectangle
- From Diamond
Answer:- from doubly outlined rectangle
2:- Which is the key that shows the relationship between tables.
1.secondary key
- foreign key
- primary key
- None of these
Answer:- foreign key
3:- Full name of DBA
- database action
- database access
- database administration
- data bank administration
Answer:- database administration
4:- Which of the following languages is used to define integrity constraints?
- DDL
- DCL
- DML
- None of these
Answer:- DDL
5:- An ATTRIBUTE is called.
- raw
- domain
- field
- column
Answer:- field
6:- Data about data is called.
- Database
- Data Independence
- Meta Data
- Meta Field
Answer:- Meta data
7:- How is the entity set represented in the E-R diagram?
1.rectangle
- circle
- Diamond
- ellipse
Answer:- rectangle
8:- The relationship between two entities is called.
- Quaternary
- Unary
3.Binary
- Ternary
Answer:- binary
9:- Records are organized in hierarchical model.
- Like graph
- Like link
- Like a list
- like a tree
Answer:- like a tree
10:- What does subschema display?
- logical view
- external view
- physical view
- All of these
Answer:- external view
MCQ on DBMS:
11:- Which command is used to insert records in the table?
1.Insert
- Delete
- Update
- Select
Answer:- insert
12:- There is a domain group
- of files
- of record
- of value
- Attribute’s
Answer:- of value
13:- This is the highest level of abstraction in the database.
- Logical level
- Physical level
- View Level
- Internal level
Answer:- View Level
14:- E-R model is
- relational
- internal
- entity-relationship
- network
Answer:- entity – relationship
15:- Which of the following is not a unary operation?
- Select
- Project
3.Union
- Rename
Answer:- union
16:- What is the relationship between three entity sets called?
- Unary
2.Binary
3.Secondary
- Ternary
Answer:- Ternary
17:- There are grant and revoke statements.
- DML
- DCL
- DDL
- None of these
Answer:- DCL
18:- Which of the following is not a schema?
- Database Schema
- Physical Schema
- Critical Schema
- Logical Schema
Answer:- Critical Schema
19:- What is the full name of DFD?
- Data Flow Diagram
- Data Full Document
- Data File Diagram
- Data File Document
Answer:- Data Flow Diagram
20:- What is the full name of SQL?
- Strong Query Language
- Standard Query Language
- Structured Query Language
- None of these
Answer:- Structured Query Language
MCQ on DBMS:
21:- What are the levels of abstraction in DBMS?
- two
- three
- four
- five
Answer:- Three
22:- Who developed normalization?
- Peter Chen
2.E.F. codd
- F.E. codd
- None of these
Answer:- E.F. codd
23:- Full name of BCNF is
- Byce codd normalization
- Basic codd normalization
- By codd normalization
- None of these
Answer:- Byce codd normalization
24:- Which of the following attributes can be taken as primary key?
- Name
- ID
- Class
4.Address
Answer:- ID
25:- How many forms of SQL are there?
- two
- three
- four
- five
Answer:- There are two forms – interactive and embedded.
26:- What is ACID property?
- Atomicity
- Consistency
- Isolation
- Durability
- All of these
Answer:- All these
27:- Which is the key which is made up of a combination of two or more attributes and which is used as a primary key?
1.Composite key
- Secondary key
- Foreign key
4.Candidate key
Answer:-Composite key
28:- Primary key must be
- Unique
- not null
- Both 1 and 2
- None of these
Answer:- Must be both unique and not null.
29:- When did E.F Codd propose the normalization process?
- 1968
- 1970
- 1973
- 1975
Answer:- 1970
Some More:
POP- Introduction to Programming Using ‘C’
OOP – Object Oriented Programming
DBMS – Database Management System
RDBMS – Relational Database Management System
Join Now: Data Warehousing and Data Mining