Consider the following table named TESTTABLE:

tbIName tbILname

FN LN

FN LN

What will be the result of the following query?

SELECT 1 FROM TESTTABLE WHERE tblName iN ()

Which SQL statements will change the table default character set and all character columns (CHAR, VARCHAR, TEXT) to a new character set?

What will be the result? SELECT CONCAT('MY', 'S', 'QL')

Which data type has been deprecated in MySQL 5.6?

Which is INCORRECT regarding the DECIMAL data type?

Which forms of the SELECT statement writes a single row to a f‌ile without any formatting?

You want to display the titles of books that meet the following criteria: 1. Purchased before November 11, 2002 2. Price is less than $500 or greater than $900 You want to sort the result by the date of purchase, starting with the most recently bought book. Which of the following statements should you use?

What is the correct order of clauses in the select statement? 1 select 2 order by 3 where 4 having 5 group by

Maximum size of a row in a MyISAM table?

What is wrong with the following statement? create table foo (id int auto_increment, name int);

What does DETERMINISTIC mean in the creation of a function?