MySQL mcq questions and answers | MySQL MCQs Page-10 section-6

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

91.
Which function returns a reference to hash of row values?

A. fetchrow_array()

B. fetchrow_arrayref()

C. fetch()

D. fetchrow_hashref()

Answer & Solution Discuss in Board Save for Later

92.
What is the default value of column?

A. NULL

B. 0

C. -1

D. Undefined

Answer & Solution Discuss in Board Save for Later

93.
The default definer of an event is the user who . . . . . . . .

A. created the database

B. created the event

C. created the table

D. created the column

Answer & Solution Discuss in Board Save for Later

94.

Which of these columns are faster?

Variable length, Fixed length

A. same

B. variable length

C. fixed length

D. indeterminate

Answer & Solution Discuss in Board Save for Later

95.

How many of the following use NULL to indicate failure?

mysql_init(), mysql_real_connect()

A. 0

B. 1

C. 2

D. 3

Answer & Solution Discuss in Board Save for Later

96.
What will be the output of the following MySQL statement "NOT (Null)"?

A. True

B. Null

C. False

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

97.
Numbers prefixed with '0x' are in base . . . . . . . .

A. 8

B. 16

C. 32

D. 64

Answer & Solution Discuss in Board Save for Later

98.
To convert an int to string, the function is . . . . . . . .

A. INET_ATON()

B. INET_NTOA()

C. INET_ITOS()

D. INET_STOI()

Answer & Solution Discuss in Board Save for Later

99.
In PHP, if $a represents an array with numeric indices, how is the first element accessed?

A. $a[1]

B. $a[0]

C. $a.1

D. $a.0

Answer & Solution Discuss in Board Save for Later

100.
Which system variable tells the optimizer to skip certain plans based on estimates of the number of rows accessed for each table?

A. optimizer_prune_level

B. optimizer_search_depth

C. optimizer_search

D. optimizer_prune

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

91.
Which function returns a reference to hash of row values?

Answer & Solution

92.
What is the default value of column?

Answer & Solution

93.
The default definer of an event is the user who . . . . . . . .

Answer & Solution

94.
Which of these columns are faster?

`Variable length, Fixed length`

Answer & Solution

95.
How many of the following use NULL to indicate failure?

`mysql_init(), mysql_real_connect()`

Answer & Solution

96.
What will be the output of the following MySQL statement "NOT (Null)"?

Answer & Solution

97.
Numbers prefixed with '0x' are in base . . . . . . . .

Answer & Solution

98.
To convert an int to string, the function is . . . . . . . .

Answer & Solution

99.
In PHP, if $a represents an array with numeric indices, how is the first element accessed?

Answer & Solution

100.
Which system variable tells the optimizer to skip certain plans based on estimates of the number of rows accessed for each table?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

91. Which function returns a reference to hash of row values?

Answer & Solution

92. What is the default value of column?

Answer & Solution

93. The default definer of an event is the user who . . . . . . . .

Answer & Solution

94. Which of these columns are faster? Variable length, Fixed length

Answer & Solution

95. How many of the following use NULL to indicate failure? mysql_init(), mysql_real_connect()

Answer & Solution

96. What will be the output of the following MySQL statement "NOT (Null)"?

Answer & Solution

97. Numbers prefixed with '0x' are in base . . . . . . . .

Answer & Solution

98. To convert an int to string, the function is . . . . . . . .

Answer & Solution

99. In PHP, if $a represents an array with numeric indices, how is the first element accessed?

Answer & Solution

100. Which system variable tells the optimizer to skip certain plans based on estimates of the number of rows accessed for each table?

Answer & Solution

Read More Section(MySQL Miscellaneous)

91.
Which function returns a reference to hash of row values?

92.
What is the default value of column?

93.
The default definer of an event is the user who . . . . . . . .

94.
Which of these columns are faster?

`Variable length, Fixed length`

95.
How many of the following use NULL to indicate failure?

`mysql_init(), mysql_real_connect()`

96.
What will be the output of the following MySQL statement "NOT (Null)"?

97.
Numbers prefixed with '0x' are in base . . . . . . . .

98.
To convert an int to string, the function is . . . . . . . .

99.
In PHP, if $a represents an array with numeric indices, how is the first element accessed?

100.
Which system variable tells the optimizer to skip certain plans based on estimates of the number of rows accessed for each table?