A FULLTEXT index can be created for multiple columns. 

Which symbol is used to retrieve all columns from a database table?

Which keyword used with UNION does not retain duplicate rows 

Which of the following SQL operators is used for pattern matching operations?

 What will be the output of the following MySQL statement “true OR Null”? 

AI is acronym for in terms of database collation _____ 

Suppose you want to select a database named ‘abekus’ as the default database. Which of the following commands do you use? 

What is the purpose of the WHERE clause in SQL?

What will be the output of the following query?

 SELECT fname FROM person WHERE emp_id != 6 OR emp_id IS NULL; 

What will be the output of the following query?

 SELECT emp_id, fname, lname FROM employee WHERE LEFT (lname, 1) =’F’;