Home
Home >> Computer>> DBMS

DBMS MCQ Question with Answer

DBMS MCQ with detailed explanation for interview, entrance and competitive exams. Explanation are given for understanding.

Download DBMS MCQ Question Answer PDF

Try DBMS Mock Test

Question No : 36
DBMS helps achieve

Centralized control of data
Data independence
Both A and B
Neither A nor B
View Answer   Discuss

Question No : 37
____specifies a search condition for a group or an aggregate.

GROUP BY Clause
HAVING Clause
FROM Clause
WHERE Clause
View Answer   Discuss

Question No : 38
_____ command can be used to modify a column in a table

alter
update
set
create
View Answer   Discuss

Question No : 39
Drop Table cannot be used to drop a table referenced by a ______ constraint.

Primary Key
Local Key
Foreign Key
Composite Key
View Answer   Discuss

Question No : 40
The _______ is a set of programs to use and / or modify this data.

DBMS
System
Program
Software
View Answer   Discuss

Question No : 41
The ______ indexes are forced to store only record IDs in the data structure and require at least one additional I/O Operation to retrieve the actual record.

Clustered
Hashed
Un-clustered
Collision
View Answer   Discuss

Question No : 42
The set of all values that can be taken by the attribute is called as _______ of the attribute.

Tuple
Cardinality
Degree
Domain
View Answer   Discuss

Wanna test your skill? Here are some exams we prepared for you. So if you need to test your skill just attempt any exam from bellow.

Exam Name No. Of Q Link
Computer set 1 30 Start
Computer set 2 30 Start
Computer set 3 30 Start
Computer set 4 30 Start
Computer set 5 30 Start
Computer set 6 30 Start
Computer set 7 30 Start
Computer set 8 30 Start
Computer set 9 30 Start
Computer set 10 30 Start
Computer set 11 30 Start
Computer set 12 30 Start