Which question best fits the following query?

SELECT * FROM COURSES WHERE CTITLE LIKE '%SQL%' AND CID NOT IN ('7800','7820')

Question

Which question best fits the following query? 
 
  SELECT * FROM COURSES WHERE CTITLE LIKE '%SQL%' AND CID NOT IN ('7800','7820')

Answer

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.

Answer

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.

Answer

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.

Answer

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.

Answer

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.

Answer

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.

Answer

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.

Answer

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.

Crowdly

Which question best fits the following query? SELECT * FROM COURSES WHERE C...

Want instant access to all verified answers on moodle.icam.fr?