MySQL mcq questions and answers | MySQL MCQs Page-4 section-11

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

31.
Which table in INFORMATION_SCHEMA stores information about storage engines and server plugins?

A. ENGINES, PLUGINS

B. FILES, PLUGINS

C. ENGINES, FILES

D. PLUGINS, STATISTICS

Answer & Solution Discuss in Board Save for Later

32.
Which of the following is used on Solaris?

A. gcc

B. clang

C. Sun Studio

D. FreeBSD

Answer & Solution Discuss in Board Save for Later

33.
The slave stores the CHANGE MASTER parameters in the file . . . . . . . .

A. slave.info

B. slave.inf

C. master.info

D. master.inf

Answer & Solution Discuss in Board Save for Later

34.

How many of the following attributes are allowed only for numeric types?

UNSIGNED, ZEROFILL, CHARACTER SET, COLLATE

A. 1

B. 2

C. 3

D. 4

Answer & Solution Discuss in Board Save for Later

35.
The REAL type is synonym for . . . . . . . .

A. FLOAT

B. INT

C. DOUBLE

D. BIT

Answer & Solution Discuss in Board Save for Later

36.
The operator that compares sounds is . . . . . . . .

A. MATCH SOUNDS

B. CHECK SOUNDS

C. SOUNDS LIKE

D. SOUNDS SIMILAR

Answer & Solution Discuss in Board Save for Later

37.
In a single table (with 10 columns) join query the number of values needed to examine per column is . . . . . . . .

A. 1

B. 10

C. 0

D. 2

Answer & Solution Discuss in Board Save for Later

38.
The program that performs logical backups is . . . . . . . .

A. mysqlimport

B. mysqldump

C. myslqpit

D. mysqllogic

Answer & Solution Discuss in Board Save for Later

39.
The value of recently generated sequence number can be obtained by . . . . . . . .

A. LAST_INSERT_ID()

B. LATEST_INSERT_ID()

C. INITIAL_INSERT_ID()

D. INSERT_ID()

Answer & Solution Discuss in Board Save for Later

40.
What does 'C' stand for in the ACID property of transactions?

A. Compound

B. Concrete

C. Collision

D. Consistency

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

31.
Which table in INFORMATION_SCHEMA stores information about storage engines and server plugins?

Answer & Solution

32.
Which of the following is used on Solaris?

Answer & Solution

33.
The slave stores the CHANGE MASTER parameters in the file . . . . . . . .

Answer & Solution

34.
How many of the following attributes are allowed only for numeric types?

`UNSIGNED, ZEROFILL, CHARACTER SET, COLLATE`

Answer & Solution

35.
The REAL type is synonym for . . . . . . . .

Answer & Solution

36.
The operator that compares sounds is . . . . . . . .

Answer & Solution

37.
In a single table (with 10 columns) join query the number of values needed to examine per column is . . . . . . . .

Answer & Solution

38.
The program that performs logical backups is . . . . . . . .

Answer & Solution

39.
The value of recently generated sequence number can be obtained by . . . . . . . .

Answer & Solution

40.
What does 'C' stand for in the ACID property of transactions?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

31. Which table in INFORMATION_SCHEMA stores information about storage engines and server plugins?

Answer & Solution

32. Which of the following is used on Solaris?

Answer & Solution

33. The slave stores the CHANGE MASTER parameters in the file . . . . . . . .

Answer & Solution

34. How many of the following attributes are allowed only for numeric types? UNSIGNED, ZEROFILL, CHARACTER SET, COLLATE

Answer & Solution

35. The REAL type is synonym for . . . . . . . .

Answer & Solution

36. The operator that compares sounds is . . . . . . . .

Answer & Solution

37. In a single table (with 10 columns) join query the number of values needed to examine per column is . . . . . . . .

Answer & Solution

38. The program that performs logical backups is . . . . . . . .

Answer & Solution

39. The value of recently generated sequence number can be obtained by . . . . . . . .

Answer & Solution

40. What does 'C' stand for in the ACID property of transactions?

Answer & Solution

Read More Section(MySQL Miscellaneous)

31.
Which table in INFORMATION_SCHEMA stores information about storage engines and server plugins?

32.
Which of the following is used on Solaris?

33.
The slave stores the CHANGE MASTER parameters in the file . . . . . . . .

34.
How many of the following attributes are allowed only for numeric types?

`UNSIGNED, ZEROFILL, CHARACTER SET, COLLATE`

35.
The REAL type is synonym for . . . . . . . .

36.
The operator that compares sounds is . . . . . . . .

37.
In a single table (with 10 columns) join query the number of values needed to examine per column is . . . . . . . .

38.
The program that performs logical backups is . . . . . . . .

39.
The value of recently generated sequence number can be obtained by . . . . . . . .

40.
What does 'C' stand for in the ACID property of transactions?