Question 1

Question text

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)

Marks for this submission: 1.00/1.00. Accounting for previous tries, this gives 0.33/1.00.

Question 2

Question text

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 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;

Question 3

Question text

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;

Question 4

Question text

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%;

Question 5

Question text

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);

Question 6

Question text

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;

Question 7

Question text

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 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;

Question 8

Question text

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

Select one:

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

Question 9

Question text

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 = 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);

Question 10

Question text

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

Select one:

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;

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