MySQL · all questions

MySQL
practice.

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

1,185

Questions

46/60

Page

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

Q901

Which statement issues a lock on tables?

Select an option to see the answer and solution.

Q902

Which mode is used to turn on strict mode and all of the additional restrictions?

Select an option to see the answer and solution.

Q903

The number of rows in the table is 10. Suppose all rows are deleted. The new row starts with sequence number . . . . . . . .

Select an option to see the answer and solution.

Q904

The DECIMAL used for expressions containing only exact values with fractional part is of digit precision . . . . . . . .

Select an option to see the answer and solution.

Q905

INFORMATION_SCHEMA is more portable than SHOW statements.

Select an option to see the answer and solution.

Q906

What are the results of the following SQL commands if col is an integer column?

1. SELECT * FROM mytbl WHERE num_col = '4';
2. SELECT * FROM mytbl WHERE num_col = 4;

Select an option to see the answer and solution.

Q907

What can be used as an alternative to mysqlconfig?

Select an option to see the answer and solution.

Q908

The event scheduler does not run by default.

Select an option to see the answer and solution.

Q909

What is xyz in the following SQL statement?

DELETE FROM xyz WHERE abc = 5;

Select an option to see the answer and solution.

Q910

Which flag is used to compile client programs that use MySQL header files?

Select an option to see the answer and solution.

Q911

In the following MySQL command how many rows will be deleted?

DELETE person
WHERE person_id=1;
/*person_id is a primary key */

Select an option to see the answer and solution.

Q912

Which type stores the longest length of strings?

Select an option to see the answer and solution.

Q913

x'ffff' in decimal is . . . . . . . .

Select an option to see the answer and solution.

Q914

What is def in the following MySQL statement?

CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;

Select an option to see the answer and solution.

Q915

Which statement is used to determine the storage engine for individual tables?

Select an option to see the answer and solution.

Q916

The MySQL server is highly configurable.

Select an option to see the answer and solution.

Q917

How many of the following does not return a value?

mysql_close(), mysql_init, mysql_real_connect

Select an option to see the answer and solution.

Q918

The indicator of presence/absence of a word in search is used in the mode . . . . . . . .

Select an option to see the answer and solution.

Q919

What is the hub of a MySQL installation?

Select an option to see the answer and solution.

Q920

Which among the following is the correct representation of "float(5,0)"?

Select an option to see the answer and solution.

Prev 44 45 46 47 48 Next