Question 1

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

Accepted Answer

A)   VIEW
B)   SELECT
C)   SHOW
D)   DISPLAYE) All of the above
F) None of the above

Question 2

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 3

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)   nullE) A) and B)
F) B) and D)

Question 4

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 TABLEE) B) and C)
F) All of the above

Question 5

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

Accepted Answer

A) True 
 B)False  True

Question 6

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 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) ;E) C) and D)
F) A) and C)

Question 8

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 fileE) A) and C)
F) A) and D)

Question 9

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_FUNDRAISERE) B) and C)
F) A) and B)

Question 10

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 11

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

Accepted Answer

No. The primary key should uni...

Question 12

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';E) A) and D)
F) None of the above

Question 13

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 availableE) A) and B)
F) B) and C)

Question 14

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

Accepted Answer

A)   TBL_1
B)   2_TBL
C)   TBL 3
D)   4 tblE) B) and C)
F) None of the above A

Question 15

It is recommended that table names be limited to _____.

Accepted Answer

A)   12 characters
B)   14 characters
C)   24 characters
D)   30 charactersE) All of the above
F) A) and C)

Question 16

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)   STRINGE) None of the above
F) A) and B)

Question 17

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 18

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)   slashE) B) and D)
F) A) and D)

Question 19

SQL was developed in the mid-____.

Accepted Answer

A)   1950s
B)   1970s
C)   1990s
D)   2000sE) A) and B)
F) None of the above

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 OpenE) A) and D)
F) B) and C)

Exam 3: Creating Tables

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

Correct AnswerverifiedShow Answer

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?

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedTrue

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedNo. The primary key should uni...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

When creating a SQL table, _____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA

It is recommended that table names be limited to _____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

SQL was developed in the mid-____.

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
No. The primary key should uni...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified