Explore topic-wise MCQs in Database.

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

1.

The collections on which aggregate functions can operate are called as __________

A. Multisets
B. Multivalues
C. Multicollections
D. Multivariables
Answer» B. Multivalues
Discussion
2.

State true or false: There exists a division operator in Relational Algebra

A. True
B. False
Answer» B. False
Discussion
3.

Updating, Deleting and Inserting in relational algebra is done using the ________ operator

A. Assignment
B. Modification
C. Alteration
D. Inclusion
Answer» B. Modification
Discussion
4.

Πcustomer_name, loan_number, amount (borrower ⋈loan)What does the above expression perform?

A. It finds the customer_name, loan_number and amount from borrower
B. It finds the customer_name, loan_number and amount from loan
C. It finds the customer_name, loan_number and amount from the full outer join of borrower and loan
D. It finds the customer_name, loan_number and amount from the natural join of borrower and loan
Answer» E.
Discussion
5.

What does the following relational algebra expression do?σamount > 1200 (loan)

A. Finds all the tuples in loan
B. Finds the tuples in loan where the amount is greater than 12000
C. Finds all the tuples in loan where the amount is greater than 1200
D. Finds all the amounts in loan where the number of values is greater than 1200
Answer» D. Finds all the amounts in loan where the number of values is greater than 1200
Discussion
6.

What does the following relational operation perform?ρx(A1,A2,A3…) (E)

A. It returns the result of expression E with the previous attribute names
B. It returns the result of expression E renaming the attributes as A1, A2, …
C. It returns the result of the relation E but saves the old attributes
D. None of the mentioned
Answer» C. It returns the result of the relation E but saves the old attributes
Discussion
7.

The project operation’s function in relational algebra is identical to the _______ clause in SQL

A. where
B. from
C. select
D. none of the mentioned
Answer» D. none of the mentioned
Discussion
8.

The select operation’s function in relational algebra is identical to the _______ clause in SQL

A. where
B. from
C. select
D. none of the mentioned
Answer» B. from
Discussion
9.

Which of the following is not a relational algebra function?

A. Select
B. Project
C. Manipulate
D. Union
Answer» D. Union
Discussion
10.

UPDATING,_DELETING_AND_INSERTING_IN_RELATIONAL_ALGEBRA_IS_DONE_USING_THE__________OPERATOR?$

A. Assignment
B. Modification
C. Alteration
D. Inclusion
Answer» B. Modification
Discussion
11.

WHICH_OF_THE_FOLLOWING_IS_NOT_OUTER_JOIN??$

A. Left outer join
B. Right outer join
C. Full outer join
D. All of the mentioned
Answer» E.
Discussion
12.

The collections on which aggregate functions can operate are called as __________$

A. Multisets
B. Multivalues
C. Multicollections
D. Multivariables
Answer» B. Multivalues
Discussion
13.

State true or false: There exists a division operator in Relational Algebra$

A. True
B. False
Answer» B. False
Discussion
14.

The assignment operator is denoted by$

A. ->
B. <-
C. =
D. ==
Answer» C. =
Discussion
15.

In precedence of set operators, the expression is evaluated fro?

A. Left to left
B. Left to right
C. Right to left
D. From user specification
Answer» C. Right to left
Discussion
16.

How is the right outer join symbol represented in relational algebra?

A. ‚üï
B. ‚üñ
C. ‚üó
D. ‚ãà
Answer» C. ‚Äö√Ñ√∂‚àö¬∫‚àö‚â•
Discussion
17.

How is the left outer join symbol represented in relational algebra?

A. ‚üï
B. ‚üñ
C. ‚üó
D. ‚ãà
Answer» B. ‚Äö√Ñ√∂‚àö¬∫‚àö¬±
Discussion
18.

Which is a unary operation:

A. Selection operation
B. Primitive operation
C. Projection operation
D. Generalized selection
Answer» E.
Discussion
19.

What does the following relational algebra expression do?

A.
B. Finds all the tuples in loan
C. Finds the tuples in loan where the amount is greater than 12000
D. Finds all the tuples in loan where the amount is greater than 1200
Answer» D. Finds all the tuples in loan where the amount is greater than 1200
Discussion
20.

The ___________ operation, denoted by ‚àí, allows us to find tuples that are in one relation but are not in another.$

A. Union
B. Set-difference
C. Difference
D. Intersection
Answer» C. Difference
Discussion
21.

What does the following relational operation perform?

A. (E)
B. It returns the result of expression E with the previous attribute names
C. It returns the result of expression E renaming the attributes as A1, A2, …
D. It returns the result of the relation E but saves the old attributes
Answer» C. It returns the result of expression E renaming the attributes as A1, A2, ‚Äö√Ñ√∂‚àö√묨‚àÇ
Discussion
22.

For select operation the ________ appear in the subscript and the ___________ argument appears in the paranthesis after the sigma.

A. Predicates, relation
B. Relation, Predicates
C. Operation, Predicates
D. Relation, Operation
Answer» B. Relation, Predicates
Discussion
23.

Which of the following is used to denote the selection operation in relational algebra?

A. Pi (Greek)
B. Sigma (Greek)
C. Lambda (Greek)
D. Omega (Greek)
Answer» C. Lambda (Greek)
Discussion
24.

The select operation’s function in relational algebra is identical to the _______ clause in SQL$

A. where
B. from
C. select
D. none of the mentioned
Answer» B. from
Discussion
25.

Which of the following is a fundamental operation in relational algebra?

A. Set intersection
B. Natural join
C. Assignment
D. None of the mentioned
Answer» E.
Discussion
26.

Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.

A. Relational
B. Structural
C. Procedural
D. Fundamental
Answer» D. Fundamental
Discussion