MySQL mcq questions and answers | MySQL MCQs Page-4 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

31.
Which among the following can also be included with "SELECT" clause while writing query in Mysql?

A. Literals

B. Expressions

C. User defined functions

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

32.
Which among the following are the correct representation of "float(4,2)"?

A. 24.33

B. 124.4

C. 12.123

D. Both 24.33 and 124.4

Answer & Solution Discuss in Board Save for Later

33.
Which statement is used to remove indexes on tables?

A. DROP INDEX

B. DELETE INDEX

C. REMOVE INDEX

D. FLUSH INDEX

Answer & Solution Discuss in Board Save for Later

34.
What is the general statement-issuing routine?

A. mysql_real_query()

B. mysql_query_real()

C. mysql_image_query()

D. mysql_query_image()

Answer & Solution Discuss in Board Save for Later

35.
What is the output from PHP?

A. statically generated

B. dynamically generated

C. not generated

D. no output

Answer & Solution Discuss in Board Save for Later

36.
Which character set variable indicates the character set used for storing identifiers?

A. character_set_system

B. character_set_server

C. collation_server

D. character_set_database

Answer & Solution Discuss in Board Save for Later

37.
The grant table that stores users who can connect to the server and their global privileges are . . . . . . . .

A. user

B. db

C. tables_priv

D. procs_priv

Answer & Solution Discuss in Board Save for Later

38.
Which storage engine enables to access tables from a MySQL server managed by another server?

A. InnoDB

B. EXAMPLE

C. MyISAM

D. FEDERATED

Answer & Solution Discuss in Board Save for Later

39.

What will be the output of the following MySQL command?

SELECT *
FROM employee
WHERE (title=’HEAD TELLER’) AND (start_date=2013-01-24);

A. All columns and rows belong to table employee

B. All columns but only those rows which contain 'HEAD TELLER' as a "title" and 2013-01-24 as a "start_date"

C. All rows belong to table employee

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

40.
To measure the length of a string in bytes, the operator used is . . . . . . . .

A. CHAR_LENGTH()

B. LENGTH()

C. LEN()

D. SIZE()

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

31.
Which among the following can also be included with "SELECT" clause while writing query in Mysql?

Answer & Solution

32.
Which among the following are the correct representation of "float(4,2)"?

Answer & Solution

33.
Which statement is used to remove indexes on tables?

Answer & Solution

34.
What is the general statement-issuing routine?

Answer & Solution

35.
What is the output from PHP?

Answer & Solution

36.
Which character set variable indicates the character set used for storing identifiers?

Answer & Solution

37.
The grant table that stores users who can connect to the server and their global privileges are . . . . . . . .

Answer & Solution

38.
Which storage engine enables to access tables from a MySQL server managed by another server?

Answer & Solution

39.
What will be the output of the following MySQL command?

`SELECT * FROM employee WHERE (title=’HEAD TELLER’) AND (start_date=2013-01-24);`

Answer & Solution

40.
To measure the length of a string in bytes, the operator used is . . . . . . . .

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

31. Which among the following can also be included with "SELECT" clause while writing query in Mysql?

Answer & Solution

32. Which among the following are the correct representation of "float(4,2)"?

Answer & Solution

33. Which statement is used to remove indexes on tables?

Answer & Solution

34. What is the general statement-issuing routine?

Answer & Solution

35. What is the output from PHP?

Answer & Solution

36. Which character set variable indicates the character set used for storing identifiers?

Answer & Solution

37. The grant table that stores users who can connect to the server and their global privileges are . . . . . . . .

Answer & Solution

38. Which storage engine enables to access tables from a MySQL server managed by another server?

Answer & Solution

39. What will be the output of the following MySQL command? SELECT * FROM employee WHERE (title=’HEAD TELLER’) AND (start_date=2013-01-24);

Answer & Solution

40. To measure the length of a string in bytes, the operator used is . . . . . . . .

Answer & Solution

Read More Section(MySQL Miscellaneous)

31.
Which among the following can also be included with "SELECT" clause while writing query in Mysql?

32.
Which among the following are the correct representation of "float(4,2)"?

33.
Which statement is used to remove indexes on tables?

34.
What is the general statement-issuing routine?

35.
What is the output from PHP?

36.
Which character set variable indicates the character set used for storing identifiers?

37.
The grant table that stores users who can connect to the server and their global privileges are . . . . . . . .

38.
Which storage engine enables to access tables from a MySQL server managed by another server?

39.
What will be the output of the following MySQL command?

`SELECT * FROM employee WHERE (title=’HEAD TELLER’) AND (start_date=2013-01-24);`

40.
To measure the length of a string in bytes, the operator used is . . . . . . . .