Question 1

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

Accepted Answer

The answer of To run a script file, type either...

Question 2

The ____ data type stores only the actual character string.

Accepted Answer

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

Question 3

In MySQL, dates have the form ____.

Accepted Answer

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

SQL was developed in the mid-____.

Accepted Answer

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

The answer of To indicate columns that cannot contain null...

Question 10

MySQL does not require a password.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

In general, SQL is case-sensitive.

Accepted Answer

A) True 
 B)False

Question 13

The MySQL Reference Manual provides more detailed help.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

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

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

The ____ data type stores only the actual character string.

In MySQL, dates have the form ____.

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

SQL was developed in the mid-____.

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

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

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

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

MySQL does not require a password.

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

In general, SQL is case-sensitive.

The MySQL Reference Manual provides more detailed help.

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

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

Introduction to Premiere Products, Henry Books, and Alexamara Marina Group

Database Design Fundamentals

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

MySQL Special Topics

Filters

Exam 3: An Introduction to SQL

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

The ____ data type stores only the actual character string.

In MySQL, dates have the form ____.

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

SQL was developed in the mid-____.

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

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

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

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

MySQL does not require a password.

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

In general, SQL is case-sensitive.

The MySQL Reference Manual provides more detailed help.

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

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

Introduction to Premiere Products, Henry Books, and Alexamara Marina Group

Database Design Fundamentals

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

MySQL Special Topics

Filters