MySQL Mock Test 2 - Sanfoundry

10%

Question 1 of 10

1. Suppose it is desired that UNION operation should return not more than 3 rows. Which keyword is used for this?

COUNT

RESTRICT

LIMIT

SORT

Question 1 of 10

Question 2 of 10

2. What is abc in the following MySQL statement?

	SELECT * FROM my_table WHERE MATCH(abc) AGAINST('xyz');

column name

search string

table name

database name

Question 2 of 10

Question 3 of 10

3. The ALL subquery performs which operation?

row

database

table

column

Question 3 of 10

Question 4 of 10

4. Which search mode uses natural language search as a subroutine?

Natural language

Cross mode

Boolean mode

Query expansion

Question 4 of 10

Question 5 of 10

5. Which key declares that an index in one table is related to that in another?

secondary

foreign

cross

primary

Question 5 of 10

Question 6 of 10

6. If attribute “fruit” stores data as “apple, mango, banana” in table person then what will be the output of the following SQL command?

    SELECT fruit FROM person
    WHERE person_id=1
    ORDER BY fruit;

apple, mango, banana

none of the mentioned

mango, apple, banana

apple, banana, mango

Question 6 of 10

Question 7 of 10

7. Which command is used on Mysql command line tool to return to window command shell?

exit();

exit()

exit

exit;

Question 7 of 10

Question 8 of 10

8. A FULLTEXT index cannot be created for multiple columns.

False

True

Question 8 of 10

Question 9 of 10

9. Which keyword is used to delete all the rows from the table?

TRUNCATE

CLEAR

REMOVE

DELETE ALL

Question 9 of 10

Question 10 of 10

10. What is the durability property of transactions?

database remains consistent

statements form a logic unit

one transaction does not affect the other

transaction effects are recorded permanently

Question 10 of 10