MySQL mcq questions and answers | MySQL MCQs

Home / MySQL / MySQL Miscellaneous

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

41.
How can we define the clause "FROM" in Mysql?

A. It defines the tables used by a query

B. It defines the linking of tables in Mysql

C. It defines the tables used by a query & linking of tables in Mysql

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

42.
Which file is created by the server to store the database attributes?

A. db.otp

B. dp.zip

C. db.opt

D. db.cls

Answer & Solution Discuss in Board Save for Later

43.

How many of the following can be used in stored functions?

PREPARE, EXECUTE, DEALLOCATE PREPARE

A. 0

B. 1

C. 2

D. 3

Answer & Solution Discuss in Board Save for Later

44.

Which of these has a lower memory requirements?

mysql_use_result(), mysql_store_result()

A. mysql_use_result()

B. mysql_store_result()

C. same

D. machine dependent

Answer & Solution Discuss in Board Save for Later

45.
How many files does each end of a client/server connection including SSL support use to set up secure communications?

A. 0

B. 1

C. 2

D. 3

Answer & Solution Discuss in Board Save for Later

46.
The mode used to turn on strict mode and all of the additional restrictions is . . . . . . . .

A. STRICT_ALL_TABLES

B. ERROR_FOR_DIVISION_BY_ZERO

C. TRADITIONAL

D. ERROR_WHEN_DIVIDE_BY_ZERO

Answer & Solution Discuss in Board Save for Later

47.
What does the AUTO_INCREMENT sequences begin at by default?

A. 0

B. 1

C. -1

D. 2

Answer & Solution Discuss in Board Save for Later

48.

The number of languages that have interfaces to bind to the C API of MySQL among these is . . . . . . . .

Perl, PHP, Python

A. 0

B. 1

C. 2

D. 3

Answer & Solution Discuss in Board Save for Later

49.
Which clause is used to "Modify the existing field of the table"?

A. ALTER

B. FROM

C. SELECT

D. MODIFY

Answer & Solution Discuss in Board Save for Later

50.
The maximum non zero values for DOUBLE is . . . . . . . .

A. ±1.7976931348623157E+307

B. ±1.7976931348623157E+308

C. ±1.7976931348623157E+306

D. ±1.7976931348623157E+305

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

41.
How can we define the clause "FROM" in Mysql?

Answer & Solution

42.
Which file is created by the server to store the database attributes?

Answer & Solution

43.
How many of the following can be used in stored functions?

`PREPARE, EXECUTE, DEALLOCATE PREPARE`

Answer & Solution

44.
Which of these has a lower memory requirements?

`mysql_use_result(), mysql_store_result()`

Answer & Solution

45.
How many files does each end of a client/server connection including SSL support use to set up secure communications?

Answer & Solution

46.
The mode used to turn on strict mode and all of the additional restrictions is . . . . . . . .

Answer & Solution

47.
What does the AUTO_INCREMENT sequences begin at by default?

Answer & Solution

48.
The number of languages that have interfaces to bind to the C API of MySQL among these is . . . . . . . .

`Perl, PHP, Python`

Answer & Solution

49.
Which clause is used to "Modify the existing field of the table"?

Answer & Solution

50.
The maximum non zero values for DOUBLE is . . . . . . . .

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

41. How can we define the clause "FROM" in Mysql?

Answer & Solution

42. Which file is created by the server to store the database attributes?

Answer & Solution

43. How many of the following can be used in stored functions? PREPARE, EXECUTE, DEALLOCATE PREPARE

Answer & Solution

44. Which of these has a lower memory requirements? mysql_use_result(), mysql_store_result()

Answer & Solution

45. How many files does each end of a client/server connection including SSL support use to set up secure communications?

Answer & Solution

46. The mode used to turn on strict mode and all of the additional restrictions is . . . . . . . .

Answer & Solution

47. What does the AUTO_INCREMENT sequences begin at by default?

Answer & Solution

48. The number of languages that have interfaces to bind to the C API of MySQL among these is . . . . . . . . Perl, PHP, Python

Answer & Solution

49. Which clause is used to "Modify the existing field of the table"?

Answer & Solution

50. The maximum non zero values for DOUBLE is . . . . . . . .

Answer & Solution

Read More Section(MySQL Miscellaneous)

41.
How can we define the clause "FROM" in Mysql?

42.
Which file is created by the server to store the database attributes?

43.
How many of the following can be used in stored functions?

`PREPARE, EXECUTE, DEALLOCATE PREPARE`

44.
Which of these has a lower memory requirements?

`mysql_use_result(), mysql_store_result()`

45.
How many files does each end of a client/server connection including SSL support use to set up secure communications?

46.
The mode used to turn on strict mode and all of the additional restrictions is . . . . . . . .

47.
What does the AUTO_INCREMENT sequences begin at by default?

48.
The number of languages that have interfaces to bind to the C API of MySQL among these is . . . . . . . .

`Perl, PHP, Python`

49.
Which clause is used to "Modify the existing field of the table"?

50.
The maximum non zero values for DOUBLE is . . . . . . . .