Questions Bank | Page 112270

Which question best fits the following query?

SELECT *

FROM COURSES

WHERE CTITLE LIKE '%SQL%'

AND CID NOT IN ('7800','7820')

Display the first row of the table COURSES whose column CTITLE is equal to %SQL% and whose value in column CID is neither 7800 nor 7820.

Display the first row of the table COURSES whose column CTITLE contains the characters SQL and and whose value in column CID is not between 7800 and 7820.

Display the first row of the table COURSES whose column CTITLE is equal to %SQL% and whose value in column CID is not between 7800 and 7820.

Display all the rows of the table COURSES whose column CTITLE is equal to %SQL% and whose value in column CID is not between 7800 and 7820.

Display all the rows of the table COURSES whose column CTITLE contains the characters SQL and whose value in column CID is neither 7800 nor 7820.

Display all the rows of the table COURSES whose column CTITLE contains the characters SQL and and whose value in column CID is not between 7800 and 7820.

Display the first row of the table COURSES whose column CTITLE contains the characters SQL and whose value in column CID is neither 7800 nor 7820.

Display all the rows of the table COURSES whose column CTITLE is equal to %SQL% and whose value in column CID is neither 7800 nor 7820.

View this question

Crowdly

Questions Bank (1356860 total)