Exam 7: Introduction to Structured Query Language (SQL)

If you have not yet used the COMMIT command to store the changes permanently in the database,you can restore the database to its previous condition with the ROLLBACK command.

The ANSI SQL standards are also accepted by the ISO.

Date procedures are often more software-specific than other SQL procedures.

The CHECK constraint is used to define a condition for the values that the attribute domain cannot have.

In a 1:M relationship,you must always create the table for the ____________________ side first.

The basic SQL vocabulary has fewer than ____________________ words.

The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME,V_AREACODE,V_PHONE,and V_CONTACT fields from the VENDOR table where the values of V_CODE match is ____.

To join tables,simply enumerate the tables in the FROM clause of the SELECT statement.The DBMS will create a Cartesian product of every table in the FROM clause.To get the correct results,you need to select the rows in which the common attributes do not match.

How do you delete a table from the database? Provide an example.

Oracle users can use the Access QBE (query by example)query generator.

DATE()and SYSDATE are special functions that return today's date in MS Access and ____________________,respectively.

Rows can be grouped into smaller collections quickly and easily using the SQL ____________________ clause.

Which query is used to list a unique value for V_CODE,where the list will produce only a list of those values that are different from one another?

A(n)____________________ character is a symbol that can be used as a general substitute for other characters or commands.

What command is used to save changes to the database? What is the syntax for this command?

A table can be deleted from the database by using the ____ command.

Which query uses the correct SQL syntax to list the table contents for either V_CODE = 21344 or V_CODE = 24288?

The ____ special operator is used to check whether an attribute value is null.

A(n)____ is a query that is embedded (or nested)inside another query.

SQL requires the use of the ADD command to enter data into a table.