ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

108 / 120

Question 108:

You must display details of all users whose username contains the string `ch_`. (Choose the best answer.) Which query generates the required output? 

Answer options:

A. SELECT * FROM users Where user_name LIKE `%ch_`;
B. SELECT * FROM users Where user_name LIKE `%ch_%`ESCAPE`%`;
C. SELECT * FROM users Where user_name LIKE `ch\_%` ESCAPE `_`;
D. SELECT * FROM users Where user_name LIKE `%ch\_%` ESCAPE `\`;