Partial Values

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.