Home / Programming MCQs / MySQL MCQs / Question
J
Q. Suppose you are asked to display all the names which have 'a' as their second character then which query pattern you will use?
To know the name who has an as its second character we will write: _a%;
You must be Logged in to update hint/solution
The string function that returns the index of the first occurrence of substring is _____________.
A recursive subprogram is one that calls itself.
The following statement is valid.
Suppose you are asked to drop a column using alter statement then which syntax you will follow?
There cannot be more than one column per table with the AUTO_INCREMENT attribute.
Which of the following function returns the current date and time in MySql ?
Which of the following is not one of the standard nosql categories?
Which operators combine the results of two queries into one result?
How many bytes does each character in the AL16UTF16 encoding take up?
Discusssion
Login to discuss.