True/False
Indicate whether the statement is true or false.
____ 1. A character is a basic unit of data and can consist of a number, letter, or special symbol.
____ 2. Partial dependency can only exist if the data is uniquely identified by a composite primary key.
____ 3. There are six editions available for Oracle10g.
____ 4. The DESCRIBE command is used to view data in a table.
____ 5. The asterisk symbol (*) can be used in a SELECT statement to indicate that all rows in the table should be displayed in the results.
____ 6. The INTERVAL datatype can be used to identify a specific interval, or amount, of time.
____ 7. When a column is deleted, the deletion is permanent.
____ 8. You cannot delete the last column in a table.
____ 9. The DELETE TABLE command can be used to remove a table from a database.
____ 10. When two conditions are joined by the AND logical operator, both of the conditions must be evaluated as FALSE to be included in the query results.
Multiple Choice
Identify the choice that best completes the statement or answers the question.
____ 11. Which of the following usually correlates to a primary key in another table?
a.
|
transitive dependency
|
c.
|
foreign key
|
b.
|
composite primary key
|
d.
|
partial dependency
|
____ 12. Which of the following types of constraints is used to enforce referential integrity?
a.
|
UNIQUE
|
c.
|
FOREIGN KEY
|
b.
|
REFERS
|
d.
|
CHECK
|
____ 13. In the USER_CONSTRAINTS view, the value displayed in the CONSTRAINT_TYPE column will be a(n) ____ for a CHECK constraint.
a.
|
C
|
c.
|
U
|
b.
|
K
|
d.
|
R
|
Structure of the PROMOTION table
____ 14. Which of the following commands will add a UNIQUE constraint to the MINRETAIL column of the PROMOTION table?
a.
|
ALTER TABLE promotion
ADD CONSTRAINT orderitems_minretail_uk UNIQUE (minretail);
|
b.
|
ALTER TABLE promotion
MODIFY UNIQUE (minretail);
|
c.
|
ALTER TABLE promotion
ADD UNIQUE minretail;
|
d.
|
ALTER TABLE promotion
MODIFY minretail;
|
____ 15. 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 DML operations performed since the last COMMIT was performed.
|
d.
|
all of the above
|
____ 16. Which of the following is a correct statement?
a.
|
A PUBLIC synonym allows any user to access the specified table.
|
b.
|
A PUBLIC synonym can be referenced by any user.
|
c.
|
A PUBLIC synonym can only be deleted by the user that created the synonym.
|
d.
|
all of the above
|
____ 17. Which of the following operators would be most appropriate to determine whether or not the retail price of a book is at least $24.00?
a.
|
LIKE
|
c.
|
>
|
b.
|
BETWEEN
|
d.
|
>=
|
____ 18. Which of the following is a valid comparison operator?
a.
|
!=
|
c.
|
^=
|
b.
|
IN
|
d.
|
all of the above
|
____ 19. Which of the following search conditions can be used to identify records that do not have data stored in a column named ColB?
a.
|
ColB = NULL
|
c.
|
ColB IS NULL
|
b.
|
ColB IS NOT NULL
|
d.
|
ColB = ' '
|
Contents of the ORDERS table
____ 20. Which of the following SQL statements will display all orders contained in the ORDERS table that have been shipped to the customer?
a.
|
SELECT * FROM orders WHERE shipdate = 'NOT NULL';
|
b.
|
SELECT * FROM orders WHERE shipdate = NOT NULL;
|
c.
|
SELECT * FROM orders WHERE shipdate IS NULL;
|
d.
|
SELECT * FROM orders WHERE shipdate IS NOT NULL;
|
