A directory of Objective Type Questions covering all the Computer Science subjects. Here you can access and discuss Multiple choice questions and answers for various compitative exams and interviews.

Discussion Forum

Que. Consider a “CUSTOMERS” database table having a column “CITY” filled with all the names of Indian cities (in capital letters). The SQL statement that finds all cities that have “GAR” somewhere in its name, is:
a. Select *from customers where city=’%GAR%’;
b. Select *from customers where city=’$GAR$’;
c. Select *from customers where city like ‘%GAR%’;
d. Select *from customers where city as ’%GAR’;
Answer:Select *from customers where city like ‘%GAR%’;
Confused About the Answer? Ask for Details Here
Know Explanation? Add it Here

Similar Questions: