MySQL Interview questions

Total available count: 24
Subject - Databases
Subsubject - MySQL

What are all the Common SQL Function?

CONCAT(A, B) – Concatenates two string values to create a single string output. Often used to combine two or more fields into one single field.

FORMAT(X, D) – Formats the number X to D significant digits.

CURRDATE(), CURRTIME() – Returns the current date or time.

NOW() – Returns the current date and time as one value.

MONTH(), DAY(), YEAR(), WEEK(), WEEKDAY() – Extracts the given data from a date value.

HOUR(), MINUTE(), SECOND() – Extracts the given data from a time value.

DATEDIFF(A, B) – Determines the difference between two dates and it is commonly used to calculate age.

SUBTIMES(A, B) – Determines the difference between two times.

FROMDAYS(INT) – Converts an integer number of days into a date value.

Next 5 interview question(s)

What are the nonstandard string types?
How many TRIGGERS are allowed in MySql table?
What are the objects can be created using CREATE statement?
How to display top 50 rows?
How MySQL Optimizes DISTINCT?