Sign up now
to enroll in courses, follow best educators, interact with the community and track your progress.
Download
SQL query question (in Hindi)
582 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
I am surprised that in the first question, you didn't use the formula "(ab+bc-ca)/2 it would have taken around 15 second for the answer
Patrick Dsouza
9 months ago
my general policy while solving is not to put eqations or formula. In one off sum I could be a little slower, but the habit helps me to be overall quite fast. Therefore in this year's cat I could complete the quant section 8 mins before 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