cs2001_2024T3_Q1_AN.pdf
Database Management System · Quiz 1 · Sep 2024
← Course papers · Start practice / exam
Questions and published explanations below are available without starting a test. Some questions may not have a published solution yet.
Question 83 NAT · 3.0 marks
[[IMAGE:cc250ede1193d61d_1_0]]

A published solution is not available for this question yet.
Question 84 NAT · 3.0 marks
[[IMAGE:cc250ede1193d61d_1_1]]

A published solution is not available for this question yet.
Question 86 MCQ · 2.0 marks
Which of the following is the correct sequence for query processing?
Query → Parser and Translator → Evaluation Engine → Optimizer → Query
Output
Query → Optimizer → Evaluation Engine → Parser and Translator → Query
Output
Query → Parser and Translator → Optimizer → Evaluation Engine → Query
Output
Query → Evaluation Engine → Parser and Translator → Optimizer → Query
Output
A published solution is not available for this question yet.
Question 87 MCQ · 2.0 marks
[[IMAGE:cc250ede1193d61d_3_2]]

1-A, 2-B, 3-C
1-B, 2-A, 3-C
1-B, 2-C, 3-A
1-C, 2-A, 3-B
A published solution is not available for this question yet.
Question 88 MCQ · 4.0 marks
[[IMAGE:cc250ede1193d61d_3_3]]

4 rows and 6 columns
2 rows and 5 columns
4 rows and 5 columns
2 rows and 6 columns
A published solution is not available for this question yet.
Question 89 MCQ · 4.0 marks
[[IMAGE:cc250ede1193d61d_4_4]]

Names of the students with the first four highest marks
Name of the student with the 4th highest mark
Names of the students with the first three highest marks
Name of the student with the 3rd highest mark
A published solution is not available for this question yet.
Question 90 MCQ · 4.0 marks
[[IMAGE:cc250ede1193d61d_5_5]]

Q1 is correct but Q2 is wrong
Q2 is correct but Q1 is wrong
Both Q1 and Q2 are wrong
Both Q1 and Q2 are correct
A published solution is not available for this question yet.
Question 91 MSQ · 4.0 marks
Consider the following Entity Relationship Diagram:
[[IMAGE:cc250ede1193d61d_6_6]]
Choose the correct statements.

An employee can work on more than one project.
A project can have employees from more than one department, working on it.
A dependent, who is not dependent on any employee, can exist.
Every department must have at least one employee working in it.
A published solution is not available for this question yet.
Question 92 MSQ · 4.0 marks
[[IMAGE:cc250ede1193d61d_6_7]]

[[IMAGE:cc250ede1193d61d_7_8]]

[[IMAGE:cc250ede1193d61d_7_9]]

[[IMAGE:cc250ede1193d61d_7_10]]

[[IMAGE:cc250ede1193d61d_7_11]]

A published solution is not available for this question yet.
Question 93 NAT · 4.0 marks
[[IMAGE:cc250ede1193d61d_8_12]]

A published solution is not available for this question yet.
Question 94 NAT · 3.0 marks
[[IMAGE:cc250ede1193d61d_9_13]]

A published solution is not available for this question yet.
Question 95 MSQ · 4.0 marks
Consider the following relational schema and answer the given subquestions.
[[IMAGE:cc250ede1193d61d_9_14]]
[[IMAGE:cc250ede1193d61d_10_15]]


1-a, 2-d, 3-f
1-b, 2-c, 3-e
1-a, 2-d, 3-e
1-a, 2-e, 3-f
A published solution is not available for this question yet.
Question 96 MCQ · 4.0 marks
Consider the following relational schema and answer the given subquestions.
[[IMAGE:cc250ede1193d61d_9_14]]
[[IMAGE:cc250ede1193d61d_10_16]]


First names of players who are in either the Warriors or the Lakers team
First names of players who are in both the Warriors and the Lakers teams
Unique First names of players who are in both the Warriors and the Lakers
teams
Unique First names of players who are either in the Warriors team or in the
Lakers team
A published solution is not available for this question yet.
Question 97 MCQ · 3.0 marks
[[IMAGE:cc250ede1193d61d_11_17]]
[[IMAGE:cc250ede1193d61d_11_18]]


7
5
9
8
A published solution is not available for this question yet.
Question 98 MSQ · 4.0 marks
[[IMAGE:cc250ede1193d61d_11_17]]
[[IMAGE:cc250ede1193d61d_12_19]]


[[IMAGE:cc250ede1193d61d_12_20]]

[[IMAGE:cc250ede1193d61d_12_21]]

[[IMAGE:cc250ede1193d61d_12_22]]

[[IMAGE:cc250ede1193d61d_12_23]]

A published solution is not available for this question yet.
Question 99 MCQ · 4.0 marks
[[IMAGE:cc250ede1193d61d_11_17]]
[[IMAGE:cc250ede1193d61d_13_24]]


[[IMAGE:cc250ede1193d61d_13_25]]

[[IMAGE:cc250ede1193d61d_13_26]]

[[IMAGE:cc250ede1193d61d_13_27]]

[[IMAGE:cc250ede1193d61d_13_28]]
**AppDev1**
**Section Id :** 64065369406
**Section Number :** 7
**Section type :** Online
**Mandatory or Optional :** Mandatory
**Number of Questions :** 16
**Number of Questions to be attempted :** 16
**Section Marks :** 50
**Display Number Panel :** Yes
**Section Negative Marks :** 0
**Group All Questions :** No
**Enable Mark as Answered Mark for Review and**
No
**Clear Response :**
**Section Maximum Duration :** 0
**Section Minimum Duration :** 0
**Section Time In :** Minutes

A published solution is not available for this question yet.