Question

Consider the following schema −STUDENTS(student_code, first_name, last_name, email, phone_no, date_of_birth, honours_subject, percentage_of_marks);Which query will display the names and honours subjects of all students and if a student has not yet been given a honours subject yet, then it should display ‘No Honours Yet’.

Answer 1

Answer:

• class Honours {. Public void main( string[ ]args).

Answer 2

"SELECT first_name, last_name, honours_subject FROM students"

Explanation:

• by Considering the following schema −STUDENTS(student_cod, first_name, last_name, email, phone_no, date_of_birth, honours_subject, percentage_of_marks);
• SELECT first_name, last_name, honours_subject FROM students

will be the correct answer for a given question.

• this will show the names and honours sub of all students
• and this will show "NO honours Yet" if a child had not given honour sub.

hence, SELECT first_name, last_name, honours_subject FROM students will be the correct answer for a given question.