Question

Read the following strings :

(i) ‘Sree Kumar’ 

(ii) ‘Kumaran’ 

(iii) ‘Kumar Shanu’ 

(iv) ‘Sreekumar’ Choose the correct option that matches with the pattern ‘%Kumar’, when used with LIKE operator in a SELECT statement. 

1. Strings (i) and (ii) only 

2. Strings (i), (iii) and (iv) only , 

3. Strings (i) and (iii) only 

4. All the strings

Answer 1

Correct option that matches with the pattern ‘%Kumar’, when used with LIKE operator in a SELECT statement.