7. Which is not an advantage of using computers in painting? A. Errors can easliy be corrected

B. Work is done in an organized, no-mess environment.

C. Colors do not fade and brushes are never worn-out.

D. Can’t be transferred or painted on almost any media

answer:

C. Colors do not fade and brushes are never worn-out

by simply implying it

Explanation:

.Which of the following SELECT statement is the correct PL/SQL that will display all rows and columns?

a.SELECT * FROM PARTS;

b.SELECT ALL FROM PARTS;

c.SELECT TABLE PARTS;

d.SELECT FROM TABLE PARTS;

2.Which of the following SELECT statement is the correct PL/SQL that will displayeliminate the duplicate rows for column class and warehouse.

a.SELECT DISTINCT CLASS, WAREHOUSE FROM PARTS;

b.SELECT DISTINCT CLASS AND WAREHOUSE FROM PARTS;

c.SELECT DISTINCT CLASS, DISTINCT WAREHOUSE FROM PARTS;

d.SELECT DISTINCT CLASS AND DISTINCT WAREHOUSE FROM PARTS;

3.Which of the following SELECT statement is the correct PL/SQL that willcreate a report specifying only the column PRICE, ONHAND and DESCRIPTION?

a.SELECT PRICE, ONHAND, DESCRIPTION FROM PARTS;

b.SELECTONHAND,PRICE ,DESCRIPTION FROM PARTS;

c.SELECT (ONHAND||PRICE ||DESCRIPTION FROM PARTS;

d.SELECTONHAND,PRICE DESCRIPTION FROM PARTS ORDER BY ONHAND;

4.Which of the following SELECT statement is the correct PL/SQL that willcreate a report that will add 10% increase in PRICE? List only the column DESCRIPTION, CLASS and PRICE.