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

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.
'fetchrow_hashref()' returns a reference to the hash of row values keyed by what?

A. row name

B. column name

C. table name

D. database name

Answer & Solution Discuss in Board Save for Later

92.
The file that can be used to execute multiple compile statements is . . . . . . . .

A. makefile

B. dofile

C. putfile

D. pushfile

Answer & Solution Discuss in Board Save for Later

93.
Hexadecimal numbers cannot be used in scientific notation.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

94.
A View can be used to select a subset of the table columns.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

95.
What is the command to disable autocommit and launch a transaction?

A. INITIATE TRANSACTION

B. START TRANSACTION

C. DISABLE AUTOCOMMIT

D. TRANSACTION

Answer & Solution Discuss in Board Save for Later

96.
Which among the following is the correct syntax for defining "Constraint Check" in Mysql?

A. gender char(1) check( gender IN ('M', 'F')),

B. gender char (1) check,

C. gender char (1) check ( gender ),

D. none of the mentioned

Answer & Solution Discuss in Board Save for Later

97.
The operator used in PHP to access property of an object is . . . . . . . .

A. .

B. *

C. ->

D. @

Answer & Solution Discuss in Board Save for Later

98.
The non handle array representing a row of values is . . . . . . . .

A. $rc

B. $rv

C. $rows

D. $ary

Answer & Solution Discuss in Board Save for Later

99.

If emp_id contain the following set {1, 2, 3, 4, 1, 1}, what will be the output on execution of the following MySQL statement?

SELECT emp_id
FROM person
ORDER BY emp_id;

A. {1, 1, 1, 2, 3, 4}

B. {1, 2, 3, 4, 1, 1}

C. {1, 1, 2, 3, 4, 1}

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

100.
What is the escape sequence for carriage return?

A. '\c'

B. '\r'

C. '\b'

D. '\z'

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

91.
'fetchrow_hashref()' returns a reference to the hash of row values keyed by what?

Answer & Solution

92.
The file that can be used to execute multiple compile statements is . . . . . . . .

Answer & Solution

93.
Hexadecimal numbers cannot be used in scientific notation.

Answer & Solution

94.
A View can be used to select a subset of the table columns.

Answer & Solution

95.
What is the command to disable autocommit and launch a transaction?

Answer & Solution

96.
Which among the following is the correct syntax for defining "Constraint Check" in Mysql?

Answer & Solution

97.
The operator used in PHP to access property of an object is . . . . . . . .

Answer & Solution

98.
The non handle array representing a row of values is . . . . . . . .

Answer & Solution

99.
If emp_id contain the following set {1, 2, 3, 4, 1, 1}, what will be the output on execution of the following MySQL statement?

`SELECT emp_id FROM person ORDER BY emp_id;`

Answer & Solution

100.
What is the escape sequence for carriage return?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

91. 'fetchrow_hashref()' returns a reference to the hash of row values keyed by what?

Answer & Solution

92. The file that can be used to execute multiple compile statements is . . . . . . . .

Answer & Solution

93. Hexadecimal numbers cannot be used in scientific notation.

Answer & Solution

94. A View can be used to select a subset of the table columns.

Answer & Solution

95. What is the command to disable autocommit and launch a transaction?

Answer & Solution

96. Which among the following is the correct syntax for defining "Constraint Check" in Mysql?

Answer & Solution

97. The operator used in PHP to access property of an object is . . . . . . . .

Answer & Solution

98. The non handle array representing a row of values is . . . . . . . .

Answer & Solution

99. If emp_id contain the following set {1, 2, 3, 4, 1, 1}, what will be the output on execution of the following MySQL statement? SELECT emp_id FROM person ORDER BY emp_id;

Answer & Solution

100. What is the escape sequence for carriage return?

Answer & Solution

Read More Section(MySQL Miscellaneous)

91.
'fetchrow_hashref()' returns a reference to the hash of row values keyed by what?

92.
The file that can be used to execute multiple compile statements is . . . . . . . .

93.
Hexadecimal numbers cannot be used in scientific notation.

94.
A View can be used to select a subset of the table columns.

95.
What is the command to disable autocommit and launch a transaction?

96.
Which among the following is the correct syntax for defining "Constraint Check" in Mysql?

97.
The operator used in PHP to access property of an object is . . . . . . . .

98.
The non handle array representing a row of values is . . . . . . . .

99.
If emp_id contain the following set {1, 2, 3, 4, 1, 1}, what will be the output on execution of the following MySQL statement?

`SELECT emp_id FROM person ORDER BY emp_id;`

100.
What is the escape sequence for carriage return?