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

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

1.
For which of these storage engines are configuration options always built?

A. Falcon

B. FEDERATED

C. InnoDB

D. MyISAM

Answer & Solution Discuss in Board Save for Later

2.
What is the non handle array representing a row of values?

A. $rc

B. $rv

C. $rows

D. $ary

Answer & Solution Discuss in Board Save for Later

Which of these has a bigger memory footprint?

Perl, PHP

A. Perl

B. PHP

C. same

D. machine dependent

Answer & Solution Discuss in Board Save for Later

4.
Which datatype is best suited to store currency values?

A. INT

B. FLOAT

C. DOUBLE

D. DECIMAL

Answer & Solution Discuss in Board Save for Later

5.
Mysql cannot be used to execute script files.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

6.
The log enabled by -relay-log-index is . . . . . . . .

A. relay log index

B. relay log

C. binary log

D. error log

Answer & Solution Discuss in Board Save for Later

7.
The maximum value that can be specified to the size of VARCHAR is . . . . . . . .

A. 0

B. 127

C. 1023

D. 65535

Answer & Solution Discuss in Board Save for Later

8.
A stored procedure is invoked using the statement . . . . . . . .

A. INVOKE

B. SEE

C. CALL

D. RETURN

Answer & Solution Discuss in Board Save for Later

9.
The statement that suspends the replication related activity of the slave server is . . . . . . . .

A. RESUME SLAVE

B. START SLAVE

C. STOP SLAVE

D. GET SLAVE

Answer & Solution Discuss in Board Save for Later

10.
The storage in bytes required for VARCHAR(4) type 'abcd' is . . . . . . . .

A. 1

B. 3

C. 5

D. 8

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

1.
For which of these storage engines are configuration options always built?

Answer & Solution

2.
What is the non handle array representing a row of values?

Answer & Solution

3.
Which of these has a bigger memory footprint?

`Perl, PHP`

Answer & Solution

4.
Which datatype is best suited to store currency values?

Answer & Solution

5.
Mysql cannot be used to execute script files.

Answer & Solution

6.
The log enabled by -relay-log-index is . . . . . . . .

Answer & Solution

7.
The maximum value that can be specified to the size of VARCHAR is . . . . . . . .

Answer & Solution

8.
A stored procedure is invoked using the statement . . . . . . . .

Answer & Solution

9.
The statement that suspends the replication related activity of the slave server is . . . . . . . .

Answer & Solution

10.
The storage in bytes required for VARCHAR(4) type 'abcd' is . . . . . . . .

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

1. For which of these storage engines are configuration options always built?

Answer & Solution

2. What is the non handle array representing a row of values?

Answer & Solution

3. Which of these has a bigger memory footprint? Perl, PHP

Answer & Solution

4. Which datatype is best suited to store currency values?

Answer & Solution

5. Mysql cannot be used to execute script files.

Answer & Solution

6. The log enabled by -relay-log-index is . . . . . . . .

Answer & Solution

7. The maximum value that can be specified to the size of VARCHAR is . . . . . . . .

Answer & Solution

8. A stored procedure is invoked using the statement . . . . . . . .

Answer & Solution

9. The statement that suspends the replication related activity of the slave server is . . . . . . . .

Answer & Solution

10. The storage in bytes required for VARCHAR(4) type 'abcd' is . . . . . . . .

Answer & Solution

Read More Section(MySQL Miscellaneous)

1.
For which of these storage engines are configuration options always built?

2.
What is the non handle array representing a row of values?

3.
Which of these has a bigger memory footprint?

`Perl, PHP`

4.
Which datatype is best suited to store currency values?

5.
Mysql cannot be used to execute script files.

6.
The log enabled by -relay-log-index is . . . . . . . .

7.
The maximum value that can be specified to the size of VARCHAR is . . . . . . . .

8.
A stored procedure is invoked using the statement . . . . . . . .

9.
The statement that suspends the replication related activity of the slave server is . . . . . . . .

10.
The storage in bytes required for VARCHAR(4) type 'abcd' is . . . . . . . .