Computer Science
The pattern '_ _ _' matches any string of …………… three characters. '_ _ _%' matches any string of …………… three characters.
- Atleast, Exactly
- Exactly, Atleast
- Atleast, All
- All, Exactly
SQL Queries
3 Likes
Answer
Exactly, Atleast
Reason — '_ _ _' matches any string of exactly 3 characters. Each dash represents one character, so there must be three characters in total. '_ _ _%' matches any string of at least 3 characters. The first three dashes represent exactly three characters, and the '%' symbol matches any substring. So, it matches any string with three or more characters.
Answered By
2 Likes
Related Questions
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 ?
- _
- ||
- \%
Which operator tests a column for the absence of data (i.e., NULL value) ?
- EXISTS operator
- NOT operator
- IS operator
- None of these
By default, ORDER BY clause lists the results in …………… order.
- Descending
- Any
- Same
- Ascending
Consider the following query
SELECT * FROM employee ORDER BY salary ..............., name ...............;To display the salary from greater to smaller and name in alphabetical order which of the following options should be used ?
- Ascending, Descending
- Asc, Desc
- Desc, Asc
- Descending, Ascending