Exam 5: Beginning Structured Query Language Sql

An alias is especially useful when a table must be joined to itself in a(n) ____________________ query.

The SQL command that lets you permanently save data changes is ____.

In an INSERT command, you can indicate just the attributes that have required values by listing the ____________________ inside parentheses after the table name.

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

In SQL, all ____________________ expressions evaluate to true or false.

To list the contents of a table, you must use the DISPLAY command.

The ____________________ clause of the GROUP BY statement operates very much like the WHERE clause in the SELECT statement.

The most recent fully approved version of standard SQL prescribed by the ANSI is ____.

The COUNT function is designed to tally the number of non-null "values" of an attribute, and is often used in conjunction with the DISTINCT clause.

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

A(n) ____________________, also known as a nested query or an inner query, is a query that is embedded (or nested) inside another query.

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

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

Which of the following is used to select partial table contents?

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

The SQL command that lets you insert rows into a table is ____.

A(n) ____ is an alternate name given to a column or table in any SQL statement.

To delete a row from the PRODUCT table, use the ____ command.

Which query will output the table contents when the value of V_CODE is not equal to 21344?

A database language enables the user to create database and table structures to perform basic data management chores.