Home
Home >> Computer>> Advance DBMS

Advance DBMS MCQ Question with Answer

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

Download Advance DBMS MCQ Question Answer PDF

Try Advance DBMS Mock Test

Question No : 43
The syntax to select all column from the table is

select all from tablename
select * from tablename
select from tablename
none of these
View Answer   Discuss

Question No : 44
When all attributes in a relation tuple are not functionally dependent only on the key attribute. Which of the following normalization is needed?

first
second
third
fourth
View Answer   Discuss

Question No : 45
In RDBMS, Data is presented as a collection of

Relation
Table
Attribute
Entity
View Answer   Discuss

Question No : 46
A composite attribute is converted to individual attributes in which of the following normal form ?

first
Second
third
fourth
View Answer   Discuss

Question No : 47
DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions

Backup
Recovery
Grant
Troubleshooting
View Answer   Discuss

Question No : 48
What does the number of attributes in a relation is called?

Cardinality
Degree
Tuple
Order
View Answer   Discuss

Question No : 49
By default a user who has been granted some form of authorization

is allowed to pass them to others
is not allowed to pass them to others
may be or may not be allowed to pass them to others
none
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