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

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.
Which function returns reference to array of row values?

A. fetchrow_array()

B. fetchrow_arrayref()

C. fetch()

D. fetchrow_hashref()

Answer & Solution Discuss in Board Save for Later

42.
Each language binding defines its own interface for accessing MySQL.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

43.
What sets up an association between one or more MyISAM tables and the named key cache?

A. BEGIN

B. CACHE INDEX

C. ALTER DATABASE

D. ALTER EVENT

Answer & Solution Discuss in Board Save for Later

44.
What is generally used as a synonym for CHARACTER SET?

A. CSET

B. CHSET

C. CHARSET

D. CHCSET

Answer & Solution Discuss in Board Save for Later

45.
Which of these is the metadata log?

A. error log

B. ddl log

C. binary log

D. relay log

Answer & Solution Discuss in Board Save for Later

46.
Which among the following is an optional Keyword?

A. DISTINICTS

B. ALL

C. AS

D. Both AS and ALL

Answer & Solution Discuss in Board Save for Later

47.
In the CREATE TABLE statement, the engine name specified is case insensitive.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

48.
The default index type for MEMORY tables is . . . . . . . .

A. HASH

B. SPATIAL

C. FULLTEXT

D. UNIQUE

Answer & Solution Discuss in Board Save for Later

49.
Which keyword is the synonym for DATABASE?

A. TABLE

B. OBJECT

C. DB

D. SCHEMA

Answer & Solution Discuss in Board Save for Later

50.
How many digits is the DECIMAL used for expressions containing only exact values with fractional part?

A. 32

B. 64

C. 65

D. 16

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9

MySQL mcq questions and answers | MySQL MCQs

41. Which function returns reference to array of row values?

Answer & Solution

42. Each language binding defines its own interface for accessing MySQL.

Answer & Solution

43. What sets up an association between one or more MyISAM tables and the named key cache?

Answer & Solution

44. What is generally used as a synonym for CHARACTER SET?

Answer & Solution

45. Which of these is the metadata log?

Answer & Solution

46. Which among the following is an optional Keyword?

Answer & Solution

47. In the CREATE TABLE statement, the engine name specified is case insensitive.

Answer & Solution

48. The default index type for MEMORY tables is . . . . . . . .

Answer & Solution

49. Which keyword is the synonym for DATABASE?

Answer & Solution

50. How many digits is the DECIMAL used for expressions containing only exact values with fractional part?

Answer & Solution

Read More Section(MySQL Miscellaneous)

41.
Which function returns reference to array of row values?

42.
Each language binding defines its own interface for accessing MySQL.

43.
What sets up an association between one or more MyISAM tables and the named key cache?

44.
What is generally used as a synonym for CHARACTER SET?

45.
Which of these is the metadata log?

46.
Which among the following is an optional Keyword?

47.
In the CREATE TABLE statement, the engine name specified is case insensitive.

48.
The default index type for MEMORY tables is . . . . . . . .

49.
Which keyword is the synonym for DATABASE?

50.
How many digits is the DECIMAL used for expressions containing only exact values with fractional part?