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

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.
The best datatype for a column that is expected to store values up to 2 million is . . . . . . . .

A. SMALLINT

B. TINYINT

C. MEDIUMINT

D. BIGINT

Answer & Solution Discuss in Board Save for Later

What will be the result of the following MySQL command?

WHERE TITLE=’teller’ OR start_date=’2007-01-01’

A. The employee is a teller and was employed prior to 2007

B. The employee is a teller and was employed after January 1, 2007

C. The employee is something other than a teller but was employed prior to 2007

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

If emp_id contain the following set {1, 2, 2, 3, 3, 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, 2, 2, 3, 3}

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

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

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

4.
The 'LAST_INSERT_ID()' is tied only to the 'AUTO_INCREMENT' values generated during the current connection to the server.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

5.
The MySQL server is poorly configurable.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

6.
The AUTO_INCREMENT column attribute is best used with which type?

A. FLOAT

B. INT

C. CHARACTER

D. DOUBLE

Answer & Solution Discuss in Board Save for Later

7.
The metadata log is . . . . . . . .

A. error log

B. ddl log

C. binary log

D. relay log

Answer & Solution Discuss in Board Save for Later

8.
In MyISAM tables, when a table is emptied with the TRUNCATE TABLE, the counter begins at . . . . . . . .

A. 0

B. 1

C. -1

D. arbitrary

Answer & Solution Discuss in Board Save for Later

9.
Which is the MySQL instance responsible for data processing?

A. MySQL client

B. MySQL server

C. SQL

D. Server daemon program

Answer & Solution Discuss in Board Save for Later

10.
Which file can be used to execute multiple compile statements?

A. makefile

B. dofile

C. putfile

D. pushfile

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

1.
The best datatype for a column that is expected to store values up to 2 million is . . . . . . . .

Answer & Solution

2.
What will be the result of the following MySQL command?

`WHERE TITLE=’teller’ OR start_date=’2007-01-01’`

Answer & Solution

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

`SELECT emp_id FROM person ORDER BY emp_id;`

Answer & Solution

4.
The 'LAST_INSERT_ID()' is tied only to the 'AUTO_INCREMENT' values generated during the current connection to the server.

Answer & Solution

5.
The MySQL server is poorly configurable.

Answer & Solution

6.
The AUTO_INCREMENT column attribute is best used with which type?

Answer & Solution

7.
The metadata log is . . . . . . . .

Answer & Solution

8.
In MyISAM tables, when a table is emptied with the TRUNCATE TABLE, the counter begins at . . . . . . . .

Answer & Solution

9.
Which is the MySQL instance responsible for data processing?

Answer & Solution

10.
Which file can be used to execute multiple compile statements?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

1. The best datatype for a column that is expected to store values up to 2 million is . . . . . . . .

Answer & Solution

2. What will be the result of the following MySQL command? WHERE TITLE=’teller’ OR start_date=’2007-01-01’

Answer & Solution

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

Answer & Solution

4. The 'LAST_INSERT_ID()' is tied only to the 'AUTO_INCREMENT' values generated during the current connection to the server.

Answer & Solution

5. The MySQL server is poorly configurable.

Answer & Solution

6. The AUTO_INCREMENT column attribute is best used with which type?

Answer & Solution

7. The metadata log is . . . . . . . .

Answer & Solution

8. In MyISAM tables, when a table is emptied with the TRUNCATE TABLE, the counter begins at . . . . . . . .

Answer & Solution

9. Which is the MySQL instance responsible for data processing?

Answer & Solution

10. Which file can be used to execute multiple compile statements?

Answer & Solution

Read More Section(MySQL Miscellaneous)

1.
The best datatype for a column that is expected to store values up to 2 million is . . . . . . . .

2.
What will be the result of the following MySQL command?

`WHERE TITLE=’teller’ OR start_date=’2007-01-01’`

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

`SELECT emp_id FROM person ORDER BY emp_id;`

4.
The 'LAST_INSERT_ID()' is tied only to the 'AUTO_INCREMENT' values generated during the current connection to the server.

5.
The MySQL server is poorly configurable.

6.
The AUTO_INCREMENT column attribute is best used with which type?

7.
The metadata log is . . . . . . . .

8.
In MyISAM tables, when a table is emptied with the TRUNCATE TABLE, the counter begins at . . . . . . . .

9.
Which is the MySQL instance responsible for data processing?

10.
Which file can be used to execute multiple compile statements?