Data Base Management System MCQs SET-1

Hey Guys Welcome CSE Study247

This page provide you Data Base Management System MCQs SET-1 ,which is very useful of many exam like Semester, DRDO, ISRO, Railway, Banking , Gate Etc.

 

Q.1 When a primary key is defined in the table DBMS automatically creates a ———-on a primary key column ?





ANSWER= (A) Unique Index

 

Q.2 Which normal form is the particular dependency removed?





ANSWER=(B)Second

 

Q.3 Which is major data structure used in RDBMS?





ANSWER=(A)Array

 

Q.4 The view of total database content is:





ANSWER=(A) Conceptual view

 

Q.5 Which is not aggregate function?





ANSWER=(C) Create

 

Q.6 Under which category do the commands CREATE and ALTER belong to ?





ANSWER=(B)DDL

 

Q.7 ACID stands for? ?





ANSWER=(B)Atomicity, consistency, isolation Durability

 

Q.8 How many primary key can a table in database?





ANSWER=(A)Only one

 

Q.9 Which of the following are the properties of entities?





ANSWER=(C)Attributes

 

Q.10 Relational algebra is?





ANSWER=(C)Procedural Query Language

 

Q.11 The statement in SQL which allows to change definition of table is?





ANSWER=(A)Alter

 

Q.12 Count function in SQL returns the number of?





ANSWER=(A) Values

 

Q.13 In an E-R diagram Entity set is represented by?





ANSWER=(C)Rectangle

 

Q.14 The language used in application program to request data from DBMS is referred as:





ANSWER=(A)DML

 

Q.15 The number of attributes in a relation is called its———





ANSWER=(C)Degree

 

Q.16 Which of the following is not a type of Database?





ANSWER=(D)Transition

 

Q.17 SELECT * from employee is what type of statement?





ANSWER=(A) DML

 

Q.18 The full form of DDL is:





ANSWER=(C)Data Definition Language

 

Q.19 Which database is closest to the users?





ANSWER=(A)External

 

Q.20 Which of the following is comparison operator in SQL?





ANSWER=(D)All of the above

1. Official Telegram Click Here
2. Telegram For CSE MCQs Click Here
3. You TubeClick Here