MySQL · all questions

MySQL
practice.

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

1,185

Questions

15/60

Page

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

Q281

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

Select an option to see the answer and solution.

Q282

mysql_store_result() does not return a result set.

Select an option to see the answer and solution.

Q283

In the following SQL command "*" stands for?

SELECT * FROM person;

Select an option to see the answer and solution.

Q284

What is the meaning of "EMPTY SET" in the following MySQL command?

SELECT fname, lname, person_id
FROM person
WHERE lname=’s’;
/* after Execution*/ Mysql tool RETURN EMPTY SET 0:00sec

Select an option to see the answer and solution.

Q285

Which data and time datatype stores time value in 'hh:mm:ss' format?

Select an option to see the answer and solution.

Q286

Which status indicator assesses how effective the table cache is?

Select an option to see the answer and solution.

Q287

Which of the following is an illegal unquoted identifier name?

Select an option to see the answer and solution.

Q288

What will be the output of the following MySQL statement "false AND Null"?

Select an option to see the answer and solution.

Q289

"CREATE VIEW ..." command is used to create which type of table in Mysql?

Select an option to see the answer and solution.

Q290

What is the variable that is a handle to a database object?

Select an option to see the answer and solution.

Q291

Which mode prevents entry of the 'zero' date value in strict mode?

Select an option to see the answer and solution.

Q292

For what can the FULLTEXT indexes be created for?

Select an option to see the answer and solution.

Q293

For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by which option?

Select an option to see the answer and solution.

Q294

The option which finds the startup options supported by the server through mysqld is . . . . . . . .

Select an option to see the answer and solution.

Q295

The 'C' in the ACID property of transactions is . . . . . . . .

Select an option to see the answer and solution.

Q296

Foreign keys can handle deletes and updates.

Select an option to see the answer and solution.

Q297

Which of the following is more efficient?

LOAD DATA, INSERT

Select an option to see the answer and solution.

Q298

What will be the output of of the following SQL statement?

SELECT person_id, Fname, lname
FROM person;

Select an option to see the answer and solution.

Q299

Which collations does this MySQL statement list?

SHOW COLLATION LIKE 'utf8%'

Select an option to see the answer and solution.

Q300

"INSERT" is same as "UPDATE"?

Select an option to see the answer and solution.

Prev 13 14 15 16 17 Next