MySQL mcq questions and answers | MySQL MCQs Page-7 section-1

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

61.
Which statement can be used for modifying the definition for an existing table?

A. ALTER

B. Modified

C. SELECT

D. FROM

Answer & Solution Discuss in Board Save for Later

62.
The function used to convert a string to an int is . . . . . . . .

A. INET_ATON()

B. INET_NTOA()

C. INET_ITOS()

D. INET_STOI()

Answer & Solution Discuss in Board Save for Later

63.
What jobs "Query Optimizer" perform in Mysql?

A. Determine the efficient way to execute a query

B. Syntax errors

C. Permissions

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

64.
The BIGINT precision is of bit . . . . . . . .

A. 32

B. 64

C. 128

D. 16

Answer & Solution Discuss in Board Save for Later

65.
The string function that returns the index of the first occurrence of substring is . . . . . . . .

A. INSERT()

B. INSTR()

C. INSTRING()

D. INFSTR()

Answer & Solution Discuss in Board Save for Later

66.
Multiple MySQL servers cannot be run on the same machine.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

67.
What does RTF refer to?

A. Rich Text Format

B. Right Text Format

C. Rich Text Function

D. Right Text Function

Answer & Solution Discuss in Board Save for Later

68.
The LOCAL capability for client library is enabled by . . . . . . . .

A. -enabled-local-file

B. -enable-local-infile

C. -enable-global-file

D. -enable-local-file

Answer & Solution Discuss in Board Save for Later

69.
The variable used as a handle to an open file is . . . . . . . .

A. $dbh

B. $sth

C. $fh

D. $h

Answer & Solution Discuss in Board Save for Later

70.
What is the maximum length for alias names in terms of characters?

A. 64

B. 128

C. 256

D. 32

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

MySQL mcq questions and answers | MySQL MCQs

61. Which statement can be used for modifying the definition for an existing table?

Answer & Solution

62. The function used to convert a string to an int is . . . . . . . .

Answer & Solution

63. What jobs "Query Optimizer" perform in Mysql?

Answer & Solution

64. The BIGINT precision is of bit . . . . . . . .

Answer & Solution

65. The string function that returns the index of the first occurrence of substring is . . . . . . . .

Answer & Solution

66. Multiple MySQL servers cannot be run on the same machine.

Answer & Solution

67. What does RTF refer to?

Answer & Solution

68. The LOCAL capability for client library is enabled by . . . . . . . .

Answer & Solution

69. The variable used as a handle to an open file is . . . . . . . .

Answer & Solution

70. What is the maximum length for alias names in terms of characters?

Answer & Solution

Read More Section(MySQL Miscellaneous)

61.
Which statement can be used for modifying the definition for an existing table?

62.
The function used to convert a string to an int is . . . . . . . .

63.
What jobs "Query Optimizer" perform in Mysql?

64.
The BIGINT precision is of bit . . . . . . . .

65.
The string function that returns the index of the first occurrence of substring is . . . . . . . .

66.
Multiple MySQL servers cannot be run on the same machine.

67.
What does RTF refer to?

68.
The LOCAL capability for client library is enabled by . . . . . . . .

69.
The variable used as a handle to an open file is . . . . . . . .

70.
What is the maximum length for alias names in terms of characters?