Question 1

Using the TAL company tables: How do you retrieve the customer num and customer name of all the customers who buy from repnum 30 ?

Question 2

A column which is specified as the ________ enforces a constraint that the only allowed values in it are either null or the values in another tables primary key.

Question 3

Using the TAL company tables, which is the correct SQL statement to create a view for all the items in storehouse 3 and are categorized as toys.

Question 4

Using the Colonial tables, which is the correct SQL statement to List the trip season and average gmax group size per season, sorted by season in descending order

Question 5

Which SQL structure would create if you had to speed up a select query

Question 6

This type of statement removes the records specified, but leave the table structure unmodified (choose one).

Question 7

To implement an insert database trigger on a table, we must use the following header. (choose one)

Question 8

The ______ integrity rule , is implemented by the primary key and says that a primary key column may not be null.

Question 9

he following SQL scripts, represents the implementation of a _________ (choose one)..

add constriant MyConstraint check (season in ('summer','fall','spring')

Question 10

To find out information (metadata) on the table structures in a database, you would use the ________ (choose one).