MySQL Mock Test 9 - Sanfoundry

10%

Question 1 of 10

1. The option that is necessary to compile a C program having math functions is _____________

-lm

-ln

-lq

-lp

Question 1 of 10

Question 2 of 10

2. Which operator compares sounds?

MATCH SOUNDS

SOUNDS LIKE

CHECK SOUNDS

SOUNDS SIMILAR

Question 2 of 10

Question 3 of 10

3. Which system variable when set to 1, makes all temporary tables to get stored on disk rather than in memory?

basedir

bind_address

back_log

big_tables

Question 3 of 10

Question 4 of 10

4. Which keyword inserted in the SHOW STATUS statement shows the values for the current connection?

LOCAL

DEFAULT

SESSION

GLOBAL

Question 4 of 10

Question 5 of 10

5. SPATIAL indexes cannot be created on NOT NULL spatial columns.

True

False

Question 5 of 10

Question 6 of 10

6. Which type can store a collection of objects of any type?

MULTIPOLYGON

MULTILINESTRING

MULTIPOINT

GEOMETRYCOLLECTION

Question 6 of 10

Question 7 of 10

7. MySQL does not automatically convert a date or time value to a number if the value is used in a numeric context.

False

True

Question 7 of 10

Question 8 of 10

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

SELECT  * FROM person
WHERE person_id=1;

Show all columns but only those rows which belongs to person_id=1

Show all columns and rows

None of the mentioned

Shows only columns person_id

Question 8 of 10

Question 9 of 10

9. What can be used interchangeably with MYSQL_VERSION_ID?

MYSQL_VERSION_ID

MYSQL_ID

LIBMYSQL_VERSION_ID

LIBMYSQL_VERSION

Question 9 of 10

Question 10 of 10

10. What sets up an association between one or more MyISAM tables and the named key cache?

ALTER DATABASE

ALTER EVENT

CACHE INDEX

BEGIN

Question 10 of 10