1.

Supposed that the user uses the ff SELECT statement: what will be the possible output. SELECT GRADE AS STUDENT MARK FROM GRADE_REPORT;

Select one:

a. Error because of missing mark.

b. Will display the column GRADE rename as STUDENT MAK

c. Will display all rows and columns.

d. Error because of the keyword AS.

2.

Suppose that the user wanted to add a new column name as CUST_NAME data type char size 6. What is the correct SQL statement to use?

Select one:

a. ALTER PARTS ADD CUST_NAME CHAR(6);

b. ALTER TABLE PARTS ADD CUST_NAME CHAR(6);

c. ALTER PARTS SET CUST_NAME = CHAR(6);

d. ALTER TABLE PARTS SET CUST_NAME = CHAR(6);

3.

Suppose that a user wanted to insert a new value using the implicit method which of the following is the correct example.

Select one:

a. INSERT INTO STUDENST(USN_ID, FIRSTNAME) VALUES(10,ELENA);

b. INSERT INTO STUDENTS VALUES (10,ELENA);

c. INSERT INTO STUDENTS VALUES (10, NULL,ELENA,NULL);

d. INSERT INTO STUDENTS VALUES (USN_ID, FIRSTNAME) (10,ELENA);