Quiz Space

Database Management Systems · Quiz 1 · 16 Jul 2023 · May 2023 term

Question 5: An instance of the relation students is given below. | si…

Question 5

+2 marksOne correct option

An instance of the relation students is given below.

sidnameagegpa
53831Madayan111.8
53832Guldu122
53666Jones183.4
53688Smith193.2
53650Smith193.8

Figure 3: Relation students

Which of the following query executed on relation students would result in the output given below ?

sidnameagegpa
53832Guldu122
53666Jones183.4
53831Madayan111.8
53650Smith193.8
53688Smith193.2

Figure 4: Output

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answer

  • C
See the whole paperTake it as a mock test

Question 5 of 17 in the IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 16 Jul 2023, in the May 2023 term (IIT M FOUNDATION AN2 EXAM QPF2 16 JULY 2023). It carries 2 marks.

More questions from this paper

  1. Q1The lowest level of data abstraction is
  2. Q2Suppose a company wants to determine whether the ’price’ of the commodity will be an attribute in the shopping database…
  3. Q3Consider the following scenario:\ The Reserve Bank of India (RBI) has issued guidelines declaring that the Rs. 2000 not…
  4. Q4Consider the schema given below : Emp (<u>eid</u>, ename, age, salary)\ Works (<u>eid</u>, did, pct_time)\ Dept (<u>did…
  5. Q6Consider two relations R and S as shown below. | A | B | C | |---|---|---| | 1 | 2 | 3 | | 2 | 4 | 6 | | 3 | 7 | 3 | | …
  6. Q7Figure question
  7. Q8Figure question
  8. Q9Consider the relation G20(country_name, foreign_minister_name, events, date, venue)\ Questions: Find the name of foreig…
  9. Q10Figure question
  10. Q11Figure question
  11. Q12Consider the student relation given below. Select the correct query/queries to obtain the last name of students whose a…
  12. Q13Consider the two relations R and S. | A | B | C | |---|---|---| | 0 | 9 | 0 | | 2 | 2 | 2 | | 1 | 1 | 1 | | A | B | C |…
  13. Q14Consider the relation student shown in Table 3 | Roll_no | Name | marks | |---|---|---| | 1 | Ram | 50 | | 2 | Rakesh |…
  14. Q15Consider the following table which has four attributes: A, B, C, and D where A is the primary key and C is the foreign …
  15. Q16Figure question
  16. Q17Figure question