What will be the result of the following query?
SELECT 5 <=> 5, NULL <=> NULL, 5 <=> NULL
1 1 0
01 0
11 1
0 0 0
Correct Answer: 1 1 0
Explanation:
Note: This Question is unanswered, help us to find answer for this one
MySQL Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More MySQL MCQ Questions
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?
Which escape sequence represents the backslash ('\') character?
Which are the properties of MySQL Cursors?
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.
Which is not a SQL operator?
If you insert (00) as the value of the year in a date column, what will be stored in the database?