Question 1

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

Accepted Answer

A) True 
 B)False  True

Question 2

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

Question 3

Why does the POSTAL_CODE column in the REP table of the KimTay database have a data type of CHAR, if a postal code is made up of numbers?

Accepted Answer

Even though the POSTAL_CODE column contains numbers, those numbers are not used in calculations. Therefore, the column should have a CHAR data type.

Question 4

It is recommended that table names be limited to _____.

Accepted Answer

A)   12 characters
B)   14 characters
C)   24 characters
D)   30 characters

Question 5

A text file with a .sql extension that contains SQL commands is a _____.

Accepted Answer

A)   command file
B)   batch process
C)   SQL plugin
D)   script file

Question 6

SQL was developed in the mid-____.

Accepted Answer

A)   1950s
B)   1970s
C)   1990s
D)   2000s

Question 7

Laura is adding a new product to the CANDY table, which has columns for the product ID, name, description, and price. Price is a dollars and cents value; the others are strings of characters. Which SQL command should Laura use to add the row for the new product?

Accepted Answer

A)   INSERT CANDY ROW (534, Cordial fudge, Dark chocolate fudge squares topped with a cherry swirl, 5.85) ;
B)   INSERT VALUES ('534', 'Cordial fudge', 'Dark chocolate fudge squares topped with a cherry swirl', 5.85)  INTO CANDY;
C)   INSERT INTO CANDY VALUES (534, Cordial fudge, Dark chocolate fudge squares topped with a cherry swirl, 5.85) ;
D)   INSERT INTO CANDY VALUES ('534', 'Cordial fudge', 'Dark chocolate fudge squares topped with a cherry swirl', 5.85) ;

Question 8

To list all the columns in a table and their properties in MySQL, use the LIST COLUMNS command.

Accepted Answer

A) True 
 B)False

Question 9

Which data type should you use for columns that contain letters and special characters or numbers that will not be used in calculations?

Accepted Answer

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

Question 10

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

Accepted Answer

The answer of Should a user be allowed to enter...

Question 11

Which MySQL command do you use to define 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 12

When creating a SQL table, _____.

Accepted Answer

A)   add the NOT NULL clause for the columns that cannot contain null values
B)   you must add PRIMARY KEY NOT NULL for the primary key column(s) 
C)   remember that the default behavior for table columns is to reject null values
D)   include only those columns for which data will always be known and available

Question 13

Which SQL command is used to view the data in a table?

Accepted Answer

A)   VIEW
B)   SELECT
C)   SHOW
D)   DISPLAY

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Question 16

What special value is used in SQL to represent cases in which an actual value is unknown, unavailable, or not applicable?

Accepted Answer

A)   varchar
B)   empty
C)   not null
D)   null

Question 17

In SQL Server, you can execute the sp_columns command to list all the columns in a table.

Accepted Answer

A) True 
 B)False

Question 18

Pete would like to set up a database called BAKE_SALE_FUNDRAISER so that he can begin defining the objects within it. Which MySQL command should Pete use?

Accepted Answer

A)   CREATE DATABASE: BAKE_SALE_FUNDRAISER
B)   CREATE DATABASE BAKE_SALE_FUNDRAISER;
C)   ACTIVATE DATABASE BAKE_SALE_FUNDRAISER;
D)   ACTIVATE DATABASE: BAKE_SALE_FUNDRAISER

Question 19

Which of the following SQL commands changes the value in the column LAST_NAME within the row containing a REP_ID of 007?

Accepted Answer

A)   UPDATE SALES_REP SET LAST_NAME = 'Bond' WHERE REP_ID = '007';
B)   CHANGE SALES_REP LAST_NAME = 'Bond' WHERE REP_ID = '007';
C)   REPLACE SALES_REP LAST_NAME = 'Bond' WHERE REP_ID = '007';
D)   INSERT SALES_REP SET LAST_NAME = 'Bond' WHERE REP_ID = '007';

Question 20

Jesse has written some commands in MySQL Workbench that he expects to run regularly, and he would like to save them for future use. What should he do next?

Accepted Answer

A)   copy and paste the query into a .txt file
B)   click on Query, then select Execute
C)   click on File, then Save Script As
D)   select a script from within his file system and click Open

Exam 3: Creating Tables

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

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

Why does the POSTAL_CODE column in the REP table of the KimTay database have a data type of CHAR, if a postal code is made up of numbers?

It is recommended that table names be limited to _____.

A text file with a .sql extension that contains SQL commands is a _____.

SQL was developed in the mid-____.

Laura is adding a new product to the CANDY table, which has columns for the product ID, name, description, and price. Price is a dollars and cents value; the others are strings of characters. Which SQL command should Laura use to add the row for the new product?

To list all the columns in a table and their properties in MySQL, use the LIST COLUMNS command.

Which data type should you use for columns that contain letters and special characters or numbers that will not be used in calculations?

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

Which MySQL command do you use to define a table's structure by listing its columns, data types, and column lengths?

When creating a SQL table, _____.

Which SQL command is used to view the data in a table?

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

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

What special value is used in SQL to represent cases in which an actual value is unknown, unavailable, or not applicable?

In SQL Server, you can execute the sp_columns command to list all the columns in a table.

Pete would like to set up a database called BAKE_SALE_FUNDRAISER so that he can begin defining the objects within it. Which MySQL command should Pete use?

Which of the following SQL commands changes the value in the column LAST_NAME within the row containing a REP_ID of 007?

Jesse has written some commands in MySQL Workbench that he expects to run regularly, and he would like to save them for future use. What should he do next?