Mysql Questions Set 55:
A FULLTEXT index can be created for multiple columns.
Solution:
Which symbol is used to retrieve all columns from a database table?
Solution:
Which keyword used with UNION does not retain duplicate rows
Solution:
Which of the following SQL operators is used for pattern matching operations?
Solution:
What will be the output of the following MySQL statement “true OR Null”?
Solution:
AI is acronym for in terms of database collation _____
Solution:
Suppose you want to select a database named ‘abekus’ as the default database. Which of the following commands do you use?
Solution:
What is the purpose of the WHERE clause in SQL?
Solution:
What will be the output of the following query?
SELECT fname FROM person WHERE emp_id != 6 OR emp_id IS NULL;
Solution:
What will be the output of the following query?
SELECT emp_id, fname, lname FROM employee WHERE LEFT (lname, 1) =’F’;
Solution:
Related Question Sets:
Related Topics:
Scroll to Top
