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 : 36
What is the result of the following SQL statement ?
SELECT A.emp_Name, B.ph_num
FROM emp A LEFT OUTER JOIN phone B
ON A. emp_ID = B.emp_ID

A list of employees phone number
A list of all employees that have spouses, with phone number included in the list
A list of all employees names, including the phone number if they have one
Two lists : One list of employees, the other of phone numbers
View Answer   Discuss

Question No : 37
The ability to modify the conceptual schema without causing any change to the application program is known as

Physical data independence
Logical data independence
External data independence
Static data
View Answer   Discuss

Question No : 38
What does a field or a combination of fields that has a unique value called ?

Foreign key
Secondary key
Primary key
Alternate key
View Answer   Discuss

Question No : 39
Referential integrity

controls relationships between operations of an object
controls relationships between instances of a class
controls relationships between attributes in a table
controls relationships between tables in a database
View Answer   Discuss

Question No : 40
In which of the following SET concept is used ?

Network Model
Hierarchical Model
Relational Model
None of these
View Answer   Discuss

Question No : 41
Which of the following operator preserves unmatched rows of the relations being joined?

Inner join
Outer join
union
Intersect
View Answer   Discuss

Question No : 42
Which of the following normalization is needed, if an attribute of a composite key is dependent on an attribute of the other composite key?

BCNF
Second
Third
Fourth
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