Question 1

How can you correct errors in data?

Accepted Answer

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

Question 2

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

Accepted Answer

A)  apostrophe 
B)  semicolon 
C)  period 
D)  colon

Question 3

Which statement about changing the default database is FALSE?

Accepted Answer

A)  There are two steps to choosing a database to use: changing the default and activation. 
B)  The MySQL command USE SPIDERS; makes SPIDERS the default database. 
C)  Tables created in MySQL are added to the default database. 
D)  To activate a database, you execute the USE command followed by the database's name.

Question 4

What are a script file and a script repository?

Accepted Answer

The answer of What are a script file and a...

Question 5

What was the original name for SQL?

Accepted Answer

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

Question 6

In MySQL, Philip can use the command SELECT* FROM VACATION_PACKAGES; to _____.

Accepted Answer

A)  select only certain rows to modify from the VACATION_PACKAGES table 
B)  display a list of tables in the VACATION_PACKAGES database 
C)  add a new row of data to the table VACATION_PACKAGES 
D)  display all rows and columns in the table VACATION_PACKAGES

Question 7

Which general guideline for naming identifiers should you follow when creating a database and adding objects to it?

Accepted Answer

A)  Make identifiers at least 35 characters long. 
B)  Begin the identifier with a number. 
C)  Include letters, numbers, and/or underscores. 
D)  Use spaces to separate words.

Question 8

Which SQL command do you use to remove an entire row from a table?

Accepted Answer

A)  REMOVE 
B)  DELETE 
C)  ERASE 
D)  DROP

Question 9

Which SQL command is used to add rows to a table once its structure has been defined?

Accepted Answer

A)  ADD 
B)  SELECT 
C)  INSERT 
D)  CREATE

Question 10

When you add a row for which you have incomplete information to a SQL table, _____.

Accepted Answer

A)  you must change the table structure so that all rows are marked as NOT NULL 
B)  you use the INSERT command and name the columns for which you are entering data 
C)  you use the INSERT command and enter a value of null for the columns without data 
D)  the DBMS will always reject the new row the first time you execute the command

Question 11

Which statement about the command used to view all columns and rows in a database table is correct?

Accepted Answer

A)  The same simple version of this command can be used in MySQL, Oracle, and SQL Server. 
B)  When using Oracle, the semicolon in the MySQL command must be replaced with a slash. 
C)  The command used in SQL Server is different from that used in MySQL and Oracle. 
D)  The command contains two symbols: an colon and a question mark.

Question 12

A MySQL database includes a CUSTOMER table, which stores each customer's current balance in U.S. dollars and cents, among other information. The correct data type for the BALANCE column in the CUSTOMER table is _____.

Accepted Answer

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

Question 13

Janice wants to examine the structure of the COFFEE table, which was created by a colleague, including the column names, data types, and acceptance/nonacceptance of null values. Which command should Janice execute?

Accepted Answer

A)  CREATE TABLE COFFEE; 
B)  SELECT COFFEE; 
C)  SHOW COFFEE; 
D)  DESCRIBE COFFEE;

Question 14

To change a value in a table, use the CHANGE command.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Exam 3: Creating Tables