Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Physical Universe

Authors: Konrad B Krauskopf, Arthur Beiser

16th edition

77862619, 978-0077862619

More Books

Students also viewed these Programming questions

Question

Describe MRP processing.

Answered: 1 week ago