Which of the following numeric data types has a storage value of 8 bytes?

What's the output ? SELECT DATE_FORMAT(‘2006-06-00'. '%d')

What is the result? SELECT 5 <=> 5, NULL <=> NULL, 5 <=> NULL

In MySOL 5.6, you can write triggers containing direct references to tables by name.

Output? if you try to perform an arithmetic operation on a column containing NULL values?

Default value of locale for the FORMAT(X,D[locale])D function?

What privilege do you need to create a function?

In the 'where clause' of a select statement, the AND operator displays a row if any of the conditions listed are true. The OR operator displays a row if all of the conditions listed are true.

What are MySQL Spatial Data Types in the following list?

What is NDB?

You are maintaining data for a Products table, and want to see the products which have a current stock of at least 50 more than the minimum stock limit. The structure of the Products table is: ProductID ProductName CurrentStock MinimumStock Two possible queries are: (a)select * from products where currentStock > MinimumStock + 50 (b)select * from products where currentStock - 50 > MinimumStock Choose the appropriate option with regard to the above queries.