CIS240 Week 4

1. Which application was used to paste SQL commands to and from?
Excel
Paintbrush
Notepad
Solitaire

2. If you want to change the order-of-operations for a query, what can you do to make sure that a condition is met first?
Put it in parenthesis
type "clear all"
set=relevant
OderID=01

3. Which of the following is an incorrect example of SQL syntax?
INSERT INTO careers VALUES ('two', 'doctor', 711);
INSERT INTO carstable VALUES (1, 911, 9019);
INSERT INTO cars VALUES (54, 'truck', TO_DATE('07/22/02', 'MM/DD/YY'), 4);
INSERT INTO cars VALUES (101, 'Volvo', 'Mom's station wagon');

4. Without exiting, how can you save your settings immediately?
COMMIT;
SAVE;
DROP;
COTTON SAUSAGE;

5. Whoops! You made a mistake, how can you undo the changes (to the last savepoint)?
UNDO
ROLLBACK
CTRL-ALT-DEL
Notify management, make triplicate copies of PTS reports.

6. Which operator means not equal to?
< >
> =
Not equal
0

7.

8.

9.

10.

11.

12.

13.

14.

15.