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

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 is the correct decreasing order for highly developed text manipulation capabilities?

A. Perl, PHP, C

B. Perl, C, PHP

C. PHP, Perl, C

D. C, PHP, Perl

Answer & Solution Discuss in Board Save for Later

32.
Which privilege must be given to the database to create a stored function or procedure?

A. CREATE ROUTINE

B. CREATE METHOD

C. CREATE FUNCTION

D. CREATE PROCEDURE

Answer & Solution Discuss in Board Save for Later

33.
For which language is the engine specific interface PDO defined?

A. Python

B. Perl

C. PHP

D. C

Answer & Solution Discuss in Board Save for Later

34.
Which keyword used with UNION does not retain duplicate rows?

A. ALL

B. NARROW

C. STRICT

D. DISTINCT

Answer & Solution Discuss in Board Save for Later

35.
OS imposes per process limits on the number of open file descriptors.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

36.
Which among the following belongs to an "aggregate function"?

A. COUNT

B. UPPER

C. LOWER

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

37.
Triggers are not supported for . . . . . . . .

A. delete

B. update

C. insert

D. views

Answer & Solution Discuss in Board Save for Later

38.
The system variable controls the size of the table cache . . . . . . . .

A. table_cache

B. cache_table

C. open_cache

D. cache_open

Answer & Solution Discuss in Board Save for Later

39.
The case sensitive among these is . . . . . . . .

A. Stored function name

B. Stored procedure name

C. Trigger name

D. Event name

Answer & Solution Discuss in Board Save for Later

40.
The size of the BIT type is . . . . . . . .

A. 1

B. 2

C. 3

D. variable

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

MySQL mcq questions and answers | MySQL MCQs

31. Which is the correct decreasing order for highly developed text manipulation capabilities?

Answer & Solution

32. Which privilege must be given to the database to create a stored function or procedure?

Answer & Solution

33. For which language is the engine specific interface PDO defined?

Answer & Solution

34. Which keyword used with UNION does not retain duplicate rows?

Answer & Solution

35. OS imposes per process limits on the number of open file descriptors.

Answer & Solution

36. Which among the following belongs to an "aggregate function"?

Answer & Solution

37. Triggers are not supported for . . . . . . . .

Answer & Solution

38. The system variable controls the size of the table cache . . . . . . . .

Answer & Solution

39. The case sensitive among these is . . . . . . . .

Answer & Solution

40. The size of the BIT type is . . . . . . . .

Answer & Solution

Read More Section(MySQL Miscellaneous)

31.
Which is the correct decreasing order for highly developed text manipulation capabilities?

32.
Which privilege must be given to the database to create a stored function or procedure?

33.
For which language is the engine specific interface PDO defined?

34.
Which keyword used with UNION does not retain duplicate rows?

35.
OS imposes per process limits on the number of open file descriptors.

36.
Which among the following belongs to an "aggregate function"?

37.
Triggers are not supported for . . . . . . . .

38.
The system variable controls the size of the table cache . . . . . . . .

39.
The case sensitive among these is . . . . . . . .

40.
The size of the BIT type is . . . . . . . .