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 : 22
______ keyword is used to find the number of values in a column.

TOTAL
ADD
COUNT
SUM
View Answer   Discuss

Question No : 23
______contains information that defines valid values that are stored in a column or data type.

Default
Index
Rule
View
View Answer   Discuss

Question No : 24
An advantage of the database management approach is

data redundancy increases
data is dependent on programs
data is integrated and can be accessed by multiple programs
none of the above
View Answer   Discuss

Question No : 25
Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values

i-only
ii-only
Both of them
None of them
View Answer   Discuss

Question No : 26
The collection of information stored in a database at a particular moment is called as ......

schema
instance of the database
data domain
independence
View Answer   Discuss

Question No : 27
_____ First proposed the process of normalization.

Edgar. W
Edward Stephen
Edgar F. Codd
Edward Codd
View Answer   Discuss

Question No : 28
Data independence means

data is defined separately and not included in programs.
programs are not dependent on the physical attributes of data
programs are not dependent on the logical attributes of data
both B and C
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