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

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.
Which program performs logical backups?

A. mysqlimport

B. mysqldump

C. myslqpit

D. mysqllogic

Answer & Solution Discuss in Board Save for Later

2.
Which variable is used as a handle to an open file?

A. $dbh

B. $sth

C. $fh

D. $h

Answer & Solution Discuss in Board Save for Later

3.
If the storage engine InnoDB is not used, foreign key cannot be used.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

What will be the output of the following MySQL command?

SELECT fname
FROM person
WHERE emp_id != 6 OR emp_id IS  NULL;

A. Only those names whose emp_id is not equal to 6 or emp_id with NULL values

B. Only those names whose emp_id is not equal to 6

C. Only those names whose emp_id is equal to 6

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

5.
The myisamchk variable that represents the size of buffer used to hold index blocks is . . . . . . . .

A. key_buffer_size

B. read_buffer_size

C. sort_buffer_size

D. write_buffer_size

Answer & Solution Discuss in Board Save for Later

6.
Character data can be stored as . . . . . . . .

A. Fixed length string

B. Variable length string

C. Either Fixed or Variable length string

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

7.
What is the creation of a stored program similar to?

A. Trigger

B. Event

C. View

D. Table

Answer & Solution Discuss in Board Save for Later

8.
MySQL does not provide a date type that has an optional time part.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

9.
What will happen if the data being loaded into a text column exceeds the maximum size of that type?

A. Extra memory will be allocated

B. Process terminate

C. Data will be truncated

D. Depend on the system

Answer & Solution Discuss in Board Save for Later

10.
For REVOKE statements, the server automatically rereads the grant tables.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

1.
Which program performs logical backups?

Answer & Solution

2.
Which variable is used as a handle to an open file?

Answer & Solution

3.
If the storage engine InnoDB is not used, foreign key cannot be used.

Answer & Solution

4.
What will be the output of the following MySQL command?

`SELECT fname FROM person WHERE emp_id != 6 OR emp_id IS NULL;`

Answer & Solution

5.
The myisamchk variable that represents the size of buffer used to hold index blocks is . . . . . . . .

Answer & Solution

6.
Character data can be stored as . . . . . . . .

Answer & Solution

7.
What is the creation of a stored program similar to?

Answer & Solution

8.
MySQL does not provide a date type that has an optional time part.

Answer & Solution

9.
What will happen if the data being loaded into a text column exceeds the maximum size of that type?

Answer & Solution

10.
For REVOKE statements, the server automatically rereads the grant tables.

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

1. Which program performs logical backups?

Answer & Solution

2. Which variable is used as a handle to an open file?

Answer & Solution

3. If the storage engine InnoDB is not used, foreign key cannot be used.

Answer & Solution

4. What will be the output of the following MySQL command? SELECT fname FROM person WHERE emp_id != 6 OR emp_id IS NULL;

Answer & Solution

5. The myisamchk variable that represents the size of buffer used to hold index blocks is . . . . . . . .

Answer & Solution

6. Character data can be stored as . . . . . . . .

Answer & Solution

7. What is the creation of a stored program similar to?

Answer & Solution

8. MySQL does not provide a date type that has an optional time part.

Answer & Solution

9. What will happen if the data being loaded into a text column exceeds the maximum size of that type?

Answer & Solution

10. For REVOKE statements, the server automatically rereads the grant tables.

Answer & Solution

Read More Section(MySQL Miscellaneous)

1.
Which program performs logical backups?

2.
Which variable is used as a handle to an open file?

3.
If the storage engine InnoDB is not used, foreign key cannot be used.

4.
What will be the output of the following MySQL command?

`SELECT fname FROM person WHERE emp_id != 6 OR emp_id IS NULL;`

5.
The myisamchk variable that represents the size of buffer used to hold index blocks is . . . . . . . .

6.
Character data can be stored as . . . . . . . .

7.
What is the creation of a stored program similar to?

8.
MySQL does not provide a date type that has an optional time part.

9.
What will happen if the data being loaded into a text column exceeds the maximum size of that type?

10.
For REVOKE statements, the server automatically rereads the grant tables.