Exam 3: Creating Tables

What is the original name of SQL?

For any column whose data type is CHAR, values must be enclosed in ____.

To enter a null value into a table, you use a special format of the NULL command.

If you need to delete a row from a table, you can use the ____________________ command.

In SQL, table names cannot exceed ____ characters.

In Access, use the Documenter tool to describe the tables in a database.

Oracle stores script files is a special location called Saved Commands.

You indicate the end of a command by typing a ____.

You can use the ____________________ command to update a value in a table.

In SQL Server, execute the sp_columns command to list all the columns in a table.

In Oracle 10G Express, you enter commands on the SQL ____________________ page.

Access does not support the ____ data type.

The ____ command defines a table's structure by listing its columns, data types, and column lengths.

In Oracle, the date, November 12, 2010 would be stored as '12-NOV-2010'.

Which of the following commands changes the value in a column?

You can use the ____________________ data type to store date data.

You must enclose values in ____________________ quotation marks for any column whose type is character (CHAR), even when the data contains numbers.

Unlike Oracle, Access does not support the DECIMAL data type.

Should a user be allowed to enter null values for the primary key?

When a script file contains more than one command, each command must end with a(n) ____.