Hey Guys Welcome CSE Study247
This page provide you Data Base Management System MCQs SET-2 , which is very useful of many exam like Semester, DRDO, ISRO, Railway, Banking , Gate Etc.
Q.21 Which is not the relational Algebra Operation
A) Set Difference
B) Cartesian product C) Rename D) Join
ANSWER= (A) Set Difference
Check Answer
Q.22 How is specialization denoted in ER diagram?
A) Triangle labeled IS A
B) Rectangle labeled IS A C) Rectangle labeled HAS A D) Triangle labeled HAS A
ANSWER= (D) Triangle labeled HAS A
Check Answer
Q.23 Which of the following is open source DBMS?
A) MySql
B) SQL server C) Microsoft Access D) Oracle
ANSWER= (A) MySql
Check Answer
Q.24 Which SQL keyword is used to remove the duplication of rows from the result set?
A) DELETE
B)SELECT C) DISTINCT D)UNIQUE
ANSWER= (C) DISTINCT
Check Answer
Q.25 What is the highest level in a hierarchy of data organization
A) Data record
B)Data field C) Data base
D)None of these
ANSWER= (C) Data base
Check Answer
Q.26 Which of the following is known as minimal super key?
A) Primary key
B)Foreign key C) Unique key
D) Candidate key
ANSWER= (D) Candidate key
Check Answer
Q.27 Which command allow the users to change multiple data fields?
A) Modify
B) Look up C) Update
D) Change
ANSWER= (C) Update
Check Answer
Q.28 Which of the following languages is used to define the integrity constraint?
A) DCL
B) DML
C) DDL
C) DDL
ANSWER= (C) Update
Check Answer
Q.29 In an ER diagram attributes are represented as:
A) Rectangle
B) Square
C) Ellipse
C) Ellipse
ANSWER= (C) Update
Check Answer
Q.30 Architecture of data base can be viewed as
A) Two levels
B) Four levels
C)Three-levels
D)One-level
ANSWER= (A) Two levels
Check Answer
Q.31 In relational model, relations are termed as?
A) Tuples
B) Attributes
C)Table
D) Row
ANSWER= (C) Table
Check Answer
Q.32 A Cartesian product in relational algebra in ?
A) Unary Operator
B) Binary operator
C)Ternary operator
D) None of these
ANSWER= (B) Binary operator
Check Answer
Q.33 SQL stands for ?
A) Structured Query Language
B) Sequential Query Language
C)Structured Question Language
D) None of these
ANSWER= (A)Structured Query Language
Check Answer
Q.34 The following are component of a data base except?
A) User data
B) Meta data
C)Reports
D)Indexes
ANSWER= (C)Reports
Check Answer
Q.35 A set of possible data values is?
A) Attribute
B) Degree
C) Turple
D) Domain
ANSWER= (D) Domain
Check Answer
Q.36 Which of the following data base objet does not physically exist?
A) Base table
B) Index
C) View
D) None of these
ANSWER= (C) View
Check Answer
Q.37 Cross product is a ?
A) Unary operator
B) Ternary operator
C) Binary operator
D) None of the above
ANSWER= (C)Binary operator
Check Answer
Q.38 In E-R diagram relationship is represented by?
A) Ellipse
B) Dashed line
C) Rectangle
D) Diamond
ANSWER= (D)Diamond
Check Answer
Q.39 To delete a particular column in a relation the command used is?
A) UPDATE
B) DROP
C)ALTER
D) DELETE
ANSWER= (D) DELETE
Check Answer
Q.40 A table joined with itself is called?
A) Join
B) Self join
C) Quter join
D) Equi join
ANSWER= (B) Self join
Check Answer
1. Official Telegram Click Here 2. Telegram For CSE MCQs Click Here 3. You Tube Click Here
