1.Which of the following is the correct report listing the column PARTNO, DESCRIPTION and WAREHOUSE. Get only that description that does not ends with ER. Note that you have to merge the said three columns, rename the merge column as Parts Record. Below is the sample output for column. Parts Record AT94is the part number ofIRONwhich belong to warehouse3

A.SELECT (PARTNUM || is the part number of|| DESCRIPTION || which belongs to || WAREHOUSE FROM PARTS WHERE PARTNUM NOT LIKE %ER;

B.SELECT (PARTNUM || is the part number of ||DESCRIPTION || which belongs to || WAREHOUSE) FROM PARTS WHERE PARTNUM NOT LIKE ER%;

C.SELECT (PARTNUM is the part number of DESCRIPTIONwhich belongs toWAREHOUSE) FROM PARTS WHERE PARTNUM NOT LIKE %ER;

D.SELECT (PARTNUM || is the part number of ||DESCRIPTION || which belongs to || WAREHOUSE) FROM PARTS WHERE PARTNUM LIKE %ER;

2.Which of the following is the correct report that will display the DESCRIPTION, WAREHOUSE AND distinct value for CLASS.

A.SELECT DISTINCT (CLASS),DESCRIPTION, WAREHOUSE FROM PARTS;

B.SELECT DESCRIPTION, WAREHOUSE, CLASS FROM PARTS;

C.SELECT DISTINCT DESCRIPTION, WAREHOUSE, CLASS FROM PARTS;

D.SELECT DESCRIPTION, WAREHOUSE, DISTINCT CLASS FROM PARTS;

3.Which of the following is the correct report listing only the column DESCRIPTION, ONHAND and WAREHOUSE of all PARTS where ONHAND is greater than or equal to 21.

A.SELECT DESCRIPTION, ONHAND, WAREHOUSE FROM PARTS WHERE ONHAND >=21;

B.SELECT DESCRIPTION, ONHAND, WAREHOUSE FROM PARTS WHERE ONHAND

C.SELECT DESCRIPTION, ONHAND, WAREHOUSE FROM PARTS WHERE ONHAND =21;

D.SELECT DESCRIPTION, ONHAND, WAREHOUSE FROM PARTS WHERE ONHAND >21;

4.Which of the following is the correct report that will merge the column DESCRIPTION and PRICE put a literal character string of = with a price of in between the two columns. Limit the rows returned by getting only the partnum that starts with letter K.

A.SELECT (DESCRIPTION|| WITH A PRICE OF || PRICE) FROM PARTS WHERE PARTNUM LIKE K%;

B.SELECT (DESCRIPTION|| WITH A PRICE OF || PRICE) FROM PARTS WHERE PARTNUM LIKE %K;

C.SELECT (DESCRIPTION|| WITH A PRICE OF || PRICE) FROM PARTS WHERE PARTNUM LIKE %K%;

D.SELECT (DESCRIPTION|| WITH A PRICE OF || PRICE) FROM PARTS WHERE PARTNUM LIKE __K%;

5.Which of the following is the correct report listing only the column DESCRIPTION, PARTNUM, CLASS and PRICE of all parts where the description fourth letter starting from the first is equal to D.

A.SELECT DESCRIPTION, PARTNUM, CLASS, PRICES FROM PARTS WHERE DESCRIPTION LIKE ___D%;

B.SELECT DESCRIPTION, PARTNUM, CLASS, PRICES FROM PARTS WHERE DESCRIPTION LIKE %D___;

C.SELECT DESCRIPTION, PARTNUM, CLASS, PRICES FROM PARTS WHERE DESCRIPTION LIKE D%;

D.SELECT DESCRIPTION, PARTNUM, CLASS, PRICES FROM PARTS WHERE DESCRIPTION LIKE %D;

6.Which of the following is the correct report listing only the column PARTNUM, DESCRIPTION and PRICE of all PARTS where price is less than 500. Sort the PRICE in ascending order.

A.SELECT PARTNUN, DESCRIPTION, PRICE FROM PARTS WHERE PRICE

B.SELECT PARTNUN, DESCRIPTION, PRICE FROM PARTS WHERE PRICE > 500;

C.SELECT PARTNUN, DESCRIPTION, PRICE FROM PARTS WHERE PRICE

D.SELECT PARTNUN, DESCRIPTION, PRICE FROM PARTS WHERE PRICE >= 500;

7.

Which of the following is the correct report listing only the column PARTNUM, CLASS and ONHAND of all parts where partnum is equal to AT94, DR93 and KV29. (Note 1 query only and do not use logical condition)

A.SELECT PARTNUM, CLASS, ONHAND FROM PARTS WHERE PARTNUM IN (AT94,DR93,KV29);

B.SELECT PARTNUM, CLASS, ONHAND FROM PARTS WHERE PARTNUM IN (AT94,DR93,KV29);

C.SELECT PARTNUM, CLASS, ONHAND FROM PARTS WHERE PARTNUM = (AT94,DR93,KV29);

D.SELECT PARTNUM, CLASS, ONHAND FROM PARTS WHERE PARTNUM NOT IN (AT94,DR93,KV29);

8.

Which of the following is the correct report listing only the column CLASS, DESCRIPTION and PRICE of all PARTS where price range is between 200 to 500.

A.SELECT CLASS, DESCRIPTION, PRICE FROM PARTS WHERE PRICE BETWEEN 200 AND 500;

B.SELECT CLASS, DESCRIPTION, PRICE FROM PARTS WHERE PRICE BETWEEN 500 AND 500;

C.SELECT CLASS, DESCRIPTION, PRICE FROM PARTS WHERE PRICE BETWEEN =200 AND 500;

D.SELECT CLASS, DESCRIPTION, PRICE FROM PARTS WHERE PRICE BETWEEN 200 AND BETWEEN 500;

Table 2.0 PARTS PARTNUM DESCRIPTION ONHAND CLASS WAREHOUSE PRICE 50 45 52 MICROWAVE OVEN 32 CORDLESS DRILL 21 21 12 RAAS HOME GYM SG AP 2495 79495 165 BVO6 CDS2 DL71 DR93 DW11 FD21 KL62 KTO3 DISHWASHER RV29 495 399 159 349 595 1390 GAS RANGE WASHER STAND MIXER DRYER AP Ap 12 AP AP TREADMILL