Sign up now
to enroll in courses, follow best educators, interact with the community and track your progress.
Download
SQL query question (in Hindi)
349 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 🌟YouTuber ☆🌟BOOK published on LINUX ADMINISTRATION by kalyani publisher ☆🌟 7+ years teac

Unacademy user
  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