cs2001_2025T1_Q1_AN.pdf

Programming, Data Structures and Algorithms using Python(PDSA) · Quiz 1 · Jan 2025

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

Question 33 MCQ · 1.0 marks

[[IMAGE:5185c7098c73b2c9_1_0]]

[[IMAGE:5185c7098c73b2c9_1_1]]
[[IMAGE:5185c7098c73b2c9_1_2]]
[[IMAGE:5185c7098c73b2c9_1_3]]
[[IMAGE:5185c7098c73b2c9_1_4]] **DBMS** **Section Id :** 64065379120 **Section Number :** 3 **Section type :** Online **Mandatory or Optional :** Mandatory **Number of Questions :** 14 **Number of Questions to be attempted :** 14 **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 **Maximum Instruction Time :** 0

A published solution is not available for this question yet.

Question 35 MCQ · 2.0 marks

Which level of abstraction is responsible for providing data security by limiting access to specific data views?

Physical level
Logical level
View level
Physical level and Logical level

A published solution is not available for this question yet.

Question 36 MCQ · 3.0 marks

[[IMAGE:5185c7098c73b2c9_3_5]]

[[IMAGE:5185c7098c73b2c9_3_6]]
[[IMAGE:5185c7098c73b2c9_3_7]]
[[IMAGE:5185c7098c73b2c9_3_8]]
[[IMAGE:5185c7098c73b2c9_3_9]]

A published solution is not available for this question yet.

Question 37 MCQ · 4.0 marks

[[IMAGE:5185c7098c73b2c9_4_10]]

4 attributes and 9 rows
5 attributes and 8 rows
4 attributes and 8 rows
5 attributes and 9 rows

A published solution is not available for this question yet.

Question 38 MCQ · 4.0 marks

[[IMAGE:5185c7098c73b2c9_5_11]]

A published solution is not available for this question yet.

Question 39 MCQ · 4.0 marks

[[IMAGE:5185c7098c73b2c9_6_12]]

[[IMAGE:5185c7098c73b2c9_6_13]]
[[IMAGE:5185c7098c73b2c9_6_14]]
[[IMAGE:5185c7098c73b2c9_6_15]]
[[IMAGE:5185c7098c73b2c9_6_16]]

A published solution is not available for this question yet.

Question 40 MCQ · 4.0 marks

[[IMAGE:5185c7098c73b2c9_6_17]]

[[IMAGE:5185c7098c73b2c9_6_18]]
[[IMAGE:5185c7098c73b2c9_7_19]]
[[IMAGE:5185c7098c73b2c9_7_20]]
[[IMAGE:5185c7098c73b2c9_7_21]]

A published solution is not available for this question yet.

Question 41 MCQ · 4.0 marks

[[IMAGE:5185c7098c73b2c9_8_22]]

Names of all the drivers whose salary is greater than all Mercedes drivers but not less than all Ferrari drivers
Names of all the drivers whose salary is less than all Mercedes drivers but not greater than all Ferrari drivers
Names of all the drivers whose salary is greater than all Mercedes drivers as well as all Ferrari drivers
Names of all the drivers whose salary is less than all Mercedes drivers as well as all Ferrari drivers

A published solution is not available for this question yet.

Question 42 MSQ · 4.0 marks

[[IMAGE:5185c7098c73b2c9_9_23]]

[[IMAGE:5185c7098c73b2c9_9_24]]
[[IMAGE:5185c7098c73b2c9_9_25]]
[[IMAGE:5185c7098c73b2c9_9_26]]
[[IMAGE:5185c7098c73b2c9_9_27]]

A published solution is not available for this question yet.

Question 43 MSQ · 4.0 marks

[[IMAGE:5185c7098c73b2c9_10_28]]

Every company must have produced at least one item
An item can be produced by more than one company
Every customer must have bought at least one item
An item can be bought by more than one customer

A published solution is not available for this question yet.

Question 44 MSQ · 4.0 marks

[[IMAGE:5185c7098c73b2c9_11_29]]

[[IMAGE:5185c7098c73b2c9_11_30]]
[[IMAGE:5185c7098c73b2c9_11_31]]
[[IMAGE:5185c7098c73b2c9_11_32]]
[[IMAGE:5185c7098c73b2c9_11_33]]

A published solution is not available for this question yet.

Question 45 NAT · 4.0 marks

[[IMAGE:5185c7098c73b2c9_12_34]]

A published solution is not available for this question yet.

Question 46 NAT · 4.0 marks

[[IMAGE:5185c7098c73b2c9_13_35]]

A published solution is not available for this question yet.

Question 47 MCQ · 3.0 marks

Consider the following scenario and answer the given subquestions A startup company is building an online learning platform that hosts courses on various subjects. In this platform, students can enroll in multiple courses, and each course can be taught by one or more instructors. The company wants to design the database schema to manage the core entities: Student, Instructor, Course, and Enrollment.

In the Enrollment table, which of the following is a typical way to handle the primary key?

Use an auto-increment column (e.g., EnrollmentID) as the primary key.
Use a composite primary key consisting of StudentID and CourseID.
There is no need to have a primary key for the Enrollment table.
Use a primary key consisting of StudentID.

A published solution is not available for this question yet.

Question 48 MCQ · 2.0 marks

In a typical design, what is the relationship between the Student table and the Enrollment table?

One-to-One
One-to-Many
Many-to-Many
Many-to-One **PDSA** **Section Id :** 64065379121 **Section Number :** 4 **Section type :** Online **Mandatory or Optional :** Mandatory **Number of Questions :** 17 **Number of Questions to be attempted :** 17 **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 **Maximum Instruction Time :** 0

A published solution is not available for this question yet.