Computer Science
Consider the following query
SELECT name FROM class WHERE subject LIKE ' ............... Computer Science' ;
Consider the following query SELECT name FROM class WHERE subject LIKE ' ............... Computer Science' ; Which one of the following has to be added into the blank space to select the subject which has Computer Science as its ending string ? 1. 2. _ 3. || 4. \%
Related Questions
Consider the following table namely Employee :
Employee_id Name Salary 1001 Misha 6000 1009 Khushi 4500 1018 Japneet 7000 Which of the names will not be displayed by the below given query ?
SELECT name FROM employee WHERE employee_id > 1009 ;- Misha, Khushi
- Khushi, Japneet
- Japneet
- Misha, Japneet
Which operator performs pattern matching ?
- BETWEEN operator
- LIKE operator
- EXISTS operator
- None of these
Which operator tests a column for the absence of data (i.e., NULL value) ?
- EXISTS operator
- NOT operator
- IS operator
- None of these
The pattern '_ _ _' matches any string of …………… three characters. '_ _ _%' matches any string of …………… three characters.
- Atleast, Exactly
- Exactly, Atleast
- Atleast, All
- All, Exactly