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

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

 

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 NAME LIKE‘%A’;

Select one:

a. Incorrect SELECT statement

b. It retrieves the record of ANNA and MOJICA

c. 0 rows selected / no rows selected

d. It retrieves the record of AGAPITO

2.

Refer to table 1.0, suppose that user update the table using thestatement below what would be the possible output? UPDATE ORGCHARTSET ORG = ‘PCS’ WHERE

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