Question

2. What is the meaning of - SELECT
ENAME FROM EMP WHERE ENAME
LIKE '%a%a%'?
*
O A. ENAME begins with two A's
B. ENAME ends with two A's
C. ENAME has more than two A's
o
D. ENAME has two A's in it, at any
position​

Answer 1

operator is used in a WHERE clause to search for a specified pattern in a column. There are two wildcards often used in conjunction with the LIKE operator: % - The percent sign represents zero, one, or multiple characters. _ - The underscore represents a single character.