Home » Database » Database miscellaneous » Question

Database miscellaneous

  1. Consider the following relations :

    Consider the following SQL query. SELECT S.
    Student_Name, sum (P.Marks)
    FROM Student S, Performance P
    WHERE S.Roll_No. = P.Roll_No.
    GROUP BY S.Student_Name
    The number of rows that will be returned by the SQL query is _______.
    1. 1
    2. 2
    3. 4
    4. 25
Correct Option: B

Output table is



Your comments will be displayed only after manual approval.