Sign up now
to enroll in courses, follow best educators, interact with the community and track your progress.
Download
SQL query question (in Hindi)
782 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
sir pls coures on aptitude nd reasoning
Ojhhh TEgbi
a year ago
Do follow Shalini Sharma on Unacademy. She is very good Reasoning Educator. You will get to know many tips and tricks to save time..
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