If you insert (00) as the value of the year in a date column, what will be stored in the database?
Correct Answer: 2000
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
Which is not a SQL operator?
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.
Which escape sequence represents the backslash ('\') character?
Default value of locale for the FORMAT(X,D[locale])D function?
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