MauryaHub PYQ Practice

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]]
Source diagram or notation

    A published solution is not available for this question yet.

    Question 84 NAT · 3.0 marks

    [[IMAGE:cc250ede1193d61d_1_1]]
    Source diagram or notation

      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?
      1. Query → Parser and Translator → Evaluation Engine → Optimizer → Query Output
      2. Query → Optimizer → Evaluation Engine → Parser and Translator → Query Output
      3. Query → Parser and Translator → Optimizer → Evaluation Engine → Query Output
      4. 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]]
      Source diagram or notation
      1. 1-A, 2-B, 3-C
      2. 1-B, 2-A, 3-C
      3. 1-B, 2-C, 3-A
      4. 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]]
      Source diagram or notation
      1. 4 rows and 6 columns
      2. 2 rows and 5 columns
      3. 4 rows and 5 columns
      4. 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]]
      Source diagram or notation
      1. Names of the students with the first four highest marks
      2. Name of the student with the 4th highest mark
      3. Names of the students with the first three highest marks
      4. 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]]
      Source diagram or notation
      1. Q1 is correct but Q2 is wrong
      2. Q2 is correct but Q1 is wrong
      3. Both Q1 and Q2 are wrong
      4. 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.
      Source diagram or notation
      1. An employee can work on more than one project.
      2. A project can have employees from more than one department, working on it.
      3. A dependent, who is not dependent on any employee, can exist.
      4. 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]]
      Source diagram or notation
      1. [[IMAGE:cc250ede1193d61d_7_8]]
        Source diagram or notation
      2. [[IMAGE:cc250ede1193d61d_7_9]]
        Source diagram or notation
      3. [[IMAGE:cc250ede1193d61d_7_10]]
        Source diagram or notation
      4. [[IMAGE:cc250ede1193d61d_7_11]]
        Source diagram or notation

      A published solution is not available for this question yet.

      Question 93 NAT · 4.0 marks

      [[IMAGE:cc250ede1193d61d_8_12]]
      Source diagram or notation

        A published solution is not available for this question yet.

        Question 94 NAT · 3.0 marks

        [[IMAGE:cc250ede1193d61d_9_13]]
        Source diagram or notation

          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]]
          Source diagram or notationSource diagram or notation
          1. 1-a, 2-d, 3-f
          2. 1-b, 2-c, 3-e
          3. 1-a, 2-d, 3-e
          4. 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]]
          Source diagram or notationSource diagram or notation
          1. First names of players who are in either the Warriors or the Lakers team
          2. First names of players who are in both the Warriors and the Lakers teams
          3. Unique First names of players who are in both the Warriors and the Lakers teams
          4. 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]]
          Source diagram or notationSource diagram or notation
          1. 7
          2. 5
          3. 9
          4. 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]]
          Source diagram or notationSource diagram or notation
          1. [[IMAGE:cc250ede1193d61d_12_20]]
            Source diagram or notation
          2. [[IMAGE:cc250ede1193d61d_12_21]]
            Source diagram or notation
          3. [[IMAGE:cc250ede1193d61d_12_22]]
            Source diagram or notation
          4. [[IMAGE:cc250ede1193d61d_12_23]]
            Source diagram or notation

          A published solution is not available for this question yet.

          Question 99 MCQ · 4.0 marks

          [[IMAGE:cc250ede1193d61d_11_17]]
          [[IMAGE:cc250ede1193d61d_13_24]]
          Source diagram or notationSource diagram or notation
          1. [[IMAGE:cc250ede1193d61d_13_25]]
            Source diagram or notation
          2. [[IMAGE:cc250ede1193d61d_13_26]]
            Source diagram or notation
          3. [[IMAGE:cc250ede1193d61d_13_27]]
            Source diagram or notation
          4. [[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
            Source diagram or notation

          A published solution is not available for this question yet.