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 ?
- _
- ||
- \%
SQL Queries
1 Like
Answer
\%
Reason — The % wildcard character in SQL pattern matching, matches any substring, so %Computer Science would match any string ending with 'Computer Science'. Therefore, the correct option to fill in the blank space is %.
Answered By
3 Likes
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