Course Solutions Uncategorized (Solved) : 1 Refer Table 10 Using Select Statement Would Possible Output Select Name Org Position Org Q29918917 . . . .

(Solved) : 1 Refer Table 10 Using Select Statement Would Possible Output Select Name Org Position Org Q29918917 . . . .

 

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

1.

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

SELECT NAME, ORG, POSITION FROM ORGCHAR WHERE ORG =’JPCS’ ORPOSITION = ‘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 wouldbe the possible output:

SELECT NAME, ORG, POSITION FROM ORGCHAR WHERE ORG =’JPCS’ ORPOSITION

OR

PayPal Gateway not configured

OR

PayPal Gateway not configured

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post