1) Consider the following two relations R (A, B) and S (A,C)
R S
A B
10 20
20 30
30 40
30 50
50 95
A C
10 90
30 45
40 80
The total number of tuples obtained by evaluating the following expression
is
(A) 2
(B) 4
(C) 3
(D) 5
2) Let S be the specification: "Instructors teach courses. Students register for courses. Courses
are allocated classrooms. Instructors guide students." Which one of the following ER diagrams
CORRECTLY represents S?
(A) i
(B) ii
(C) iii
(D) iv
3) Which of the following statements about a relation R in first normal form (1NF) is/are
TRUE?
(A) R can have a multi-attribute key
(B) R cannot have a foreign key
(C) R cannot have a composite attribute
(D) R cannot have more than one candidate key
4) Consider the following table named Student in a relational database. The primary key of this
table is rollNum.
The SQL query below is executed on this database.
SELECT *
FROM Student
WHERE gender = ‘F’ AND
marks > 65;
The number of rows returned by the query is __________.
(A) 3
(B) 4
(C) 2
(D) 1
5) Which one of the options given below refers to the degree (or arity) of a relation in relational
database systems?
(A) Number of attributes of its relation schema.
(B) Number of tuples stored in the relation.
(C) Number of entries in the relation.
(D) Number of distinct domains of its relation schema.
6) Which one of the following is used to represent the supporting many-one relationships of a
weak entity set in an entity-relationship diagram ?
(A) Diamonds with double/bold border
(B) Rectangles with double/bold border
(C) Ovals with double/bold border
(D) Ovals that contain underlined identifiers
7) Which of the following statements are TRUE about an SQL query?
P: An SQL query can contain a HAVING clause even if it does not a GROUP BY clause
Q: An SQL query can contain a HAVING clause only if it has a GROUP BY clause
R: All attributes used in the GROUP BY clause must appear in the SELECT clause
S: Not all attributes used in the GROUP BY clause need to appear in the SELECT clause
(A) P and R
(B) P and S
(C) Q and R
(D) Q and S
8) Suppose (A, B) and (C,D) are two relation schemas. Let r1 and r2 be the corresponding
relation instances. B is a foreign key that refers to C in r2. If data in r1 and r2 satisfy referential
integrity constraints, which of the following is ALWAYS TRUE?
ANS :A
9) Which of the following is TRUE?
(A) Every relation in 2NF is also in BCNF
(B) A relation R is in 3NF if every non-prime attribute of R is fully functionally
dependent on every key of R
(C) Every relation in BCNF is also in 3NF
(D) No relation can be in both BCNF and 3NF
10) Once the DBMS informs the user that a transaction has been successfully completed, its
effect should persist even if the system crashes before all its changes are reflected on disk. This
property is called
(A) Durability
(B) Atomicity
(C) Consistency
(D) Isolation
11) In the context of owner and weak entity sets in the ER(Entity-Relationship) data model,
which one of the following statements is TRUE?
(A) The weak entity set MUST have total participation in the identifying relationship
(B) The owner entity set MUST have total participation in the identifying relationship
(C) Both weak and owner entity sets MUST have total participation in the identifying
relationship
(D) Neither weak and owner entity sets MUST have total participation in the identifying
relationship
12) Consider the given ER Diagram
To convert this ER Diagram in to Relation or Table what is the minimum number of tables
required?
(A) 1
(B) 2
(C) 3
(D) 4
13) Information about a collection of students is given by the relation studinfo (studId, name,
sex). The relation enrol (studId, courseId) gives which student has enrolled for (or taken) that
course(s). Assume that every course is taken by at least one male and at least one female student.
What does the following relational algebra expression represent?
(A) Courses in which all the female students are enrolled.
(B) Courses in which a proper subset of female students are enrolled.
(C) Courses in which only male students are enrolled.
(D) None of the above.
14) Which of the following statements is TRUE regarding superkeys and candidate keys in a
relational database?
(A) Every superkey is a candidate key
(B) Every candidate key is a superkey
(C) Every primary key is not a candidate key
(D) A foreign key is always a candidate key
15) A foreign key in a relational database:
(A) Can be NULL
(B) Must be a candidate key in the same table
(C) Cannot reference a primary key in another table
(D) Must have a UNIQUE constraint
Answers:
1) (A) 2
[GATE 2024]
2) [GATE 2024]
3) Option (A) and (C) [GATE 2024]
4) (C) 2 [GATE 2023]
5) (A) Number of attributes of its relation schema [GATE 2023]
6) (A) Diamonds with double/bold border [GATE-2020]
7) (C) Q and R [GATE 2024]
8) (A) [GATE 2019]
9) (C) Every relation in BCNF is also in 3NF [GATE 2019]
10) (A) Durability [GATE 2024]
11) (A) The weak entity set MUST have total participation in the identifying relationship
[GATE 2024]
12) (C)3 [GATE 2024]
13) (B)Courses in which a proper subset of female students are enrolled. [GATE 2017]
14) (B) Every candidate key is a super key [GATE 2021]
15) (A) Can be NULL [GATE 2018]
