MySQL · all questions

MySQL
practice.

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

1,185

Questions

16/60

Page

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

Q301

To check how MySQL would execute a SELECT query, which statement is used?

Select an option to see the answer and solution.

Q302

What will be the output of the following SQL statement?

SELECT *
 FROM person;

Select an option to see the answer and solution.

Q303

What is the meaning of "GROUP BY" clause in Mysql?

Select an option to see the answer and solution.

Q304

Is there any error in executing the following MySQL command?

SELECT USER (),
VERSION (), DATABASE ();

Select an option to see the answer and solution.

Q305

Which of the following are the valid "database datatypes" in Mysql?

Select an option to see the answer and solution.

Q306

With only MyISAM tables, how many of the following are for use?

mysql, mysqladmin, mysqldump, mysqlisamchk

Select an option to see the answer and solution.

Q307

The datatype SMALLINT stores . . . . . . . .

Select an option to see the answer and solution.

Q308

How can the value of recently generated sequence number be obtained?

Select an option to see the answer and solution.

Q309

SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; Which of these is not optional?

Select an option to see the answer and solution.

Q310

Which of these is not used to connect to the MySQL server?

Select an option to see the answer and solution.

Q311

The function returning reference to array of row values is . . . . . . . .

Select an option to see the answer and solution.

Q312

Which of these is a read only variable?

Select an option to see the answer and solution.

Q313

MySQL stores the database character set and collation attributes in the file . . . . . . . .

Select an option to see the answer and solution.

Q314

The MySQL APIs are libraries to connect applications to database servers.

Select an option to see the answer and solution.

Q315

Fill the blanks with suitable options?
BETWEEN . . . . . . . . AND . . . . . . . .

Select an option to see the answer and solution.

Q316

MySQL can be used to execute script files.

Select an option to see the answer and solution.

Q317

Multiple statement execution is not enabled by default.

Select an option to see the answer and solution.

Q318

If COLLATE is given without CHARACTER SET, the first part of the collation name gives the character set.

Select an option to see the answer and solution.

Q319

0x61 + 0 results in . . . . . . . .

Select an option to see the answer and solution.

Q320

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

Select an option to see the answer and solution.

Prev 14 15 16 17 18 Next