Q1) Which of thefollowing is not correct SQL statements?

A - SQLstatements are not case sensitive.

B - SQLstatements can be written on one or more lines.

C - Keywordscannot be split across lines.

D - Clauses mustbe written on separate lines.

Q2) Consider thefollowing schema:

STUDENTS(student_id,first_name,last_name,email_address,phone_no,date_of_birth,subject,gpa);

Which of the followingquery would display the full name of a student, with a columnheading "Name"

A - selectfirst_name, last_name as “Name” from students;

B - select Namefrom students;

C - selectfirst_name, last_name as “Name” from students;

D - selectfirst_name, last_name from students;

Q3) Consider thefollowing schema:

STUDENTS(student_id,first_name,last_name,email_address,phone_no,date_of_birth,subject,gpa);

Which of the followingquery would display the distinct subjects in the STUDENTStable?

A - selectsubject from students;

B - selectdistinct subject from students;

C - select allsubject from students;

D - select * fromstudents;

Q4) Consider thefollowing schema:

STUDENTS(student_id,first_name,last_name,email_address,phone_no,date_of_birth,subject,gpa);

Which of the followingquery would display all the students with subject ‘Eng01’?

A - selectstudent_id, first_name, last_name from students where subject =‘Eng01’;

B - selectstudent_id, first_name, last_name from students where subject is‘Eng01’;

C - selectstudent_id, first_name, last_name where subject = ‘Eng01’

from students;

D - selectstudent_id, first_name, last_name from students;

Q5) Consider thefollowing schema:

STUDENTS(student_id,first_name,last_name,email_address,phone_no,date_of_birth,subject,gpa);

Which of the followingquery would display all the students whose first name starts withthe character ‘A’?

A - selectfirst_name from students where first_name like ‘A%’;

B - selectfirst_name from students where first_name like ‘%A’;

C - selectfirst_name from students where first_name like ‘%A%’;

D - selectfirst_name from students where first_name like ‘A’;

Q6) Consider thefollowing schema:

STUDENTS(student_id,first_name,last_name,email_address,phone_no,date_of_birth,subject,gpa);

Which of the followingquery would display all the students where the second letter in thefirst name is ‘i’?

A - selectfirst_name from students where first_name like ‘_i%’;

B - selectfirst_name from students where first_name like ‘%i_’;

C - selectfirst_name from students where first_name like ‘%i%’;

D - selectfirst_name from students where first_name like ‘_i_’;

Q7) Consider thefollowing schema:

STUDENTS(student_id,first_name,last_name,email_address,phone_no,date_of_birth,subject,gpa);

Which of the followingquery would display names of all the students whose email ids arenot provided?

A - selectfirst_name, last name from students where email_address = 0;

B - selectfirst_name, last name from students where email_address = ‘ ‘;

C - selectfirst_name, last name from students where email_address isnull;

D - selectfirst_name, last name from students where email_address =‘null’;

Q8) Consider thefollowing schema ?

STUDENTS(student_id,first_name,last_name,email_address,phone_no,date_of_birth,subject,gpa);

Which of the followingquery would display names of all the students whose subject isEnglish and gpa is above B, or subject is Spanish and gpa is aboveB?

A - selectfirst_name, last name from students where (subject = “English” orsubject = “Spanish” ) and gpa > B;

B - selectfirst_name, last name from students where subject = “English” orsubject = “Spanish” and gpa> B;

C - selectfirst_name, last name from students where (subject = “English” orsubject = “Spanish” and gpa> B;

D - selectfirst_name, last name from students where (subject = “English”) orsubject = “Spanish” and gpa> B;

Item No.	Marks Rubrics Criteria	Marks	ILOs	Marks Obtained
1	Apply modern DB design using SQL Server.	8	B3
	Total	8

Student Name:

Answer rating: 100% (QA)

1 D Clauses must be written on separate lines Explanation SQL statements are not case sensitive as w... View the full answer