MySQL mcq questions and answers | MySQL MCQs Page-3 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

21.
Which clause is used with an "aggregate functions"?

A. GROUP BY

B. SELECT

C. WHERE

D. Both GROUP BY and WHERE

Answer & Solution Discuss in Board Save for Later

22.
Which option enables multiple-statement execution?

A. CLIENT_MULTI_STATEMENTS

B. CLIENT_STATEMENTS_MULTI

C. MULTI_STATEMENTS_CLIENT

D. MULTI_CLIENTS_STATEMENTS

Answer & Solution Discuss in Board Save for Later

23.
What is the default path to Perl in Unix?

A. /usr/bin/perl

B. /usr/bin

C. /usr/perl

D. /usr/perl/bin

Answer & Solution Discuss in Board Save for Later

24.
Which among the following is the correct syntax for defining "ENUM" in Mysql?

A. gender ENUM ('M', 'F'),

B. gender ENUM,

C. gender ENUM ( ),

D. none of the mentioned

Answer & Solution Discuss in Board Save for Later

25.
Which statement is valid if '`sampledb`' is a database and '`tbl`' is a table in it?

A. SELECT * FROM `sampledb.member`

B. SELECT * FROM `sampledb`.`member`

C. SELECT * FROM `member`.`sampledb`

D. SELECT * FROM `member.sampledb`

Answer & Solution Discuss in Board Save for Later

26.
The information about table index characteristics is stored in which table of INFORMATION_SCHEMA?

A. FILES

B. STATISTICS

C. SCHEMATA

D. VIEWS

Answer & Solution Discuss in Board Save for Later

27.
The mysql client writes a record of executed statements to a history file on Unix.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

28.
What are X'61626364? and X'61626364??

A. abcd and 1633837924

B. abcd and 4297383361

C. dcba and 1633837924

D. dcba and 4297383361

Answer & Solution Discuss in Board Save for Later

29.

Stored programs refer to stored objects of how many of the following types?

functions, procedures, triggers, events

A. 0

B. 1

C. 3

D. 4

Answer & Solution Discuss in Board Save for Later

30.

How many of the following languages can interface to bind to the C API of MySQL?

Perl, PHP, Python

A. 0

B. 1

C. 2

D. 3

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

21.
Which clause is used with an "aggregate functions"?

Answer & Solution

22.
Which option enables multiple-statement execution?

Answer & Solution

23.
What is the default path to Perl in Unix?

Answer & Solution

24.
Which among the following is the correct syntax for defining "ENUM" in Mysql?

Answer & Solution

25.
Which statement is valid if '`sampledb`' is a database and '`tbl`' is a table in it?

Answer & Solution

26.
The information about table index characteristics is stored in which table of INFORMATION_SCHEMA?

Answer & Solution

27.
The mysql client writes a record of executed statements to a history file on Unix.

Answer & Solution

28.
What are X'61626364? and X'61626364??

Answer & Solution

29.
Stored programs refer to stored objects of how many of the following types?

`functions, procedures, triggers, events`

Answer & Solution

30.
How many of the following languages can interface to bind to the C API of MySQL?

`Perl, PHP, Python`

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

21. Which clause is used with an "aggregate functions"?

Answer & Solution

22. Which option enables multiple-statement execution?

Answer & Solution

23. What is the default path to Perl in Unix?

Answer & Solution

24. Which among the following is the correct syntax for defining "ENUM" in Mysql?

Answer & Solution

25. Which statement is valid if '`sampledb`' is a database and '`tbl`' is a table in it?

Answer & Solution

26. The information about table index characteristics is stored in which table of INFORMATION_SCHEMA?

Answer & Solution

27. The mysql client writes a record of executed statements to a history file on Unix.

Answer & Solution

28. What are X'61626364? and X'61626364??

Answer & Solution

29. Stored programs refer to stored objects of how many of the following types? functions, procedures, triggers, events

Answer & Solution

30. How many of the following languages can interface to bind to the C API of MySQL? Perl, PHP, Python

Answer & Solution

Read More Section(MySQL Miscellaneous)

21.
Which clause is used with an "aggregate functions"?

22.
Which option enables multiple-statement execution?

23.
What is the default path to Perl in Unix?

24.
Which among the following is the correct syntax for defining "ENUM" in Mysql?

25.
Which statement is valid if '`sampledb`' is a database and '`tbl`' is a table in it?

26.
The information about table index characteristics is stored in which table of INFORMATION_SCHEMA?

27.
The mysql client writes a record of executed statements to a history file on Unix.

28.
What are X'61626364? and X'61626364??

29.
Stored programs refer to stored objects of how many of the following types?

`functions, procedures, triggers, events`

30.
How many of the following languages can interface to bind to the C API of MySQL?

`Perl, PHP, Python`