MauryaHub PYQ Practice

cs2001_2026T2_Q1_NA.pdf

Database Management System(DBMS) · Quiz 1 · May 2026

← 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 2 MCQ · 1.0 marks

Which of the following components of the Database Management System (DBMS) is primarily responsible for generating and selecting the most cost-effective execution plan for a given SQL query?
  1. Parser and Translator
  2. Query Optimizer
  3. Evaluation Engine
  4. Buffer Manager

A published solution is not available for this question yet.

Question 3 MCQ · 3.0 marks

Consider the relation **Delivery_Fee**: [[IMAGE:b189d2b156b0c9c6_3_2]]
Source diagram or notation
  1. 30.00
  2. 35.00
  3. 40.00
  4. 42.00

A published solution is not available for this question yet.

Question 4 MCQ · 4.0 marks

Consider the following SQL statements are executed in sequence on a newly created table **Shipment**: [[IMAGE:b189d2b156b0c9c6_4_3]]
Source diagram or notation
  1. [[IMAGE:b189d2b156b0c9c6_4_4]]
    Source diagram or notation
  2. [[IMAGE:b189d2b156b0c9c6_4_5]]
    Source diagram or notation
  3. [[IMAGE:b189d2b156b0c9c6_4_6]]
    Source diagram or notation
  4. [[IMAGE:b189d2b156b0c9c6_5_7]]
    Source diagram or notation

A published solution is not available for this question yet.

Question 5 MCQ · 4.0 marks

Create a table **Assignment(AssignID, PilotID, FlightNo, Date)** with the following criteria that must be satisfied: • Every assignment must have a unique AssignID. • Each pilot can only be assigned to a specific flight once on any given date. • Pilots may share the same flight number on different dates. Which of the following SQL queries can be used to correctly create the table **Assignment**?
  1. [[IMAGE:b189d2b156b0c9c6_5_8]]
    Source diagram or notation
  2. [[IMAGE:b189d2b156b0c9c6_5_9]]
    Source diagram or notation
  3. [[IMAGE:b189d2b156b0c9c6_6_10]]
    Source diagram or notation
  4. [[IMAGE:b189d2b156b0c9c6_6_11]]
    Source diagram or notation

A published solution is not available for this question yet.

Question 6 MCQ · 4.0 marks

[[IMAGE:b189d2b156b0c9c6_6_12]]
Source diagram or notation
  1. Names of pilots who earn less than the most experienced person in their airline.
  2. Names of pilots who earn more than the most experienced person in their airline.
  3. Names of pilots who earn more than all less experienced colleagues in their airline.
  4. Names of pilots who earn less than all less experienced colleagues in their airline.

A published solution is not available for this question yet.

Question 7 MCQ · 4.0 marks

Consider the relational schemas **Pilot**, **Aircraft_Type** and **Certified**: [[IMAGE:b189d2b156b0c9c6_7_13]]
Source diagram or notation
  1. Names of pilots who are certified for at least one aircraft type
  2. Names of pilots who are certified for exactly one aircraft type
  3. Names of pilots who are certified for all available aircraft types
  4. Names of pilots who are not certified for any aircraft type

A published solution is not available for this question yet.

Question 8 MSQ · 4.0 marks

Consider the following relational schema for a movie database: [[IMAGE:b189d2b156b0c9c6_8_14]]
Source diagram or notation
  1. [[IMAGE:b189d2b156b0c9c6_8_15]]
    Source diagram or notation
  2. [[IMAGE:b189d2b156b0c9c6_8_16]]
    Source diagram or notation
  3. [[IMAGE:b189d2b156b0c9c6_8_17]]
    Source diagram or notation
  4. [[IMAGE:b189d2b156b0c9c6_8_18]]
    Source diagram or notation

A published solution is not available for this question yet.

Question 9 MSQ · 4.0 marks

Consider two relations **R(A, B)** and **S(B, C)**. Which of the following SQL queries is/are logically equivalent to the Relational Algebra expression [[IMAGE:b189d2b156b0c9c6_8_19]] ?
Source diagram or notation
  1. [[IMAGE:b189d2b156b0c9c6_8_20]]
    Source diagram or notation
  2. [[IMAGE:b189d2b156b0c9c6_8_21]]
    Source diagram or notation
  3. [[IMAGE:b189d2b156b0c9c6_9_22]]
    Source diagram or notation
  4. [[IMAGE:b189d2b156b0c9c6_9_23]]
    Source diagram or notation

A published solution is not available for this question yet.

Question 10 MSQ · 4.0 marks

Consider the Entity-Relationship (ER) diagram below representing an organization’s logical schema of their database: [[IMAGE:b189d2b156b0c9c6_9_24]]
Source diagram or notation
  1. The **Skill** attribute is multi-valued and requires a separate relational table with (Emp_ID, Skill) as its composite primary key
  2. The minimum number of relational tables required to map this entire ER diagram to a relational schema is 6
  3. The composite attribute **Name** will typically require a separate table to be mapped correctly.
  4. The relational table for the weak entity **Dependent** will have a primary key consisting of only **Dep_Name** and **DOB**

A published solution is not available for this question yet.

Question 11 MSQ · 4.0 marks

Consider the following two relations [[IMAGE:b189d2b156b0c9c6_10_25]] and [[IMAGE:b189d2b156b0c9c6_10_26]] [[IMAGE:b189d2b156b0c9c6_10_27]]
Source diagram or notationSource diagram or notationSource diagram or notation
  1. [[IMAGE:b189d2b156b0c9c6_10_28]]
    Source diagram or notation
  2. [[IMAGE:b189d2b156b0c9c6_10_29]]
    Source diagram or notation
  3. [[IMAGE:b189d2b156b0c9c6_10_30]]
    Source diagram or notation
  4. [[IMAGE:b189d2b156b0c9c6_10_31]]
    Source diagram or notation

A published solution is not available for this question yet.

Question 12 NAT · 2.0 marks

Suppose relation **R(A,B,C,D)** has candidate keys: **{A,B}** and **{A,C}**. How many distinct superkeys does relation R have?

    A published solution is not available for this question yet.

    Question 13 MCQ · 2.0 marks

    Let R(A,B) = {(1,2),(2,3),(3,4)} and S(B,C) = {(2,5),(3,6)}. Find the number of tuples in [[IMAGE:b189d2b156b0c9c6_11_32]] .
    Source diagram or notation
    1. 2
    2. 3
    3. 4
    4. 6

    A published solution is not available for this question yet.

    Question 14 MCQ · 2.0 marks

    Consider the following three tables: [[IMAGE:b189d2b156b0c9c6_12_33]]
    Source diagram or notation
    1. 2
    2. 3
    3. 4
    4. 5

    A published solution is not available for this question yet.

    Question 15 MCQ · 2.0 marks

    Consider an EER model in which **Person** is a supertype entity type. Two subtype entity types, **Employee** and **AccountHolder**, are defined as specializations of Person. • A person may be an Employee only. • A person may be an AccountHolder only. • A person may be both an Employee and an AccountHolder. • A person may belong to neither subtype and exist only as a Person. Which specialization constraints apply to this specialization? Identify the constraints on specialization with respect to the above scenario.
    1. Disjoint and Partial
    2. Overlapping and Partial
    3. Disjoint and Total
    4. Overlapping and Total

    A published solution is not available for this question yet.

    Question 16 MSQ · 3.0 marks

    Consider two relations **R(A,B)** and **S(B)**. Relation **R** contains **10** tuples and relation **S** contains **2** tuples. Both relations contain strictly non-null values. Which of the following statements regarding the relational algebra division operation **R÷S** are TRUE?
    1. The maximum possible number of tuples in R÷S is **5**
    2. The minimum possible number of tuples in R÷S is **1**
    3. **R÷S** can be equivalently expressed as [[IMAGE:b189d2b156b0c9c6_13_34]]
      Source diagram or notation
    4. If a new, distinct tuple is inserted into relation S, the number of tuples in the resulting R ÷ S might increase

    A published solution is not available for this question yet.

    Question 17 NAT · 3.0 marks

    Consider the following **Employee** table: [[IMAGE:b189d2b156b0c9c6_13_35]]
    Source diagram or notation

      A published solution is not available for this question yet.