1.

Based on the given table Stocks type the possible out if the following sql statement is executed. What is the maximum on hand from parts when this SQL statement is executed? SELECT MAX(ONHAND) FROM PARTS;

Select one:

a. 10

b. 30

c. 50

d. 0

2.

Based on the given table Stocks type the possible out if the following sql statement is executed. What is the minimum warehouse from parts when this SQL statement is executed?

SELECT MIN(WAREHOUSE) FROM PARTS;

Select one:

a. 1

b. 0

c. 3

d. 2

3.

Based on the given table Stocks type the possible out if the following sql statement is executed.

What is the length of description Cordless Drill from parts when this SQL statement is executed?

SELECT LENGTH(DESCRIPTION,'O') FROM PART;

Select one:

a. 12

b. 13

c. 11

d. 14

4.

Based on the given table Stocks type the possible out if the following sql statement is executed.

What is the character position of O of the description Microware Oven from parts when this SQL statement is executed?

SELECT INSTR(DESCRIPTION,'O') FROM PART;

Select one:

a. 5

b. 2

c. 3

d. 4

PART DESCRIPTION ONHAND CLASS WAREHOUSE PRICE AT94 IRON BVO6 HOME GYM CD52 MICROWAVE OVEN DL71 CORDLESS DRILL DR93 GAS RANGE DW11 WASHER FD21 STAND MIXER KL62 DRYER KT03 DISHWASHER KV29 TREADMILL 50 HW 45 SG 32 Ap 21 HW 21 AP 12 AP 22 HW 12 AP 8 AP 9 SG 2495 79495 165 12995 495 399 159 349 595 1390 2