Question 1

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?
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

Accepted Answer

Jesse should click on File, then select "Save Script As" to save his commands for future use. This option allows him to save the script in a format that can be easily accessed and executed within MySQL Workbench or other SQL editors.

Question 2

Which SQL command is used to view the data in a table?
A) VIEW
B) SELECT
C) SHOW
D) DISPLAY

Accepted Answer

The SELECT command is used to view or retrieve data from a table in SQL.

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

The answer of Why does the POSTAL_CODE column in the...

Question 4

Which statement about the command used to view all columns and rows in a database table is correct?
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.

Accepted Answer

The command to view all columns and rows in a database table, typically "SELECT * FROM table_name;", is essentially the same across different SQL database systems such as MySQL, Oracle, and SQL Server. This demonstrates the standardized nature of SQL commands across different relational database management systems.

Question 5

Which SQL command is used to add rows to a table once its structure has been defined?
A) ADD
B) SELECT
C) INSERT
D) CREATE

Accepted Answer

The INSERT SQL command is used to add rows to a table once its structure has been defined.

Question 6

What are a script file and a script repository?

Accepted Answer

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

Question 7

What special value is used in SQL to represent cases in which an actual value is unknown, unavailable, or not applicable?
A) varchar
B) empty
C) not null
D) null

Accepted Answer

The special value used in SQL to represent cases where an actual value is unknown, unavailable, or not applicable is "null".

Question 8

In MySQL, Philip can use the command SELECT* FROM VACATION_PACKAGES; to _____.
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

Accepted Answer

The command SELECT * FROM VACATION_PACKAGES; is used to display all rows and columns from the table VACATION_PACKAGES.

Question 9

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 10

How can you correct errors in data?

Accepted Answer

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

Question 11

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?
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);

Accepted Answer

The correct SQL syntax for inserting a new row into a table is "INSERT INTO table_name VALUES (value1, value2, ...);". Option D correctly follows this syntax, including using quotes around string values and not using quotes around numeric values.

Question 12

When you add a row for which you have incomplete information to a SQL table, _____.
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

Accepted Answer

When adding a row with incomplete information, you can use the INSERT command and specify only the columns for which you have data, allowing the other columns to take their default values or remain NULL if allowed.

Question 13

Which statement about changing the default database is FALSE?
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.

Accepted Answer

The statement about there being two steps to choosing a database to use, involving changing the default and activation, is false. In reality, to select a database for use, you simply execute the USE command followed by the database's name, which both selects and activates the database for use. There is no separate "activation" step.

Question 14

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?
A) CREATE TABLE COFFEE;
B) SELECT COFFEE;
C) SHOW COFFEE;
D) DESCRIBE COFFEE;

Accepted Answer

The correct command to examine the structure of a table, including column names, data types, and whether null values are accepted, is "DESCRIBE tablename;". Therefore, "DESCRIBE COFFEE;" is the right choice for Janice to view the structure of the COFFEE table.

Question 15

When creating a SQL table, _____.
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

Accepted Answer

The NOT NULL clause is used to ensure that a column cannot contain null values.

Quiz 3: Creating Tables

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?

Which SQL command is used to view the data in 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?

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

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

What are a script file and a script repository?

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

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

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

How can you correct errors in data?

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?

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

Which statement about changing the default database is FALSE?

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?

When creating a SQL table, _____.