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.

What is NDB?

What are MySQL Spatial Data Types in the following list?

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 privilege do you need to create a function?

Assuming the column col1 in table tab1 has the following values: 2,3,NULL,2,3,1 What will be the output of the select statement mentioned below? SELECT count(DISTINCT col1) FROM tab1

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

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

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

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

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