1. Given the output below. Which of the following is the correct PL/SQL to be used?

Select one:

a. SELECT (PARTNUM|| belong to||DESCRIPTION) FROM PARTS WHERE CLASS = SG;

b. SELECT (PARTNUM|| belong to||DESCRIPTION) FROM PARTS WHERE CLASS = SG;

c. SELECT (PARTNUM|| belong to||DESCRIPTION) FROM PARTS WHERE CLASS = SG;

d. SELECT (PARTNUM|| belong to||DESCRIPTION) FROM PARTS WHERE PARTNUM IN (BV06,KV29)

2. Given the output below. Which of the following is the correct PL/SQL to be used?

a. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE DESCRIPTION LIKE L%;

b. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE ONHAND >=9;

c. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS IN (HW,SG);

d. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE DESCRIPTION LIKE %L;

3. Given the output below. Which of the following is the correct PL/SQL to be used

Select one:

a. SELECT WAREHOUSE, CLASS FROM PARTS;

b. SELECT DICTINCT WAREHOUSE, CLASS FROM PARTS WHERE WAREHOUSE >=1;

c. SELECT WAREHOUSE, CLASS FROM PARTS WHERE CLASS IN (AP,SG,HW);

d. SELECT DISTINCT WAREHOUSE FROM PARTS;

4. Given the output below. Which of the following is the correct PL/SQL to be used?

Select one:

a. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS = AP OR ONHAND BETWEEEN 8 AND 12

b. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS = AP OR ONHAND >=8;

c. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS = AP AND DESCRIPTION LIKE __S%;

d. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS = AP OR DESCRIPTION LIKE __S%;

5. Given the output below. Which of the following is the correct PL/SQL to be used?

Select one:

a. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE DESCRIPTION LIKE %R;

b. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS = AP OR CLASS = HW;

c. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE DESCRIPTION LIKE R%;

d. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS IN (HW,AP);

6. Given the output below. Which of the following is the correct PL/SQL to be used?

Select one:

a. SELECT ALL COLUMN FROM PARTS;

b. SELECT * FROM TABLE PARTS;

c. SELECT * FROM PARTS;

d. SELECT ALL FROM PARTS;

7. Given the output below. Which of the following is the correct PL/SQL to be used?

a. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS = AP OR DESCRIPTION LIKE %ER;

b. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS = AP AND ONHAND BETWEEN 8 AND 12;

c. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS = AP OR ONHAND BETWEEN 8 AND 12;

d. SELECT DESCRIPTION, ONHAND, CLASS

FROM PARTS

WHERE CLASS = AP AND DESCRIPTION LIKE %ER;

8.Given the output below. Which of the following is the correct PL/SQL to be used?

a. SELECT DESCRIPTION, (PRICE *.5 )+PRICE-100 FROM PARTS WHERE PRICE >10000;

b. SELECT DESCRIPTION, PRICE *.5 +PRICE-100 FROM PARTS WHERE PRICE >10000;

c. SELECT DESCRIPTION, PRICE *.5 +(PRICE-100) FROM PARTS WHERE PRICE

d. SELECT DESCRIPTION, PRICE *.5 +PRICE-100 FROM PARTS WHERE PRICE

9. Given the output below. Which of the following is the correct PL/SQL to be used?

a. SELECT DESCRIPTION, ONHAND,CLASS

FROM PARTS

WHERE CLASS = HW;

b. SELECT DESCRIPTION, ONHAND,CLASS

FROM PARTS

WHERE CLASS = HW;

c. SELECT DESCRIPTION, ONHAND,CLASS

FROM PARTS

WHERE ONHAND >=21;

d. SELECT DESCRIPTION, ONHAND,CLASS

FROM PARTS

WHERE ONHAND IN(50,21,22);

10. Given the output below. Which of the following is the correct PL/SQL to be used?

a. SELECT DISTINCT WAREHOUSE, CLASS FROM PARTS WHERE WAREHOUSE >=1;

b. SELECT WAREHOUSE, CLASS FROM PARTS WHERE CLASS IN (AP,SG,HW);

c. SELECT WAREHOUSE, CLASS FROM PARTS;

d. SELECT DISTINCT WAREHOUSE, CLASS FROM PARTS;