MySQL Mock Test 4 - Sanfoundry

10%

Question 1 of 10

1. The option which delays index flushing for slave server is _________________

--delay-write-key=ALL

--delay-key-write=ALL

--key-write-delay=NONE

--key-delay-write=NONE

Question 1 of 10

Question 2 of 10

2. What jobs “Query Optimizer” perform in Mysql?

All of the mentioned

Syntax errors

Permissions

Determine the efficient way to execute a query

Question 2 of 10

Question 3 of 10

3. Which statement is used to remove a trigger?

DROP

REMOVE

DELETE

CLEAR

Question 3 of 10

Question 4 of 10

4. Which statement issues a lock on tables?

LOCK TABLES

LOCK ISSUE

ISSUE LOCKS

ISSUE LOCK

Question 4 of 10

Question 5 of 10

5. If a column contains 7 values and 6 distinct values, the cardinality is __________

Question 5 of 10

Question 6 of 10

6. Suppose tbl_1 is a table consisting of 8 rows and tbl_2 is a table consisting of 6 rows, the number of combinations through which the search is performed is __________

SELECT tbl_1.i1, tbl_2.i2
	FROM tbl_1 INNER JOIN tbl_2
	WHERE tbl_1.i1 = tbl_2.i2;

Question 6 of 10

Question 7 of 10

7. To maintain performance of tables having variable length rows, which statement is used?

ADJUST TABLE

BALANCE TABLE

OPTIMIZE TABLE

MAINTAIN TABLE

Question 7 of 10

Question 8 of 10

8. What is def in the following MySQL statement?

DECLARE abc HANDLER FOR def ghi;

statement

action

condition value

null

Question 8 of 10

Question 9 of 10

9. To create or drop events for a database, which privilege should be granted?

DROP

EVENT

CREATE

PRIVILEGE

Question 9 of 10

Question 10 of 10

10. The use of table level locks is always useful in MyISAM tables.

True

False

Question 10 of 10