PHP ARRAYS QUIZ

Reduced training costs

Increased dependence on a single vendor

Applications are not needed

All of these

SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103;

c) SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103

SELECT, FROM, WHERE

FROM, WHERE, SELECT

SELECT,WHERE,FROM

WHERE, FROM,SELECT

True

False

ADD

MAKE

INSERT

CREATE

specify search condition

specify what table we are selecting or deleting data FROM

None of these

specify range for search condition

limits the row data are returned.

limits the column data that are returned.

Both A and B are correct.

Neither A nor B are correct.

True

False

INSERT VALUES INTO student (

INSERT VALUES (

INSERT INTO student VALUES (

INSERT student VALUES (

Data types

All of these

Primary keys

Default values