Database Management System Quiz | DBMS Quiz for diploma - oklesson

There are a subject in Polytechnic 4 Semester(CSE) Which is Database Management System. This is the very Important Subject . Database Management System is very important when you develop a full stack Application. It is used to store data. So in this post we are Covering DBMS Basic Quiz , In DBMS Basic Quiz We provided 30 Database Management System MCQs which have chance to ask your exam.

Basic Database Management System Quiz

This Database Management Quiz we take very basic MCQs, these MCQs are related to data model, File System, database language and More. So First try to solve Question himself and after that you can see Answer. So Let' Start DBMS Basic Quiz.

Image-Source: Pixabay.com

Important DBMS MCQs | DBMS Quiz

1. In E - R diagram Weak entity presented by....

A) Circle

B) Cube

C) Rectangle

D) Double Rectangle

2. How many of Components of DBMS ?

A) 2

B) 3

C) 5

D) 4

3. Which is the Component of Database Management System ?

A) Hardware, Database, Software, Data, User

B) Hardware, Software, Data, Procedure, DAL(Database Access Language)

C) Hardware, User, Information, Software, data

D) Hardware, Information, System, DAL, Software 

Also Read:

• Basic Operating System Quiz
• Basic Java Quiz

4. How many elements of  a Database?

A) 2

B) 1

C) 3

D) 4

5. Which is the correct name of database elements ? 

A) Hardware, data, Relationship, Constraints

B) Software, Data, Relationship, Constraints

C) Data, Relationship, Constraints, Schema

D) Data, Relationship, Constraints, Information

6. What is the Advantage of File System over DBMS ?

A) Low Cost

B) No Complexity

C) High Data Security

D) Both A & B

7. How many types of Data Abstraction ?

A) 2

B) 5

C) 4

D) 3

8. Which Database Language Used to create Schema ?

A) DML (Data Manipulation Language)

B) DCL (Data Control Language)

C) DDL (Data Definition Language)

D) TCL (Transaction Control Language)

9. Schema represent is......

A) Physical View of Database

B) Logical View of Database

C) Both A & B

D) None of these

10. Which is Correct Views of Data ?

A) External View, Conceptual View, Internal View

B) External View, logical view, internal View

C) External view, Dictionary view, Internal view

D) All of the Above

11. E-R Diagram define....

A) Logical View of  Database

B) Physical View of Database

C) Conceptual View of Database

D) Hierarchy view of Database

12. E-R Model...

A) Reduce Data Redundancy 

B) define Conceptual view

C) Both A & B

D) None of these

13. What is Data-item ?

A) A field 

B) Smallest Unit of Data

C) A Record

D) Both A & B

14. Is all Candidate Keys are Super Keys ?

A) Yes

B) No

15. Another name of tuple ....

A) Row

B) Field

C) Data

D) Table

16. Simplest database Architecture is....

A) 3 - Tier

B) 2- Tier

C) 1- Tier

D) All of the Above

17. SQL Stand For.......

A) Structure Query Language

B) Social Query Language

C) Structured Query Language

D) All of the Above

18. Which SQL statement is used to extract data from Database ?

A) INSERT

B) SELECT

C) TRUNCATE

D) ALTER

19. Which one is true About SQL ?

A) It is a Database Access Language

B) It is Case Sensitive

C) It is a Programming Language

D) None of the above.

20. Extract data from database with Apply some condition, Which Clause do you use ?

A) WHERE

B) PRIMARY

C) NULL

D) None of the Above

21. Default Order of Order By clause....

A) Ascending Order

B) Descending Order

C) Between Order

D) None of the Above

22. Which statement is true to extract Every data from a table ?

A) Select everything from table_name

B) Select *  from table_name

C) SELECT * FROM table_name

D) Both B & C

23. Which Command is Used to delete all Records but not delete Schema ?

A) Truncate

B) Drop

C) delete

D) Alter

24. Which is not a DDL Command ?

A) Alter

B) Drop

C) Truncate

D) Delete

25. Which Data Type is Perfect for Store E-mail

A) Varchar

B) char

C) Nvarchar

D) None of the above

26. The mySql Count() function return..

A) float value

B) double value

C) int value

D) char value

27. 4NF Stand for...

A) Fourth Normal Form

B) Fourth New Form

C) Fourth New File

D) Fourth Normal File

28. The full form of OLAP ?

A) Online Account Processing

B) Online Observation Processing

C) On All Processing

D) Online Analytical Processing

29. The Number of Attribute in a relational is called  its...

A) degree

B) points

C) Length

D) None of the above

30. Which language used to control privileges in database..

A) DML

B) DCL

C) DDL

D) TCL

So this is a simple Basic Database Management System Quiz . If you feel any question are wrong or not correct answer so please tell us by comment. Help your friends by sharing this post.