Database Management Systems, Quiz 2

May 2026 term, 16 Aug 2026, Set 1

Learning mode

Question 1

+3−0Single correctInstructions

The relation Students(Name, Total_Marks) contains the names and marks of different students where no two students have the same name or total marks. What will the following SQL query return?

Select one option

• A.

  Names of the students with the first four highest marks

• B.

  Name of the student with the 4th highest mark

• C.

  Names of the students with the first three highest marks

• D.

  Name of the student with the 3rd highest mark

Show answer

Report

Report a problem

Sign in to report a problem with this question.

Clear Response

PreviousNext

Submit this paper?

You cannot change your answers after submitting.

Answered

0

Not answered

1

Marked for review

0

Answered & marked for review

0

Not visited

2

Keep goingSubmit paper

Instructions

The palette shows the status of every question. Pick a number to go straight to it.

Answered

0

Not answered

1

Marked for review

0

Answered & marked for review

0

Not visited

2

• Save & Next moves to the next question. Answers are saved as you go.
• Mark for Review & Next flags the question to come back to. A flagged answer still counts.
• Clear Response removes your answer to the question on screen.
• The ← and → keys move to the previous and next question.

The relation Students(Name, Total_Marks) contains the names and marks of different students where no two students have the same name or total marks. What will the following SQL query return? The relation Students(Name, Total_Marks) contains the names and marks of different students where no two students have t Consider a relation R(A, B, C, D, E) with following functional dependency set FD : {A → BC, CD → E, B → D, E → A} What is the highest normal form of R? Consider the relation R(A, B, C, D, E, F) with dependency set FD: {AB → C, E → F, AC → B, BC → A, B → D, AD → E} Following are the two decompositions of R: ●D1 : {AB, BC, EF, ABDE}●D2 : {ABC, ADF, ACDE} Choose the correct option