20, 30-40 question multiple choice and some fill in the blank answers
Question 1 1 / 1 pts The COUNT function is designed to tally the number of non-null "values" of an attribute, and is often used in conjunction with the DISTINCT clause. True False Question 2 1 / 1 pts Mathematical operators cannot be used to place restrictions on character-based attributes. True False Question 3 1 / 1 pts SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT. True False Question 4 1 / 1 pts To list the contents of a table, you must use the DISPLAY command. True False Question 5 1 / 1 pts String comparisons are made from left to right. True False Question 6 1 / 1 pts The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE, and V_CONTACT fields from the VENDOR table where the values of V_CODE match is ____________. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <> VENDOR.V_CODE; SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE; SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <= vendor.v_code;="" ="" select="" p_descript,="" p_price,="" v_name,="" v_contact,="" v_areacode,="" v_phone="" from="" product,="" vendor="" where="" product.v_code=""> VENDOR.V_CODE; Question 7 1 / 1 pts Which of the following queries uses the correct SQL syntax to list the table contents for either V_CODE = 21344 or V_CODE = 24288? SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE <= 24288;="" ="" select="" p_descript,="" p_indate,="" p_price,="" v_code="" from="" product="" where="" v_code="21344" or="" v_code=""> 24288; SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE > 24288; SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE = 24288; Question 8 1 / 1 pts The special operator used to check whether a subquery returns any rows is ____________. BETWEEN EXISTS LIKE IN Question 9 1 / 1 pts UPDATE tablename ***** [WHERE conditionlist]; The __________ command replaces the ***** in the syntax of the UPDATE command, shown above. SET columnname = expression columnname = expression expression = columnname LET columnname = expression Question 10 1 / 1 pts To remove a row from the PRODUCT table, one must use the __________ command. COMMIT DELETE ERASE KILL Question 11 1 / 1 pts All changes in a table structure are made using the _____________ command, followed by a keyword that produces the specific changes a user wants to make. ALTER TABLE UPDATE TABLE COMMIT TABLE ROLLBACK TABLE Question 12 1 / 1 pts Some RDBMSs, such as Oracle, automatically _________ data changes when issuing data definition commands. COMMIT ROLLBACK UNSAVE UPDATE Question 13 1 / 1 pts According to the rules of precedence, which of the following computations should be completed first? Performing additions and subtractions Performing multiplications and divisions Performing operations within parentheses Performing power operations IncorrectQuestion 14 0 / 1 pts Which of the following queries will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand and display the results in a column labeled TOTVALUE? SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE AS TOTVALUE FROM PRODUCT; SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICE AS TOTVALUE FROM PRODUCT; SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICE AS TOTVALUE FROM PRODUCT; SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICE AS TOTVALUE FROM PRODUCT; Question 15 1 / 1 pts The SQL aggregate function that gives the number of rows containing non-null values for a given column is ____________. COUNT MIN MAX SUM Question 16 1 / 1 pts Which of the following queries will output the table contents when the value of P_PRICE is less than or equal to 10? SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE P_PRICE <> 10; SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE P_PRICE <= 10;="" ="" select="" p_descript,="" p_indate,="" p_price,="" v_code="" from="" product="" where="" p_price=""> 10; SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE P_PRICE = 10; Question 17 1 / 1 pts Which of the following queries will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand? SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICE FROM PRODUCT; SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICE FROM PRODUCT; SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE FROM PRODUCT; SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICE FROM PRODUCT; Question 18 1 / 1 pts When a user issues the DELETE FROM tablename command without specifying a WHERE condition, ___________. no rows will be deleted the first row will be deleted the last row will be deleted all rows will be deleted Question 19 1 / 1 pts The SQL aggregate function that gives the arithmetic mean for a specific column is ______________. COUNT AVG MAX SUM Question 20 1 / 1 pts A table can be deleted from the database by using the _________ command. DROP TABLE DELETE TABLE MODIFY TABLE ERASE TABLE Question 21 1 / 1 pts An example of a command a user would use when making changes to a PRODUCT table is _____________. CHANGE PRODUCT SET P_INDATE = ‘18-JAN-2004’ WHERE P_CODE = ‘13-Q2/P2’; ROLLBACK PRODUCT SET P_INDATE = ‘18-JAN-2004’ WHERE P_CODE = ‘13-Q2/P2’; EDIT PRODUCT SET P_INDATE = ‘18-JAN-2004’ WHERE P_CODE = ‘13-Q2/P2’; UPDATE PRODUCT SET P_INDATE = ‘18-JAN-2004’ WHERE P_CODE = ‘13-Q2/P2’; Question 22 1 / 1 pts The SQL command that allows a user to permanently save data changes is _____________. INSERT SELECT COMMIT UPDATE Question 23 1 / 1 pts The special operator used to check whether an attribute value matches a given string pattern is ___________. BETWEEN IS NULL LIKE IN Question 24 1 / 1 pts The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE and V_CONTACT fields from the VENDOR table, where the values of V_CODE match and the output is ordered by the price is _____________. SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME, VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <> VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE; SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME, VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE => VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE; SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME, VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <= vendor.v_code;="" order="" by="" product.p_price;="" ="" select="" product.p_descript, ="" product.p_price, ="" vendor.v_name,="" vendor.v_contact, ="" vendor.v_areacode, ="" vendor.v_phone="" from="" product,="" vendor="" where="" product.v_code="VENDOR.V_CODE;" order="" by="" product.p_price;="" ="" question="" 25="" 1 /="" 1 pts="" which="" of="" the="" following="" queries="" will="" output="" the="" table="" contents="" when="" the="" value="" of="" v_code="" is="" not="" equal="" to="" 21344?="" ="" select="" p_descript,="" p_indate,="" p_price,="" v_code="" from="" product="" where="" v_code=""><> 21344; SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <= 21344;="" ="" select="" p_descript,="" p_indate,="" p_price,="" v_code="" from="" product="" where="" v_code="21344;" ="" select="" p_descript,="" p_indate,="" p_price,="" v_code="" from="" product="" where="" v_code=""> 21344; Question 26 1 / 1 pts In Oracle, the __________ command is used to change the display for a column, for example, to place a $ in front of a numeric value. DISPLAY FORMAT CHAR CONVERT IncorrectQuestion 27 0 / 1 pts The ____________ command is used with the ALTER TABLE command to modify the table by deleting a column. DROP REMOVE DELETE ERASE IncorrectQuestion 28 0 / 1 pts The SQL data manipulation command HAVING: restricts the selection of rows based on a conditional expression. restricts the selection of grouped rows based on a condition. modifies an attribute’s values in one or more table’s rows. groups the selected rows based on one or more attributes. Question 29 1 / 1 pts The ____________ command would be used to delete the table row where the P_CODE is ‘BRT-345’. DELETE FROM PRODUCT WHERE P_CODE = ‘BRT-345’; REMOVE FROM PRODUCT WHERE P_CODE = ‘BRT-345’; ERASE FROM PRODUCT WHERE P_CODE = ‘BRT-345’; ROLLBACK FROM PRODUCT WHERE P_CODE = ‘BRT-345’; Question 30 1 / 1 pts The SQL aggregate function that gives the total of all values for a selected attribute in a given column is ______________. COUNT MIN MAX SUM Question 31 1 / 1 pts The SQL query to output the contents of the EMPLOYEE table sorted by last name, first name, and initial is _____________. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE LIST BY EMP_LNAME, EMP_FNAME, EMP_INITIAL; SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL; SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE DISPLAY BY EMP_LNAME, EMP_FNAME, EMP_INITIAL; SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE SEQUENCE BY EMP_LNAME, EMP_FNAME, EMP_INITIAL; Question 32 1 / 1 pts The SQL command that modifies an attribute’s values in one or more table’s rows is __________. INSERT SELECT COMMIT UPDATE Question 33 1 / 1 pts In a 1:M relationship, a user must always create the table for the __________ side first. Question 34 1 / 1 pts _______________ is the process the DBMS uses to verify that only registered users access the database. Question 35 1 / 1 pts With the exception of the database __________ process, most RDBMS vendors use SQL that deviates little from the ANSI standard SQL. IncorrectQuestion 36 0 / 1 pts In an INSERT command, a user can indicate just the attributes that have required values by listing the __________ inside parentheses after the table name. Question 37 1 / 1 pts DATE() and SYSDATE are special functions that return today’s date in MS Access and ___________, respectively. Question 38 1 / 1 pts If integer values are relatively small, _________ must be used instead of INT. Question 39 1 / 1 pts U.S. state abbreviations are always two characters, so ________ (2) is a logical choice for the data type representing a state column. Question 40 1 / 1 pts The basic SQL vocabulary has fewer than _________ words. 1 authenticat creation names oracle smallint char 100