Sign up now
to enroll in courses, follow best educators, interact with the community and track your progress.
Download
SQL query question (in Hindi)
704 plays

More
In this lesson Nisha Mittal will provide solutions of questions of NTA NET computer science examination related to SQL query

Nisha Mittal is teaching live on Unacademy Plus

Nisha Mittal
🌟 MCA Gold Medalist 🌟 Star Educator 🌟Gate Qualified 🔴UGC NET qualified🔴🌟YouTuber ☆🌟BOOK published on LINUX ADMINISTRATION by kalyani publish

U
Unacademy user
thank so much sir please keep teaching
Sonu Kurmi
2 years ago
thanku
mam pls take my doubt query..
  1. Consider the following relations: SELECT S. Student_Name, sum (P.Marks) FROM Student S, Performance P WHERE S. Roll NoP. Roll No GROUP BY S.Student Name The number of rows that will be returned by the SQL query is Student Roll-No Student name Raj Rohit Ra (A) 0 (B) 1 (C) 2 (D) 3 2 Performance Roll- No Course Marks 1 Math 80 1 English 70 2 Math 75 3 English 80 2 Physics65 Math 80


  2. Consider the following relations: SELECT S. Student Name, sum (P.Marks) FROM Student S, Performance P WHERE S. Roll NoP. Roll No GROUP BY S.Student Name The number of rows that will be returned by the SQL query is Student Roll-No Student name Raj Rohit Ra (A) 0 (B)1SELECT S. Student_Name, sum (P.Marks) (C) 2 Raj, Rohit (D) 3S. Roll No P.Ro11 No 2 Performance 1,2,3 GROUP BY S.Student Name Raj- 80+70+80+80-350 Rohit =75+65=140 Roll- Course Marks 1 Math 80 1 English 70 2 Math 75 3 English 80 2 Physics 65 3 Math 80


  3. Consider the following relations: SELECT S. Student_Name, sum (P.Marks) FROM Student S, Performance P WHERE S. Roll NoP. Roll No GROUP BY S.Student Name The number of rows that will be returned by the SQL query is Student Roll-No Student name Raj Rohit Ra Performance (A) 0 (B) 1 (C) 2 (D) 3 2 3 Roll- No 1 Math 80 Course Marks there are only two student names and query prints sum (P.Marks) for every student Student Name Marks 1 English 70 2 Math 75 3 English 80 2 Physics 65 3 Math 80 Raj 310 Rohit 140


  4. Consider the following relations: SELECT S. Student_Name, sum (P.Marks) FROM Student S, Performance P WHERE S. Roll NoP. Roll No GROUP BY S.Student Name The number of rows that will be returned by the SQL query is Student Roll-No Student name Raj Rohit Ra Performance (A) 0 2 3 THE NUMBER OF ROWS THAT WILL BE RETURNED 2 Roll-Course MarksBY THE SQL QUERY IS 1 Math 80 1 English 70 2 Math 75 3 English 80 2 Physics 65 3 Math 80 there are only two student names and query prints sum (P.Marks) for every student Student Name Marks Raj 310 Rohit 140


  5. unacademy All live & Lessons by all Weekly quizz structured courses top Educators & doubt-clearing 001-11 US NISHA MITTAL Referral Code - nishamittal86-2742