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)

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