Q101
Open questionWhich keyword is used for sorting the data in ascending order in Mysql?
Select an option to see the answer and solution.
MySQL · all questionsMySQL
MySQL
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
1,185
Questions
6/60
Page
Pick an option on a question to see the right answer and solution.
Q102
Open questionWhich of the following statements is/are correct with respect to "VIEW"?
Select an option to see the answer and solution.
Q103
Open questionWhich disk data does FILES table in INFORMATION_SCHEMA store?
Select an option to see the answer and solution.
Q104
Open questionThe TRIGGER privilege is used for the table to be able to create and drop triggers for it.
Select an option to see the answer and solution.
Q105
Open questionWhat performs administrative operations?
Select an option to see the answer and solution.
Q106
Open questionThe hub of a MySQL installation is . . . . . . . .
Select an option to see the answer and solution.
Q107
Open questionWhich variable checks for the availability of SSL support?
Select an option to see the answer and solution.
Q108
Open questionSHOW DATABASES lists the databases in the server to which you are connected.
Select an option to see the answer and solution.
Q109
Open questionWhich case does InnoDB store database names in?
Select an option to see the answer and solution.
Q110
Open questionWhat is the log in which data changes received from a replication master server are written?
Select an option to see the answer and solution.
Q111
Open questionIn the following SQL command "person_id" can be . . . . . . . .
SELECT person_id, fname, lname, Birth_data FROM person WHERE person_id=1;Select an option to see the answer and solution.
Q112
Open questionA binary string is not associated with a character set.
Select an option to see the answer and solution.
Q113
Open questionWhat will be the output of the following MySQL statement?
SELECT *
FROM employee
WHERE start_date BETWEEN ‘2007-01-01’ AND ‘2008-01-01’;Select an option to see the answer and solution.
Q114
Open questionINFORMATION_SCHEMA is based on the SQL standard.
Select an option to see the answer and solution.
Q115
Open questionTo maintain performance of tables having variable length rows, which statement is used?
Select an option to see the answer and solution.
Q116
Open questionWhich mode tells not to cache query results?
Select an option to see the answer and solution.
Q117
Open questionWhat attempts auto recovery based on the contents of its serial log?
Select an option to see the answer and solution.
Q118
Open questionA multiple-table delete cannot apply any join.
Select an option to see the answer and solution.
Q119
Open questionThe datadir variable value can be seen using . . . . . . . .
Select an option to see the answer and solution.
Q120
Open questionThe AUTO_INCREMENT sequences normally begin at . . . . . . . .
Select an option to see the answer and solution.