1.Which of the following SELECT statement is the correctreport that will rename the column DESCRIPTION to TITLE, PARTNUM to ID and ONHAND to STOCK?

a.SELECT DESCRIPTION AS TITLE, PARTNUM AS ID, ONHAND AS STOCK FROM PART;

b.SELECT DESCRIPTION AS TITLE, PARTNUM AS ID, ONHAND AS STOCK FROM PARTS;

c.SELECT DESCRIPTION RENAME AS TITLE, PARTNUM RENAME AS ID, ONHAND RENAME AS STOCK FROM PARTS;

d.SELECT DESCRIPTION NEW AS TITLE, PARTNUM NEW AS ID, ONHAND NEW AS STOCK FROM PARTS;

2.Which of the following SELECT statement is the correctreport the will merge the column CLASS and PRICE rename the COLUMN as CLASS PRICE.

a.SELECT (CLASS||PRICE) AS CLASS PRICE FROM PARTS;

b.SELECT (CLASS||PRICE) AS CLASS PRICE FROM PARTS;

c.SELECT (CLASS||PRICE) CLASS PRICE FROM PARTS;

d.SELECT (CLASS||PRICE) AS CLASS PRICE FROM PARTS;

3.Which of the following SELECT statement is the correctreport that will combine the column PARTNUM and DESCRIPTION put a literal character string belongs to in between the two columns then rename the column as NUMBER TITLE. Note put space before and after the character literal string to avoid no spaces in the report.

a.SELECT (PARTNUM|| THAT BELONGS TO ||DESCRIPTION) AS NUMBER TITLE FROM PARTS;

b.SELECT (PARTNUM|| THAT BELONGS TO ||DESCRIPTION) AS NUMBER TITLE FROM PARTS;

c.SELECT (PARTNUM|| THAT BELONGS TO ||DESCRIPTION) AS NUMBER TITLE FROM PARTS;

d.SELECT (;PARTNUM|| THAT BELONGS TO ||DESCRIPTION;) AS NUMBER TITLE FROM PARTS;

4.Which of the following SELECT statement is the correctreport that will display the unique value for WAREHOUSE renames the column as No. of Available Warehouse.

a.SELECT DISTINCT WAREHOUSE AS No. of available warehouse FROM PARTS;

b.SELECT DISTINCT WAREHOUSE AS No. of available warehouse FROM PARTS;

c.SELECT DISTINCT WAREHOUSE AS No. of available warehouse FROM PARTS;

d.SELECT DISTINCT COLUMN WAREHOUSE AS No. of available warehouse FROM PARTS;

5.Which of the following is the correct report that will display the CLASS from table PARTS.

a.SELECT CLASS FROM PARTS;

b.SELECT * CLASS FROM PARTS;

c.SELECT CLASS FROM PARTS;

d.SELECT CLASS AS CLASS FROM PARTS;

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