Which data type should you use for columns that contain letters and special characters or numbers that will not be used in calculations? a) CHAR b) STRING c) TEXT d) CHARACTER
When you add a row for which you have incomplete information to a SQL table, a) you use the INSERT command and name the columns for which you are entering data b) you use the INSERT command and enter a value of null for the columns without data C) the DBMS will always reject the new row the first time you execute the command d) you must change the table structure so that all rows are m?ked as NOT NULL
When a script file contains more than one command, each command must end with a(n) a) period b) apostrophe C) semicolon d) colon
SQL was developed in the mid- a) \( 1950 \mathrm{~s} \) b) \( 1970 \mathrm{~s} \) c) \( 2000 \mathrm{~s} \) d) \( 1990 \mathrm{~s} \)
Which SQL command is used to view the data in a table? a) SELECT b) DISPLAY c) SHOW d) VIEW
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 IGNORE INTO CANDY VALUES (534, Cordial fudge, Dark chocolate fudge squares topped with a cherry swirl, \( 5.85 \) ); c) INSERT VALUES (534', 'Cordial fudge', 'Dark chocolate fudge squares topped with a cherry swirl', 5.85) INTO CANDY: d) INSERT IGNORE INTO CANDY VALUES (534.' 'Cordial fudge', 'Dark chocolate fudge squares topped with a cherry swirl, \( 5.85 \) ):
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. a) slash b) single quote c) double quote d) asterisk
You indicate the end of a SQL command by typing a a) comma b) column C) semicolon d) period
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) Tables created in MySQL are added to the default database. c) To activate a database, you execute the USE command followed by the database's name. d) The MySQL command USE SPIDERS; makes SPIDERS the default database.
Which statement about the command used to view all columns and rows in a database table is correct? a) The command used in SQL Server is different from that used in MySQL and Oracle. b) When using Oracle, the semicolon in the MySQL command must be replaced with a slash. C) The command contains two symbols: an colon and a question mark. d) The same simple version of this command can be used in MySQL, Oracle, and SQL Server.