Question

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

Select one:

a. 60

b. 00

c. 0

d. 600

2.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 the keyword AS.

b. Error because of missing “” mark.

c. Will display the column GRADE rename as STUDENT MAK

d. Will display all rows and columns.

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

Select one:

a. 0 rows are deleted.

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

c. All rows are deleted including table structure.

d. 0 rows are updated.

4.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 PARTS
SET CUST_NAME = CHAR(6);

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

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

5.

TABLE 1.0 ORGCHART ORG POSITION ID NAME 10 REYES, ANNA AMATHS PRES 15 AGAPITO, JUN SC SEC MEMBER 5 CRUZ, JOAN JPCS 12 DUQUE, ROAN JPCSMEMBER 21 LASON,MOJICA

Refer to table 1.0, suppose that user insert the following values using the statement below what would be the possible output? INSERT INTO ORGCHART VALUES (11,’YAMBAO,JUN’, NULL, NULL);

Select one:

a. The ORG and POSITION of YAMBAO will automatically sets to N/A.

b. Cannot insert the record because of missing values for ORG and POSITION.

c. The ORG and POSITION of YAMBAO will automatically sets to None.

d. The ORG and POSITION of YAMBAO will automatically sets to NULL.

Answer 1

1. The answer for the command SELECT TRUNC (65.73,-2) FROM DUAL; is 0. For the function TRUNC, as we are passing a negative value of 2, it replaces two digits to the left of the decimal point by (c). 0. So, when it consecutively replaces two digits, it gives a result 0 not 00.

2. SELECT GRADE AS STUDENT MARK FROM GRADE_REPORT; This SQL query outputs an error message due to missing of " " around STUDENT MARK. If we are using it without quotes, the alias should be a single word either STUDENT or MARK or STUDENT_MARK. If we are putting a space in between then we must enclose it within quotes. So, the correct answer is, b. Error because of missing “” mark.

3. Correct answer: b. All rows are deleted but the table is still intact.

The command DELETE from STUDENT; deletes all the rows as no particular row is indicated using WHERE clause but the table is not deleted. Table structure, indexes and attributes still remain intact.

4. The correct answer is (c). ALTER TABLE PARTS ADD CUST_NAME CHAR(6);

When we are adding a new column to an already existing table, we should use ADD instead of SET. Again, in part (a) the key word TABLE is missing which is a part of the syntax in order to alter a table.

5. The query INSERT INTO ORGCHART VALUES (11,’YAMBAO,JUN’, NULL, NULL); outputs an error message. because of the value 'YAMBAO,JUN'. Because of this value it doesn't take input for columns ORG and POSITION. So, the correct answer is b. Cannot insert the record because of missing values for ORG and POSITION.