1.

Based on the given table Stocks choose the possible output if the following sql statement is executed.

SELECT COUNT(PRICE) FROM STOCKS;

Select one:

a. 1

b. 0

c. 2

d. 3

2.

SELECT MAX(NAME) FROM STOCKS;

Select one:

a. SUNSILK

b. SODA

c. TIDE

d. ZONROX

3.

SELECT MIN(PRICE) FROM STOCKS;

Select one:

a. 4

b. 5

c. 7

d. 6

4.

SELECT AVG(NVL(QTY,0)) FROM STOCKS;

Select one:

a. 8

b. 0.8

c. 8.22

d. 0

5.

SELECT AVG(WAREHOUSE) FROM STOCKS;

Select one:

a. 2

b. 1

c. 5

d. 3

Table Name -Stocks ID NAME WAREHOUSE CL QTY PRICE 50 27 35 1 SS 3 PL 5 ZR 5 TD 10 KF 7 SG 8 ZR 5 TD 1 SUNSILK 2 PALMOLIVE 10 ZONROX 12 TIDE 9 KING FLOUR 4 SAFEGUARD 5 ZONRO)X 7 TIDE 8 SODA 7 7