cs2001_2024T2_Q1_AN.pdf

Database Management System · Quiz 1 · May 2024

Questions and published explanations below are available without starting a test. Some questions may not have a published solution yet.

Question 2 MCQ · 3.0 marks

Consider the table **Champions_League** for given subquestions [[IMAGE:e25818efe33f6a04_2_0]]

[[IMAGE:e25818efe33f6a04_3_1]]

[[IMAGE:e25818efe33f6a04_3_2]]
[[IMAGE:e25818efe33f6a04_3_3]]
[[IMAGE:e25818efe33f6a04_3_4]]
[[IMAGE:e25818efe33f6a04_3_5]]

A published solution is not available for this question yet.

Question 3 NAT · 4.0 marks

Consider the table **Champions_League** for given subquestions [[IMAGE:e25818efe33f6a04_2_0]]

[[IMAGE:e25818efe33f6a04_3_6]]

A published solution is not available for this question yet.

Question 4 MCQ · 3.0 marks

[[IMAGE:e25818efe33f6a04_4_7]]

[[IMAGE:e25818efe33f6a04_4_8]]
[[IMAGE:e25818efe33f6a04_4_9]]
[[IMAGE:e25818efe33f6a04_4_10]]
[[IMAGE:e25818efe33f6a04_4_11]]

A published solution is not available for this question yet.

Question 5 MCQ · 3.0 marks

[[IMAGE:e25818efe33f6a04_5_12]]

[[IMAGE:e25818efe33f6a04_5_13]]
[[IMAGE:e25818efe33f6a04_5_14]]
[[IMAGE:e25818efe33f6a04_5_15]]
[[IMAGE:e25818efe33f6a04_5_16]]

A published solution is not available for this question yet.

Question 6 MSQ · 3.0 marks

[[IMAGE:e25818efe33f6a04_5_17]]

1002
101020
10200
10022

A published solution is not available for this question yet.

Question 7 MSQ · 3.0 marks

[[IMAGE:e25818efe33f6a04_6_18]]

[[IMAGE:e25818efe33f6a04_6_19]]
[[IMAGE:e25818efe33f6a04_6_20]]
[[IMAGE:e25818efe33f6a04_6_21]]
[[IMAGE:e25818efe33f6a04_6_22]]

A published solution is not available for this question yet.

Question 8 MCQ · 4.0 marks

Consider the following data for given subquestions: [[IMAGE:e25818efe33f6a04_7_23]]

[[IMAGE:e25818efe33f6a04_7_24]]

Distinct names of all such teams that have no driver with salary higher than 2000000
Distinct names of all such teams that have all drivers with salary higher than 2000000
Distinct names of all such teams that have at least one driver with salary higher than 2000000
Distinct names of all such teams that have exactly one driver with salary higher than 2000000

A published solution is not available for this question yet.

Question 9 NAT · 4.0 marks

Consider the following data for given subquestions: [[IMAGE:e25818efe33f6a04_7_23]]

[[IMAGE:e25818efe33f6a04_8_25]]

A published solution is not available for this question yet.

Question 10 MSQ · 2.0 marks

Which of the following statement(s) is/are correct?

All candidate keys are primary keys
A primary key is also a candidate key
A primary key consists of exactly one attribute
A candidate key is a minimal super key

A published solution is not available for this question yet.

Question 11 MCQ · 3.0 marks

Consider the E-R diagram given in Figure 1 and answer the subquestions. [[IMAGE:e25818efe33f6a04_9_26]]

Identify the correct relational schema for the relationship set **enrolls**. Note: The primary key is underlined.

[[IMAGE:e25818efe33f6a04_9_27]]
[[IMAGE:e25818efe33f6a04_9_28]]
[[IMAGE:e25818efe33f6a04_9_29]]
[[IMAGE:e25818efe33f6a04_9_30]]

A published solution is not available for this question yet.

Question 12 MCQ · 3.0 marks

Consider the E-R diagram given in Figure 1 and answer the subquestions. [[IMAGE:e25818efe33f6a04_9_26]]

Identify the correct relational schema for the entity set **Assignment**. Note: The primary key is underlined.

[[IMAGE:e25818efe33f6a04_9_31]]
[[IMAGE:e25818efe33f6a04_10_32]]
[[IMAGE:e25818efe33f6a04_10_33]]
[[IMAGE:e25818efe33f6a04_10_34]]

A published solution is not available for this question yet.

Question 13 MSQ · 3.0 marks

Consider the E-R diagram given in Figure 1 and answer the subquestions. [[IMAGE:e25818efe33f6a04_9_26]]

[[IMAGE:e25818efe33f6a04_10_35]]

Each course must have at least one student.
Each student must have enrolled for at least one course.
Some courses may have no students.
A student may enroll for many courses.

A published solution is not available for this question yet.

Question 14 MSQ · 4.0 marks

[[IMAGE:e25818efe33f6a04_11_36]]

[[IMAGE:e25818efe33f6a04_11_37]]
[[IMAGE:e25818efe33f6a04_11_38]]
[[IMAGE:e25818efe33f6a04_11_39]]
[[IMAGE:e25818efe33f6a04_11_40]]

A published solution is not available for this question yet.

Question 15 MSQ · 4.0 marks

[[IMAGE:e25818efe33f6a04_11_41]]

[[IMAGE:e25818efe33f6a04_11_42]]
[[IMAGE:e25818efe33f6a04_12_43]]
[[IMAGE:e25818efe33f6a04_12_44]]
[[IMAGE:e25818efe33f6a04_12_45]]

A published solution is not available for this question yet.

Question 16 MCQ · 4.0 marks

[[IMAGE:e25818efe33f6a04_12_46]]

(2,2,5) and (3,1,5)
(5,2,4), (1,1,5), (2,2,5) and (3,1,5)
(6,1,1),(7,4,1) and (8,4,7)
All the remaining rows will be deleted **PDSA** **Section Id :** 64065359209 **Section Number :** 2 **Section type :** Online

A published solution is not available for this question yet.