Question
Q1) Which of thefollowing is not correct SQL statements? A - SQLstatements are not case sensitive. B - SQLstatements can be written on one or
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:
Step by Step Solution
3.40 Rating (162 Votes )
There are 3 Steps involved in it
Step: 1
1 D Clauses must be written on separate lines Explanation SQL statements are not case sensitive as w...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started