Introduction to Database Systems Week 4 Quiz Answers Nptel
Are you looking for NPTEL Introduction to Database Systems Week 4 Quiz Answers? You’ve come to the right place! Access the most accurate answers at Progiez.
Table of Contents
Introduction to Database Systems Week 4 Quiz Answers (Jan-Apr 2025)
Course Link: Click Here
Q1. Which of the following relational query languages have the same expressive power?
a) II and III only
b) I and II only
c) I and III only
d) I, II and III
Q2. What is the relational algebra expression equivalent to the following tuple relational calculus expression, where r is a relation name?
{ t | r(t) ⋀ ( t.A = 10 ⋀ t.B = 20) }
a) σ(A=10⋁B=20)(r)
b) σ(A=10)(r)∪σ(B=20)(r)
c) σ(A=10)(r)∩σ(B=20)(r)
d) σ(A=10)(r)ーσ(B=20)(r)
Q3. Consider the following two statements and choose the correct option:
S1: Each record of the referencing relation can relate to at most one record of the referenced relation.
S2: Each record of the referenced relation can relate to at most one record of the referencing relation.
a) S1 is true, S2 is true
b) S1 is false, S2 is true
c) S1 is false, S2 is false
d) S1 is true, S2 is false
Q4. Given the following relational schema:
Employee( EmpID, EmpName, Salary, Age, Address, Department, HireDate)
Which of the following TRC query retrieves employee IDs where the employee’s salary is greater than ₹ 60,000, the employee’s age is less than 40, the employee’s department is either “IT” or “Marketing”, and the employee’s hire date is after January 1st, 2020?
Q5. There are two weak entities E1 and E2, where E1 is the owner entity for E2.
Consider relational representation of E1 and E2 and choose the correct option:
a) Mapping of E1 should be done before E2
b) Mapping of E2 should be done before E1
c) E1 and E2 can be mapped in any order
d) Partial key of E1 includes the partial key of E2
Q6. Consider the relation
employee( name, sex, supervisorName )
The attribute supervisorName gives the name of the supervisor of the employee under consideration. What does the following Tuple Relational Calculus (TRC) query produce?
Q7. Given the following relational schemas:
- Student (rollNo, name, age, sex, deptNo, advisor)
- Department (deptId, dName, hod, phoneNo)
Which of the following will be the TRC query to obtain the department names that do not have any girl students?
Q8. Consider the relations S1( A, B, C ) and S2( C, D, E ) with primary keys A and C, respectively. The relation S1 contains 2000 tuples and S2 contains 2500 tuples.
The maximum size of the join S1 ⋈ S1.C = S2.C S2 is:
a) 2000
b) 2500
c) 4500
d) 5000
Q9. Consider the following relational schema where rollNo and courseId are foreign keys in Enrollment referring to rollNo in Student and courseId in Courses, respectively:
- Student( rollNo, name, degree, year, sex, deptNo, advisor )
- Courses( courseId, cname, credits, deptNo )
- Enrollment( rollNo, courseId, sem, year, grade )
Consider the TRC query given below:
{ s.rollNo, s.name | Student(s) ∧ (∃e1)( Enrollment(e1) ∧ (e1.rollNo = s.rollNo)) }
Which one of the following is the correct interpretation of the above query?
a) Retrieve rollNo and name of students who have enrolled for exactly one course
b) Retrieve rollNo and name of students who have enrolled for more than one course
c) Retrieve rollNo and name of students who have enrolled for at least one course
d) Retrieve rollNo and name of students who have all enrolled for the same course
Q10. Consider the statements given below:
- P: Tuple Relational Calculus (TRC) is a non-procedural query language
- Q: Tuple Relational Calculus (TRC) expression specifies what is to be retrieved rather than how to retrieve it
Choose the correct option:
a) P is true and Q is false
b) Both P and Q are true, and Q is the correct reason for P
c) Both P and Q are true, and Q is not the correct reason for P
d) Both P and Q are false
Introduction to Database Systems Week 4 Quiz Answers
For answers to others Nptel courses, please refer to this link: NPTEL Assignment
