Deck 3: An Introduction to SQL

Question 1

In MySQL, you can display the data vertically rather than horizontally.

Answer 1

True

Question 2

When adding rows to character columns, make sure you enclose the values in double quotation marks.

Answer 2

False

Question 3

In SQL, you use the NOT NULL clause in a CREATE TABLE command to indicate columns that cannot contain null values.

Answer 3

True

Question 4

To create a table, type the word TABLE followed by the name of the table to be created and then by the names and data types of the columns that will comprise the table.

Question 5

To run the command(s)in a script file in MySQL, type SOURCE followed by the filename.

Question 6

To edit an SQL command, type EDIT at the mysql prompt..

Question 7

The shortcut command to quit MySQL is \q.

Question 8

If you added a row that should not be in a table, use a REMOVE command to remove it.

Question 9

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

Question 10

Table names cannot contain spaces.

Question 11

This text uses MySQL version 5.0.

Question 12

The MySQL Reference Manual provides more detailed help.

Question 13

MySQL uses the term current database to refer to the database to which all subsequent commands pertain.

Question 14

MySQL does not require a password.

Question 15

SQL was developed as the data manipulation language for IBM's prototype relational model DBMS, System R.

Question 16

In SQL, there are special rules that specify that a particular word must begin in a particular position on the line.

Question 17

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

Question 18

When you enter a new row into a table or modify an existing row, the values for one or more columns can be unknown or unavailable.

Question 19

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

Question 20

In general, SQL is case-sensitive.

Question 21

SQL was developed in the mid-____.

A)1960s
B)1970s
C)1980s
D)1990s

Question 22

In MySQL, table names cannot exceed ____ characters.

A)12
B)14
C)16
D)18

Question 23

You indicate the end of a command by typing a(n)____.

A)column
B)comma
C)semicolon
D)period

Question 24

Script files must be saved in the default folder for the DBMS.

Question 25

To list all the columns in a table, use the LIST COLUMNS command.

Question 26

The USE command is executed at the start of every session to activate the database.

Question 27

The CREATE DATABASE command is executed only once for a database.

Question 28

The data type DECIMAL(5,2)represents a number with three places to the left and two places to the right of the decimal.

Question 29

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

Question 30

In MySQL, to delete the previous character, you need to press the ____ key(s).

A)Ctrl + A
B)Ctrl + E
C)Backspace
D)Delete

Question 31

To display all the rows and columns in a table, type the word SELECT, followed by a(n)____, followed by the word FROM and then the name of the table containing the data you want to view.

A)single quote
B)asterisk
C)double quote
D)slash

Question 32

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

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

Question 33

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

A)UPDATE
B)CHANGE
C)REPLACE
D)ADD

Question 34

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.

Question 35

In MySQL,the date, November 12, 2007 would be stored as '11-12-2007'.

Question 36

What is the original name of SQL?

A)SEQUEL
B)MYSEQUEL
C)DBase
D)MySQL

Question 37

Which of the following is a valid name for a table?

A)TBL_1
B)2_TBL
C)TBL 3
D)4 tbl

Question 38

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

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

Question 39

In MySQL, the data type STRING(n)stores a character string n characters long.

Question 40

BRANCH&BOOK is a valid name for a table in MySQL.

Question 41

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

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

Question 42

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

Question 43

____ is an example of a text editor.

A)NotePad
B)Paint
C)Microsoft Word
D)Outlook

Question 44

In MySQL, dates have the form ____.

A)DD-MM-YY
B)MM-DD-YY
C)YYYY-MM-DD
D)DD-MM-YYYY

Question 45

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

Question 46

In MySQL, you use the ____________________ command to change the database to the one you want to use.

Question 47

The ____ data type is used to store integers.

A)INTEGER
B)NUMERAL
C)NUMBER
D)INT

Question 48

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

A)double quotation marks
B)parentheses
C)single quotation marks
D)square brackets

Question 49

The simplest way to obtain help in MySQL is to type ____ at the mysql> prompt.

A)helpmysql
B)\h
C)\ms
D)\a

Question 50

The ____ data type stores only the actual character string.

A)CHAR
B)VARCHAR
C)TEXT
D)STRING

Question 51

The correct data type for the BALANCE column in the CUSTOMER table is ____.

A)CHAR
B)INT
C)SMALLINT
D)DECIMAL

Question 52

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

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

Question 53

SQL is Structured ____________________ Language.

Question 54

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

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

Question 55

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

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

Question 56

You can use a special value to represent situations in which an actual value is unknown, unavailable, or not applicable. This special value is called a(n)____________________ data value.

Question 57

The ____ command activates the default database.

A)ACTIVATE
B)USE
C)DEFAULT
D)CHANGE

Question 58

The ____________________ command adds rows to a table.

Question 59

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

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

Question 60

The mysql prompt displays in the ____ Client window.

A)MySQL
B)DOS
C)Server
D)Command Line

Question 61

How can you correct errors in data?

Question 62

To view the data in a table, you use the ____________________ command.

Question 63

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

Question 64

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.

Question 65

What are the common restrictions placed on table and column names?

Question 66

To create a new database, execute the ____________________ command.

Question 67

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

Question 68

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

Question 69

Script files must have a ____________________ file name extension.

Question 70

To get more information about the union command, type ____________________ at the command prompt.

Question 71

To indicate columns that cannot contain null values, use the ____________________ clause in a CREATE TABLE statement.

Question 72

A file containing SQL commands is called a ____________________ file.

Question 73

To run a script file, type either SOURCE or ____________________ followed by the name of the file.

Question 74

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

Question 75

If you need to delete a record, you can use the ____________________ command.