MySQL · all questions

MySQL
practice.

Practice every MCQ with options. Use Show answers when you want the correct option and solution.

1,185

Questions

57/60

Page

Pick an option on a question to see the right answer and solution.

Q1121

The DBI API for Perl is . . . . . . . .

Select an option to see the answer and solution.

Q1122

The option that enables multiple-statement execution is . . . . . . . .

Select an option to see the answer and solution.

Q1123

Which of these values is not valid as an AUTO_INCREMENT value?

Select an option to see the answer and solution.

Q1124

The storage engine for which the runtime options are always enabled is . . . . . . . .

Select an option to see the answer and solution.

Q1125

Which of the following belongs to an "aggregate function"?

Select an option to see the answer and solution.

Q1126

Which variable is set to zero when automatic privilege granting is not needed?

Select an option to see the answer and solution.

Q1127

Which table is preferred when there are many updates?

Select an option to see the answer and solution.

Q1128

Which of these is not optional?

SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns;

Select an option to see the answer and solution.

Q1129

The option used to specify the socket file pathname is . . . . . . . .

Select an option to see the answer and solution.

Q1130

Which of the following can be used interchangeably with MYSQL_VERSION_ID?

Select an option to see the answer and solution.

Q1131

Using indexes optimizes query performance.

Select an option to see the answer and solution.

Q1132

A FULLTEXT index cannot be created for multiple columns.

Select an option to see the answer and solution.

Q1133

The keyword used with UNION that retains duplicate rows is . . . . . . . .

Select an option to see the answer and solution.

Q1134

Which is the command to move the cursor to the beginning of line in mysql input editor?

Select an option to see the answer and solution.

Q1135

The number of tables for which DELAYED works is . . . . . . . .

MyISAM, MEMORY, ARCHIVE, BLACKHOLE

Select an option to see the answer and solution.

Q1136

The option that specifies the data directory location at server startup is . . . . . . . .

Select an option to see the answer and solution.

Q1137

Which command is used to display all the existing tables in a database?

Select an option to see the answer and solution.

Q1138

Which of these is more restrictive?

mysql_query(), mysql_real_query()

Select an option to see the answer and solution.

Q1139

It is required to have an access privilege for a database before selecting it with 'USE'.

Select an option to see the answer and solution.

Q1140

Which statement makes changes to the database's global attributes?

Select an option to see the answer and solution.

Prev 55 56 57 58 59 Next