Lab 5 - class work PDF

Preview

Summary

class work...

Description

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