1.

Refer to table 1.0 Using the SELECT statement below what would be the possible output:

SELECT NAME, ORG, POSITION FROM ORGCHAR WHERE ORG =JPCS OR POSITION = SEC;

Select one:

a. Incorrect SELECT statement

b. 0 rows selected

c. It will retrieve the record of JOAN andROAN

d. It will retrieve the record of JOAN,ROAN and JUN

2.

Refer to table 1.0 Using the SELECT statement below what would be the possible output:

SELECT NAME, ORG, POSITION FROM ORGCHAR WHERE ORG =JPCS OR POSITION = SEC AND NAME LIKE %N

Select one:

a. It will retrieve the record of JOAN,ROAN and JUN

b. Incorrect SELECT statement

c. 0 rows selected

d. It will retrieve the record of JOAN and ROAN

3.

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.

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