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

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 clause is used to remove a foreign key constraint?

A. REMOVE

B. DELETE

C. DROP

D. EXCLUDE

Answer & Solution Discuss in Board Save for Later

32.
The argument to the function mysql_error() is . . . . . . . .

A. integer

B. float

C. structure

D. pointer

Answer & Solution Discuss in Board Save for Later

33.
The datatype best suited to store currency values is . . . . . . . .

A. INT

B. FLOAT

C. DOUBLE

D. DECIMAL

Answer & Solution Discuss in Board Save for Later

34.
In which context is the privilege 'CREATE TABLESPACE' applied?

A. Server administration

B. Tables

C. Stored routines

D. Views

Answer & Solution Discuss in Board Save for Later

35.

How many of the following implement the default scheduling property of MySQL?

MyISAM, MERGE, MEMORY

A. 0

B. 1

C. 2

D. 3

Answer & Solution Discuss in Board Save for Later

36.
The binary protocol is easy to use.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

37.

What is the value of val2 in the following MySQL statement?

UPDATE t SET val1 = val1 + 2, val2 = val1;

A. previous val1

B. updated val1

C. unchanged

D. val1 + 1

Answer & Solution Discuss in Board Save for Later

38.
To create or drop events for a database, which privilege should be granted?

A. CREATE

B. DROP

C. PRIVILEGE

D. EVENT

Answer & Solution Discuss in Board Save for Later

39.
When building from source, the embedded server library is enabled by what?

A. -with-embedded-server

B. -with-server-embedded

C. -with-embedded-library

D. -with-library-embedded

Answer & Solution Discuss in Board Save for Later

40.
Which command is used on Mysql command line tool to return to window command shell?

A. exit

B. exit;

C. exit()

D. exit();

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

31.
Which clause is used to remove a foreign key constraint?

Answer & Solution

32.
The argument to the function mysql_error() is . . . . . . . .

Answer & Solution

33.
The datatype best suited to store currency values is . . . . . . . .

Answer & Solution

34.
In which context is the privilege 'CREATE TABLESPACE' applied?

Answer & Solution

35.
How many of the following implement the default scheduling property of MySQL?

`MyISAM, MERGE, MEMORY`

Answer & Solution

36.
The binary protocol is easy to use.

Answer & Solution

37.
What is the value of val2 in the following MySQL statement?

`UPDATE t SET val1 = val1 + 2, val2 = val1;`

Answer & Solution

38.
To create or drop events for a database, which privilege should be granted?

Answer & Solution

39.
When building from source, the embedded server library is enabled by what?

Answer & Solution

40.
Which command is used on Mysql command line tool to return to window command shell?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

31. Which clause is used to remove a foreign key constraint?

Answer & Solution

32. The argument to the function mysql_error() is . . . . . . . .

Answer & Solution

33. The datatype best suited to store currency values is . . . . . . . .

Answer & Solution

34. In which context is the privilege 'CREATE TABLESPACE' applied?

Answer & Solution

35. How many of the following implement the default scheduling property of MySQL? MyISAM, MERGE, MEMORY

Answer & Solution

36. The binary protocol is easy to use.

Answer & Solution

37. What is the value of val2 in the following MySQL statement? UPDATE t SET val1 = val1 + 2, val2 = val1;

Answer & Solution

38. To create or drop events for a database, which privilege should be granted?

Answer & Solution

39. When building from source, the embedded server library is enabled by what?

Answer & Solution

40. Which command is used on Mysql command line tool to return to window command shell?

Answer & Solution

Read More Section(MySQL Miscellaneous)

31.
Which clause is used to remove a foreign key constraint?

32.
The argument to the function mysql_error() is . . . . . . . .

33.
The datatype best suited to store currency values is . . . . . . . .

34.
In which context is the privilege 'CREATE TABLESPACE' applied?

35.
How many of the following implement the default scheduling property of MySQL?

`MyISAM, MERGE, MEMORY`

36.
The binary protocol is easy to use.

37.
What is the value of val2 in the following MySQL statement?

`UPDATE t SET val1 = val1 + 2, val2 = val1;`

38.
To create or drop events for a database, which privilege should be granted?

39.
When building from source, the embedded server library is enabled by what?

40.
Which command is used on Mysql command line tool to return to window command shell?