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

Select one:

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

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

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

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

2.

Suppose that a user uses the DELETE statement as shown below: what is/are the possible output. DELETE from STUDENT;

Select one:

a. All rows are deleted including table structure.

b. 0 rows are updated.

c. 0 rows are deleted.

d. All rows are deleted but the table is still intact.

3.

Suppose that a user wanted to change the datatype of column ADDRESS from Varchar to Char which of the following is the correct example.

Select one:

a. ALTER STUDENTS SET ADDRESS VARCHAR(20);

b. ALTER TABLE STUDENTS SET ADDRESS VARCHAR(20);

c. ALTER TABLE STUDENTS MODIFY ADDRESS VARCHAR(20);

d. ALTER STUDENTS MODIFY ADDRESS VARCHAR(20);

4.

What is the return value if the user try to do the following: SELECT TRUNC (65.73,-2) FROM DUAL;

Select one:

a. 0

b. 600

c. 00

d. 60

5.

Suppose that a user wanted toad a new column name as CITY datatype set to char size 10. Which of the following is the correct sql statement?

Select one:

a. ALTER TABLE STUDENTS ADD COLUMN CITY VARCHAR(10);

b. ALTER TABLE STUDENTS ADD COLUMN CITY CHAR(10);

c. ALTER TABLE STUDENTS ADD CITY CHAR(10);

d. ALTER TABLE STUDENTS ADD CITY VARCHAR(10);