- Description
- Full Document
Charles Sturt University
Database Systems (ITC423)
CH7
True/False
Indicate whether the statement is true or false.
____ 1. All SQL commands must be issued on a single line.
____ 2. Oracle users can use the Access QBE (query by example) query generator.
____ 3. Most SQL implementations yield case-insensitive searches.
____ 4. Because COUNT is designed to tally the number of non-null “values” of an
attribute, it is used in conjunction with the DISTINCT clause.
Multiple Choice
Identify the choice that best completes the statement or answers the question.
____ 5. The SQL command that lets you select attributes from rows in one or more
tables or views is ____.
a. INSERT c. COMMIT
b. SELECT d. UPDATE
____ 6. SQL character data format is/are ____.
a. CHAR and
VARCHAR
c. Alphanumeric
b. VARCHAR only d. CHAR only
____ 7. In Oracle, the ____ command is used to change the display for a column, for
example to place a $ in front of a numeric value.
a. DISPLAY c. CHAR
b. FORMAT
d.
CONVERT
____ 8. The ____ command is used to restore the table’s contents to their previous
values.
a. COMMIT;
RESTORE;
c. COMMIT;
ROLLBACK;
b. COMMIT;
BACKUP;
d. ROLLBACK;
____ 9. Before the COMMIT command is used, you can retrieve deleted records by
using the ____ command.
a. UNDELETE c. UNSAVE
b. ROLLBACK d. BACK
____ 10. To delete a row from the PRODUCT table, use the ____ command.
a. KILL c. COMMIT
b. DELETE d. ERASE
____ 11. When you issue the DELETE FROM tablename command without specifying
a where condition ____.
a. No rows will be
deleted.
c. The last row will be
deleted.
b. The first row will be
deleted.
d. All rows will be
deleted.
____ 12. The ____ query will output the table contents when the value of V_CODE is
equal to 21344.
a. SELECT P_DESCRIPT, P_INDATE,
P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE <> 21344;
b. SELECT P_DESCRIP
PREVIEW
