MySQL mcq questions and answers | MySQL MCQs Page-3 section-3

Section 1 Section 2 Section 3 Section 4 Section 5 Section 6 Section 7 Section 8 Section 9 Section 10 Section 11 Section 12

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

A. GLOBAL

B. SESSION

C. LOCAL

D. DEFAULT

Answer & Solution Discuss in Board Save for Later

22.
What is the need of "column Aliases" in "SELECT" clause?

A. To assign a new label to the column in result set

B. To overwrite the existing column name in result set

C. To modify the column name while using literals, Expression, built_in functions with "SELECT clause

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

23.

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

DELETE person
WHERE person_id<10;
/*person_id is a primary key */

A. 0-9

B. 1-7

C. No row

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

24.

The following MySQL statement belongs to which condition types?

SELECT fname
FROM person
WHERE fed_id=’111-11-111’;

A. Equality condition

B. Inequality condition

C. Range condition

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

25.
The function 'fetchrow_hashref()' returns reference to hash of row values keyed by . . . . . . . .

A. row name

B. column name

C. table name

D. database name

Answer & Solution Discuss in Board Save for Later

26.
Which variable is used to set table alias names as non-case sensitive?

A. lower_case_table_names

B. lower_case_all

C. lower_case_alias

D. lower_case_aliases

Answer & Solution Discuss in Board Save for Later

27.
Which keyword is used to search through natural language fulltext?

A. MATCH

B. AGAINST

C. SEARCH

D. FIND

Answer & Solution Discuss in Board Save for Later

28.

What is 'xyz' in the following SQL statement?

SELECT xyz FROM table1 UNION xyz FROM table2;

A. row name

B. column name

C. table name

D. database name

Answer & Solution Discuss in Board Save for Later

29.
The function that returns a reference to an array of row values is . . . . . . . .

A. fetchrow_array()

B. fetchrow_arrayref()

C. fetch()

D. fetchrow_hashref()

Answer & Solution Discuss in Board Save for Later

30.
The statement used to remove indexes on tables is . . . . . . . .

A. DROP INDEX

B. DELETE INDEX

C. REMOVE INDEX

D. FLUSH INDEX

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

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

Answer & Solution

22.
What is the need of "column Aliases" in "SELECT" clause?

Answer & Solution

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

`DELETE person WHERE person_id<10; /person_id is a primary key /`

Answer & Solution

24.
The following MySQL statement belongs to which condition types?

`SELECT fname FROM person WHERE fed_id=’111-11-111’;`

Answer & Solution

25.
The function 'fetchrow_hashref()' returns reference to hash of row values keyed by . . . . . . . .

Answer & Solution

26.
Which variable is used to set table alias names as non-case sensitive?

Answer & Solution

27.
Which keyword is used to search through natural language fulltext?

Answer & Solution

28.
What is 'xyz' in the following SQL statement?

`SELECT xyz FROM table1 UNION xyz FROM table2;`

Answer & Solution

29.
The function that returns a reference to an array of row values is . . . . . . . .

Answer & Solution

30.
The statement used to remove indexes on tables is . . . . . . . .

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

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

Answer & Solution

22. What is the need of "column Aliases" in "SELECT" clause?

Answer & Solution

23. In the following MySQL command how many rows will be deleted? DELETE person WHERE person_id<10; /*person_id is a primary key */

Answer & Solution

24. The following MySQL statement belongs to which condition types? SELECT fname FROM person WHERE fed_id=’111-11-111’;

Answer & Solution

25. The function 'fetchrow_hashref()' returns reference to hash of row values keyed by . . . . . . . .

Answer & Solution

26. Which variable is used to set table alias names as non-case sensitive?

Answer & Solution

27. Which keyword is used to search through natural language fulltext?

Answer & Solution

28. What is 'xyz' in the following SQL statement? SELECT xyz FROM table1 UNION xyz FROM table2;

Answer & Solution

29. The function that returns a reference to an array of row values is . . . . . . . .

Answer & Solution

30. The statement used to remove indexes on tables is . . . . . . . .

Answer & Solution

Read More Section(MySQL Miscellaneous)

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

22.
What is the need of "column Aliases" in "SELECT" clause?

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

`DELETE person WHERE person_id<10; /person_id is a primary key /`

24.
The following MySQL statement belongs to which condition types?

`SELECT fname FROM person WHERE fed_id=’111-11-111’;`

25.
The function 'fetchrow_hashref()' returns reference to hash of row values keyed by . . . . . . . .

26.
Which variable is used to set table alias names as non-case sensitive?

27.
Which keyword is used to search through natural language fulltext?

28.
What is 'xyz' in the following SQL statement?

`SELECT xyz FROM table1 UNION xyz FROM table2;`

29.
The function that returns a reference to an array of row values is . . . . . . . .

30.
The statement used to remove indexes on tables is . . . . . . . .