Database quiz

1. Given a relation called COURSE where each row in the table describes a course available for
students, which SQL statement below will return a count of courses in the COURSE tables?

2. Which clause, or clauses, are always required when executing an SQL statement that will return
either a result set or NULL?
a. select
b. where
c. having
d. from
e. both a and d

3. Which keyword is used in SQL expressions to select partial values? HINT: It can be used with
wildcard characters, which represent unknown characters in a pattern.


4. Write an SQL query that creates a database container for a database named itd_256.

5. Given a table named COURSE, write an SQL query that returns all of the data in the COURSE table
(i.e., all of the fields and all records).


6. Given a table called COURSE that contains a numeric field called Fee, write an SQL query that
returns all fields and all records in the table where Fee is greater than 100.
ITD 256

7. Given a table called CUSTOMER that contains a varchar field called CustomerFirstName, write an
SQL query that returns all of the data in the CUSTOMER table and sorts the result set by field
CustomerFirstName in ascending order.

8. Given a table named COURSE with fields CourseName (varChar), CourseDate (Date), and Fee
(numeric), write an SQL query that returns the fields CourseName, Fee, and CourseDate (in that
order) for all courses with CourseName equal to Adv Pastels.

9. Given a table named COURSE with fields CourseName (varChar), CourseDate (Date), and Fee
(numeric), write an SQL query that returns the fields CourseName, Fee, and CourseDate (in that
order) for all courses that have a CourseName ending in Pastels.

More questions in file attachted


Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-8hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

Do you have an upcoming essay or assignment due?

All of our assignments are originally produced, unique, and free of plagiarism.

If yes Order Paper Now