Mysql miscellaneous
- What will be the output of the following query?
SELECT *
FROM student
WHERE last_name LIKE %t%f%n%;
-
View Hint View Answer Discuss in Forum
NA
Correct Option: D
All of above
- What will be the output of the following query?
SELECT *
FROM student
WHERE last_name LIKE %bas% OR first_name LIKE %bbs%;
-
View Hint View Answer Discuss in Forum
NA
Correct Option: A
All student whose last name should contain substring “bas” or first name should contain substring “bbs”
- What will be the output of the following query?
SELECT *
FROM student
WHERE last_name LIKE ‘F%’ AND last_name LIKE ‘%T’;
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
All student whose last name should started with ‘F’ and end with ‘T’
- What will be the output of the following query?
SELECT *
FROM student
WHERE last_name LIKE ‘F%’ OR last_name LIKE ‘%T’;
-
View Hint View Answer Discuss in Forum
NA
Correct Option: A
All student whose last name should started with ‘F’ and end with ‘T’
- What will be the output of the following query?
SELECT *
FROM student
WHERE last_name LIKE ‘_a%e%’;
-
View Hint View Answer Discuss in Forum
NA
Correct Option: D
All of above