Experiencing Science Lab Exam

Multiple Choice (1 point each question). 1. Which of the following commands is used to add rows to a table? a. ADD b. UPDATE c. INSERT d. ENTER 2. Which of the following commands is used to modify existing data in a table? a. ADD b. UPDATE c. INSERT d. MODIFY 3. Which of the following commands is used to remove rows from a table? a. DELETE b. DROP c. REMOVE d. MODIFY 4. Which command is used to prevent other users from making changes to a table? a. COMMIT b. COMMIT TABLE c. BLOCK d. LOCK TABLE 5. Which keyword permanently saves changed data in a table? a. COMMIT b. SAVE c. UPDATE d. ADD 6. Which keywords create a shared lock on a table to prevent another user from making changes to data in specified columns? a. SELECT...LOCK b. SELECT...COMMIT c. SELECT...FOR UPDATE d. SELECT...FOR CHANGE 7. Which of the following is a valid statement? a. When rows are added to a table, the column names can be omitted if an entry is only being made into the first column. b. When rows are added to a table, the column names can be omitted if the values are listed in the same order as the columns are listed in the table. c. If rows are being added to a table with the UPDATE command, an entry must be made into each column contained in the table. d. none of the above 8. Which of the following will allow a user to enter a NULL value using the INSERT command? a. Omit the column from the column list in the INSERT INTO clause. b. Substitute two single quotation marks in the VALUES clause in the position of the column that is to be assigned the NULL value. c. Use the NULL keyword. d. all of the above 9. When data is being entered into a VARCHAR2 or CHAR column using the INSERT command, the data will be stored in ____. a. upper-case characters b. lower-case characters c. the default case setting for the table d. the same case used in the INSERT command 10. Use the ____ keyword to enter the computer's date as a data value in the INSERT command. a. SYSTEMDATE b. DATE c. SYSDATE d. COMPDATE 11. Which of the following keywords is omitted from the INSERT command if the data to be added to a table is already contained in another table? a. INSERT b. INTO c. VALUES d. none of the above 12. Which of the following is not a valid SQL command? a. INSERT INTO acctmantable SELECT amid, amname, amedate, region FROM acctmanager WHERE amedate <= SYSDATE; b. INSERT INTO acctmantable (SELECT amid, amname, amedate, region FROM acctmanager WHERE amedate <= SYSDATE); c. INSERT INTO acctmantable AS (SELECT amid, amname, amedate, region FROM acctmanager WHERE amedate <= SYSDATE); d. none of the above 13. The column to be updated by the UPDATE command is specified in the ____ clause. a. UPDATE b. SET c. WHERE d. COL 14. The row(s) to be updated by the UPDATE command is specified by the ____ clause. a. UPDATE b. SET c. WHERE d. COL 15. Which of the following clauses of the UPDATE command is optional? a. UPDATE b. SET c. WHERE d. none of the above 16. Which of the following statements about the UPDATE command is incorrect? a. The UPDATE clause identifies the table containing the record(s) to be changed. b. The SET clause is used to identify the column(s) to be changed, and the new value(s) to be assigned to that column. c. The mandatory WHERE clause identifies the specific row(s) to be changed by the UPDATE command. d. The optional WHERE clause identifies the specific row(s) to be changed by the UPDATE command. 17. Which of the following is not a valid SQL command? a. UPDATE acctmanager SET amedate = SYSDATE WHERE amid = 'J500'; b. UPDATE acctmanager SET amname = UPPER(amname); c. UPDATE acctmanager SET amname = UPPER(amname) WHERE amid = 'J500'; d. UPDATE acctmanager WHERE amid = 'J500'; 18. Which of the following statements about COMMIT and ROLLBACK commands is incorrect? a. All DML commands (INSERT, UPDATE, DELETE) are explicitly committed and cannot be rolled back. b. All DDL commands (CREATE, TRUNCATE, ALTER TABLE) are explicitly committed and cannot be rolled back. c. A ROLLBACK command will reverse all DDL operations performed since the last COMMIT was performed. d. all of the above 19. The ____ command will prevent two users from trying to make changes to the same table at the same time. a. SHARED LOCK b. EXCLUSIVE LOCK c. LOCK TABLE d. TABLE LOCK 20. Which of the following types of locks permits other users access to unlocked portions of a table? a. shared lock b. table lock c. exclusive lock d. partition lock 21. The ____ command can be used to view the contents of a record when it is anticipated that the record will need to be modified. It places a shared lock on the record(s) to be changed and prevents any other user from acquiring a lock on the same record(s). a. SELECT...LOCK TABLE b. COMMIT...LOCK TABLE c. SELECT...FOR UPDATE d. COMMIT...FOR UPDATE 22. A(n) ____ lock will prevent any DDL operations from being performed on the locked table. a. shared b. exclusive c. partial d. partitioned Contents of the PROMOTION table 23. Based on the contents of the PROMOTION table, which of the following will correctly change the value assigned to the MAXRETAIL column for Free Shipping to 75.00? a. INSERT INTO promotion (maxretail) VALUES (75) WHERE gift = 'FREE SHIPPING'; b. UPDATE promotion (maxretail) SET = 75 WHERE gift = 'FREE SHIPPING'; c. UPDATE promotion SET maxretail = 75 WHERE gift = 'FREE SHIPPING'; d. none of the above 24. Based on the contents of the PROMOTION table, which of the following commands will delete only the row for the Free Bookmark from the table? a. DELETE FROM promotion; b. DELETE gift FROM promotion; c. DELETE gift FROM promotion WHERE gift = 'BOOKMARKER'; d. DELETE FROM promotion WHERE gift = 'BOOKMARKER'; 25. Which of the following SQL statements will insert a new row into the PROMOTION table? a. INSERT INTO promotion (gift, minretail, maxretail) VALUES (FREE BOOK, 75.01, 89.99); b. INSERT INTO promotion (gift, minretail, maxretail) VALUES ('FREE BOOK', 75.01, 89.99); c. INSERT INTO promotion VALUES (FREE BOOK, 75.01, 89.99); d. both a and c 26.f a new row is added to the PROMOTION table, which of the following will make the change permanent? I a. COMMIT; b. UPDATE; c. ROLLBACK; d. The change is permanent when the command is executed. Contents of the PUBLISHER table 27. Which of the following commands will delete only publisher 4 from the PUBLISHER table? a. DELETE FROM publisher; b. DELETE pubid = 4 FROM publisher; c. DROP FROM publisher WHERE pubid = 4; d. DELETE FROM publisher WHERE pubid = 4; 28. Based on the contents of the PUBLISHER table, which of the following SQL statements will change the phone number for Printing Is Us to 800-714-8321? a. UPDATE publisher REPLACE phone WITH '800-714-8321' WHERE pubid = 1; b. UPDATE publisher REPLACE phone = '800-714-8321' WHERE pubid = 1; c. UPDATE publisher SET phone = '800-714-8321' WHERE pubid = 1; d. none of the above 29. Based on the contents of the PUBLISHER table, which of the following will add a new record to the table? a. INSERT INTO publisher VALUES ('BOOKS MADE CHEAP', '800-111-2222'); b. INSERT INTO publisher (pubid, name) VALUES (6, 'BOOKS MADE CHEAP'); c. UPDATE publisher VALUES ('BOOKS MADE CHEAP', '800-111-2222'); d. UPDATE publisher (pubid, name) VALUES (6, 'BOOKS MADE CHEAP'); 30. If a column named SAL_PCT is to be defined to ensure a value of 100 is input if a NULL value is provided when a new row is inserted, which column definition should be used? a. SAL_PCT NULL 100 DEFAULT. b. c. d. SAL_PCT DEFAULT ON NULL 100. SAL_PCT DEFAULT 100. SAL_PCT ON NULL 100.