Exam 3: An Introduction to SQL

To display data vertically rather than horizontally, replace the semicolon at the end of the command with ____.

Dropping a table also deletes any data that you entered into the table.

SQL is Structured ____________________ Language.

You can delete the entire table using the ____________________ TABLE command.

In MySQL, you type the command at the mysql> prompt and press the Run key at the end of each line.

In MySQL, to move to the end of a line, you need to press the ____ key(s).

If the CREATE TABLE command is executed more than once for the same table, MySQL overwrites the table with the newest data description.

If the word ____________________ follows the word INT, a column is created for which MySQL will automatically generate a new sequence number each time a new row is added.

How can you correct errors in data?

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

To move up a line in the statement history, use the ____________________ key(s).

The data type indicates the type of data that a column can contain as well as the maximum number of characters or digits that the column can store.

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

In MySQL, you type commands at the mysql> ____.

In MySQL, the most recent command entered is stored in a special area of memory called the ____.

The ____________________ command adds rows to a table.

To examine the structure of a table, use the ____________________ command.

In MySQL, to move to the beginning of the current line, you need to press the ____ key(s).

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

You use the ____________________ command to describe the layout of a table.