Home / Programming MCQs / MySQL MCQs / Question
N
Q. The keyword used with UNION that does not retain duplicate rows is ________
Explanation:
The keyword ‘DISTINCT’ used along with ‘UNION’ is synonymous with just the ‘UNION’ statement. It produces only the distinct rows from the combination of the two tables in the SELECT query.
You must be Logged in to update hint/solution
Mysql is an example of the _____.
What is used to perform analysis of key values by the server?
Which of the following is used for reading and writing operating-system files?
In how many categories data types has been classified?
What is the maximum length for alias names in terms of characters?
The place where the server stores its databases and status files is the data directory.
Which method returns the error code generated from the execution of the last MySQL function?
The variables or expressions passed from the calling subprogram are
Discusssion
Login to discuss.