Question 1

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

Accepted Answer

A) \G 
B) \V 
C) % 
D) #

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

SQL is Structured ____________________ Language.

Accepted Answer

The answer of SQL is Structured ____________________ Language....

Question 4

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

Accepted Answer

The answer of You can delete the entire table using...

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) CTRL + A 
B) Right arrow 
C) CTRL + E 
D) Tab

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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.

Accepted Answer

The answer of If the word ____________________ follows the word...

Question 9

How can you correct errors in data?

Accepted Answer

The answer of How can you correct errors in data?...

Question 10

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

Accepted Answer

A) question mark 
B) colon 
C) period 
D) semicolon

Question 11

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

Accepted Answer

The answer of To move up a line in the...

Question 12

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.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) worksheet 
B) window 
C) prompt 
D) screen

Question 15

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

Accepted Answer

A) browser history 
B) command history 
C) session history 
D) statement history

Question 16

The ____________________ command adds rows to a table.

Accepted Answer

The answer of The ____________________ command adds rows to a...

Question 17

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

Accepted Answer

The answer of To examine the structure of a table,...

Question 18

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

Accepted Answer

A) CTRL + A 
B) Left arrow 
C) Backspace 
D) CTRL + E

Question 19

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

Accepted Answer

A) NEW TABLE 
B) DEFINE TABLE 
C) CREATE TABLE 
D) ADD TABLE

Question 20

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

Accepted Answer

The answer of You use the ____________________ command to describe...

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.