Exam 3: Structured Query Language

Given the table $\text { STUDENT(\underline{StudentID}, Name, Advisor) }$ ,which of the following SQL statements would be used to change the value of the Advisor field to 'Smith' for all rows in the STUDENT table?

Distinguish between the HAVING clause and the WHERE clause.

To open a new Microsoft Access Query window:

Built-in SQL functions cannot be applied to data combined using the GROUP BY keyword.

Which of the following standard SQL data types is not supported in Microsoft Access SQL?

Explain why it is important to learn SQL.

Which SQL keyword can be used in conjunction with wildcards to select partial values?

If you need to create a primary key that is a composite key using SQL,the key may be defined when the table is created using the CREATE TABLE statement.

Explain two methods for defining a primary key using SQL.

The result for SELECT statements in SQL is a relation unless the result is a single number.

The SQL GROUP BY keyword can be used to group rows by common values.

A subquery is appropriate only if the final result contains only data from a single table.

What are SQL Built-in Functions?

In SQL,the LIKE keyword can be combined with the NOT keyword to form the NOT LIKE condition for selecting values.

In SQL,to refer to a range of values in a WHERE clause,use the WITHIN keyword.

In Microsoft Access,the default method of creating and running a query is ________.

In SQL,the IS NULL keyword can be used to select on records containing NULL values in a particular column.

Microsoft Access SQL commands are run in the ________ of a Query window.

Which SQL keyword is used to eliminate duplicate rows in the results of an SQL SELECT query?

SQL was developed by ________ in the late 1970s.