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 ?
A) Unique Index
B) Sequence
C)Trigger
D) Synonym
ANSWER= (A) Unique Index
Check Answer
Q.2 Which normal form is the particular dependency removed?
A) First
B) second
C) Third
D) BCNF
ANSWER=(B)Second
Check Answer
Q.3 Which is major data structure used in RDBMS?
A)Stacks
B) Graph
C) Array
D) none
ANSWER=(A)Array
Check Answer
Q.4 The view of total database content is:
A) Conceptual view
B) Internal view
C) External view
D) Physical view
ANSWER=(A) Conceptual view
Check Answer
Q.5 Which is not aggregate function?
A) Count
B) Avg
C) Create
D) Max
ANSWER=(C) Create
Check Answer
Q.6 Under which category do the commands CREATE and ALTER belong to ?
A) DML
B) DDL
C) Create
D) None of the above
ANSWER=(B)DDL
Check Answer
Q.7 ACID stands for? ?
A) Atomicity, Consistency, Isolation, Durability
B) Atomicity, Concurrency, Isolation, Durability
C) Aggregation, Consistency, Isolation, Durability
D) None of the above
ANSWER=(B)Atomicity, consistency, isolation Durability
Check Answer
Q.8 How many primary key can a table in database?
A) Only one
B) At least one
C) More than one
D) Any number of
ANSWER=(A)Only one
Check Answer
Q.9 Which of the following are the properties of entities?
A) Groups
B) Table
C) Attributes
D) None of the above
ANSWER=(C)Attributes
Check Answer
Q.10 Relational algebra is?
A) DDL
B) Meta Language
C) Procedural Query Language
D) None of the above
ANSWER=(C)Procedural Query Language
Check Answer
Q.11 The statement in SQL which allows to change definition of table is?
A) Alter
B) Update
C) Create
D)Select
ANSWER=(A)Alter
Check Answer
Q.12 Count function in SQL returns the number of?
A) Values
B)District Values
C) Groups
D) Columns
ANSWER=(A) Values
Check Answer
Q.13 In an E-R diagram Entity set is represented by?
A) Ellipse
B)Square
C) Rectangle
D)None of the above
ANSWER=(C)Rectangle
Check Answer
Q.14 The language used in application program to request data from DBMS is referred as:
ANSWER=(A)DML
Check Answer
Q.15 The number of attributes in a relation is called its———
A)Row
B)Column
C) Degree
D)None of the above
ANSWER=(C)Degree
Check Answer
Q.16 Which of the following is not a type of Database?
A) Hierarchical
B) Relational
C) Network
D)Transition
ANSWER=(D)Transition
Check Answer
Q.17 SELECT * from employee is what type of statement?
A) DML
B) DDL
C) View
D)Integrity Constraint
ANSWER=(A) DML
Check Answer
Q.18 The full form of DDL is:
A) Dynamic Data Language
B) Detailed Data Language
C) Data Definition Language
D)None of the above
ANSWER=(C)Data Definition Language
Check Answer
Q.19 Which database is closest to the users?
A) External
B) Internal
C) Physical
D)Conceptual
ANSWER=(A)External
Check Answer
Q.20 Which of the following is comparison operator in SQL?
A) =
B) LIKE
C) BETWEEN
D)All of the above
ANSWER=(D)All of the above
Check Answer
1. Official Telegram Click Here 2. Telegram For CSE MCQs Click Here 3. You Tube Click Here