Quiz 8 - Advanced SQL

12/14/24, 2:01 AM Quiz: Advanced SQL: COMP 440 DATABASE DESIGN - (17042-FA2024) Quiz: Advanced SQL Due Nov 15 at 11:59pm Points 15 Questions 15 Time Limit 30 Minutes Allowed Attempts 2 Take the Quiz Again Attempt History LATEST Attempt Time Score Attempt 1 17 minutes 15 out of 15  Correct answers are hidden. Score for this attempt: 15 out of 15 Submitted Nov 15 at 2:41pm This attempt took 17 minutes.  Question 1 1 / 1 pts Authentication is the process the DBMS uses to verify that only registered users access the database. True Correct. Users must log on to the RDBMS using a user ID and a password created by the database administrator. False  Question 2 1 / 1 pts https://canvas.csun.edu/courses/154575/quizzes/571411 1/6 12/14/24, 2:01 AM Quiz: Advanced SQL: COMP 440 DATABASE DESIGN - (17042-FA2024) The format SMALLINT is a common SQL data type of ____. date character varchar numeric Correct. The numeric data type can have a format of number, integer, smallint, and also decimal.  Question 3 1 / 1 pts Inserted data will, in most cases, place a value that is meant for the primary key column into the ____ part of the VALUES statement. second first Correct. The values are usually inserted in order of the table, and the primary key would reside in the first column. NO NULL last  Question 4 1 / 1 pts You must first enter the command ALTER TABLE in order to issue a MODIFY command to change a columns datatype. True Correct. You must first specify which table to alter and then provide the associate MODIFY command to change a column datatype. False  Question 5 1 / 1 pts Which SQL command would a database administrator use to delete a whole row from a VENDOR table whose ID is BET-345? https://canvas.csun.edu/courses/154575/quizzes/571411 2/6 12/14/24, 2:01 AM Quiz: Advanced SQL: COMP 440 DATABASE DESIGN - (17042-FA2024) DELETE ROW FROM PRODUCT WHERE V_CODE = 'BET-345'; DELETE FROM PRODUCT WHERE V_CODE = 'BET-345'; Correct. The command DELETE FROM PRODUCT WHERE V_CODE = 'BET-345'; uses the correct syntax to delete an entire row that references the specific VENDOR ID. DELETE ROW WHERE V_CODE = 'BET-345'; DELETE * FROM PRODUCT WHERE V_CODE = 'BET-345';  Question 6 1 / 1 pts An administrator can create an implicit cursor to count the number (W_NUM) of products (or P_CODE) between $10 (or W_P1) and $50 (or W_P2) when gathering information from the P_PRICE column of the PRODUCT table the line ____, for example. DECLARE PROD_CURSOR CURSOR FOR SELECT P_CODE from PRODUCT W_NUM = W_P1 + W_P2 SELECT COUNT (P_CODE) INTO W_NUM FROM PRODUCT Correct. The command SELECT COUNT (P_CODE) INTO W_NUM FROM PRODUCT is a singular example of how an implicit cursor in procedural SQL uses the SELECT statement to return only one value. INSERT INTO NEWTAB VALUES (W_NUM, W_P1, W_P2)  Question 7 1 / 1 pts An administrator needs to ALTER a table called PRODUCT so that its P_PRICE column can hold a value like common numbers on a price tag. Which command would the administrator most likely use to update this column's data type? MODIFY P_PRICE DECIMAL(9); MODIFY P_PRICE DECIMAL(9,2); Correct. The command MODIFY P_PRICE DECIMAL(9,2); allows for two decimal places like you would see on a price tag like 4.99, for example. MODIFY P_PRICE DECIMAL(9,1); https://canvas.csun.edu/courses/154575/quizzes/571411 3/6 12/14/24, 2:01 AM Quiz: Advanced SQL: COMP 440 DATABASE DESIGN - (17042-FA2024) MODIFY P_PRICE DECIMAL(9,0);  Question 8 1 / 1 pts A schema is a logical group of database objects like ____ and indexes that are related to each other. numerics dictionaries tables Correct. Schema is a logical group of database objects, such as tables and indexes, that are related to each other. characters  Question 9 1 / 1 pts A subquery will automatically overwrite an existing table if it has the same name. True False Correct. Microsoft Access will ask to delete the existing table first before creating a new table with the same name.  Question 10 1 / 1 pts When creating a child table, the ____ SQL keyword should be added to properly connect it back to the parent table. FOREIGN KEY Correct. The FOREIGN KEY command will reference the primary key of the parent table. CONSTRAINT UNIQUE PRIMARY KEY https://canvas.csun.edu/courses/154575/quizzes/571411 4/6 12/14/24, 2:01 AM Quiz: Advanced SQL: COMP 440 DATABASE DESIGN - (17042-FA2024)  Question 11 1 / 1 pts A view is a virtual table based on a SELECT query. True Correct. A view is a virtual table based on a SELECT query. False  Question 12 1 / 1 pts Which of the following is NOT required in terms of syntax when a user wants to copy data from one table to another? Use the SELECT command to select the columns. Use the FROM command to reference the original table. Use the INSERT INTO command to reference the new table. Use the * command to select all values. Correct. The * command selects all values so it is not needed. The column selection will inherently know which values to copy from those columns.  Question 13 1 / 1 pts The SQL command, UPDATE, successfully removes a table row. True False Correct. The DELETE SQL statement deletes a table row.  https://canvas.csun.edu/courses/154575/quizzes/571411 5/6 12/14/24, 2:01 AM Quiz: Advanced SQL: COMP 440 DATABASE DESIGN - (17042-FA2024) Question 14 1 / 1 pts SQL supports the conditional execution of procedures (IF-THEN-ELSE statements) that are typically supported by a programming language. True False Correct. Most RDBMS vendors create programming language extensions, such as procedural SQL, to fulfill flow-control procedural programming structures like IF-THEN-ELSE.  Question 15 1 / 1 pts The database administrator must add a constraint to the PART table so a PART's price is never entered as a negative number. The administrator can enter the SQL statement ____ to satisfy the constraint command. ALTER TABLE PART ADD CHECK (PART_PRICE >= 0); Correct. The command ALTER TABLE PART ADD CHECK (PART_PRICE >= 0); ensures the number cannot be negative, but it can be either 0 or greater than 0.   ALTER TABLE PART ADD CHECK (PART_PRICE /= 0); ALTER TABLE PART ADD CHECK (PART_PRICE =< 0); ALTER TABLE PART ADD CHECK (PART_PRICE > 0); Quiz Score: 15 out of 15 https://canvas.csun.edu/courses/154575/quizzes/571411 6/6