Explore topic-wise MCQs in Database.

This section includes 4 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.

1.

In domain relaional calculus there exist can be expressed as

A. (P1(x))
B. (P1(x)) x
C. V x (P1(x))
D. x (P1(x))
Answer» E.
Discussion
2.

An expression in the domain relational calculus is of the form

A. {P(x1, x2, . . . , xn) | < x1, x2, . . . , xn > }
B. {x1, x2, . . . , xn | < x1, x2, . . . , xn > }
C. { x1, x2, . . . , xn | x1, x2, . . . , xn}
D. {< x1, x2, . . . , xn > | P(x1, x2, . . . , xn)}
Answer» E.
Discussion
3.

Find all students who have taken all courses offered in the Biology department. The expressions that matches this sentence is :

A. t r (Q(t))
B. t r (Q(t))
C. t r (Q(t))
D. ~ t r (Q(t))
Answer» C. t r (Q(t))
Discussion
4.

Find the ID, name, dept name, salary for instructors whose salary is greater than $80,000 .

A. {t | t instructor t[salary] > 80000}
B. t r (Q(t))
C. {t | s instructor (t[ID] = s[ID] s[salary] > 80000)}
D. None of the mentioned
Answer» B. t r (Q(t))
Discussion