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

More
SQL update query for NTA NET computer science examination

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
  1. SQL update


  2. SQL update


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


  4. SQL update


  5. A table T1 in a relational database has the following rows and columns: Roll NO Marks 10 20 30 NULL 4 The following sequence of SQL statements was successfully executed on table T1. Update T1 set marks = marks + 5 Select avg(marks) from T1 What is the output of the select statement? A. 18.75 B. 20 C. 25 D. Null


  6. A table T1 in a relational database has the following rows and columns: Roll NO Marks 10 20 30 NULL Update 4 The following sequence of SQL statements was successfully executed on table T1. Update T1 set marks = marks + 5 Select avg(marks) from T1 Roll NO Marks What is the output of the select statement? A. 18.75 B. 20 C. 25 D. Null 10+5 20+5 30+5 NULL 3 4


  7. A table T1 in a relational database has the following rows and columns: Roll NO Marks 10 20 30 NULL Update on null gives null 4 The following sequence of SQL statements was successfully executed on table T1. Update T1 set marks = marks + 5 Select avg(marks) from T1 Roll NO Marks What is the output of the select statement? A. 18.75 B. 20 C. 25 D. Null 15 25 35 NULL 3 4


  8. A table T1 in a relational database has the following rows and columns: Roll NO Marks Update on null gives null 10 20 30 NULL Now, avg function ignores null values. 4 The following sequence of SQL statements was successfully executed on table T1. Update T1 set marks = marks + 5 Select avg(marks) from T1 Roll NO Marks What is the output of the select statement? A. 18.75 B. 20 C. 25 D. Null 15 25 35 NULL 3 4


  9. A table T1 in a relational database has the following rows and columns: Roll NO Marks Update on null gives null. 10 20 30 NULL Now, avg function ignores null values. 4 The fo hee (15+25+35)/3-25 kecuted on table T1. NO Marks What is the output of the select statement? A. 18.75 B. 20 C. 25 D. Null 15 25 35 NULL 4