MySQL mcq questions and answers | MySQL MCQs

Home / MySQL / MySQL Miscellaneous

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

51.
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

52.
What is the meaning of the "WHERE" clause in Mysql?

A. Filtering out unwanted rows from result set

B. Filtering out unwanted columns from result set

C. Filtering out unwanted rows and columns from result set

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

53.
Illegal values converted to the appropriate 'zero' value for . . . . . . . .

A. Numeric

B. String

C. ENUM

D. TIME

Answer & Solution Discuss in Board Save for Later

54.
What does the expression '12 DIV 5? evaluate to?

A. 2.4

B. 2

C. error

D. 0

Answer & Solution Discuss in Board Save for Later

55.
The function returning an array of row values is . . . . . . . .

A. fetchrow_array()

B. fetchrow_arrayref()

C. fetch()

D. fetchrow_hashref()

Answer & Solution Discuss in Board Save for Later

56.
The option that executes all SQL statements in a SQL script irrespective of the number of errors is . . . . . . . .

A. -run

B. -ensure

C. -force

D. -violent

Answer & Solution Discuss in Board Save for Later

57.

If emp_id contain the following set {-1, -2, 2, 3, -3, 1}, what will be the output on execution of the following MySQL statement?

SELECT emp_id
FROM person
ORDER BY emp_id;

A. {-3, -2, -1, 1, 2, 3}

B. {-1, 1, -2, 2, -3, 3}

C. {1, 2, 3, -1, -2, -3}

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

58.
The shebang line is . . . . . . . .

A. #!

B. !#

C. #$

D. $#

Answer & Solution Discuss in Board Save for Later

59.
Which statement is used for updating existing information in the table?

A. UPDATE

B. WHERE

C. MODIFY

D. ALTER

Answer & Solution Discuss in Board Save for Later

60.
Which type can store a collection of objects of any type?

A. GEOMETRYCOLLECTION

B. MULTIPOINT

C. MULTILINESTRING

D. MULTIPOLYGON

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

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

Answer & Solution

52.
What is the meaning of the "WHERE" clause in Mysql?

Answer & Solution

53.
Illegal values converted to the appropriate 'zero' value for . . . . . . . .

Answer & Solution

54.
What does the expression '12 DIV 5? evaluate to?

Answer & Solution

55.
The function returning an array of row values is . . . . . . . .

Answer & Solution

56.
The option that executes all SQL statements in a SQL script irrespective of the number of errors is . . . . . . . .

Answer & Solution

57.
If emp_id contain the following set {-1, -2, 2, 3, -3, 1}, what will be the output on execution of the following MySQL statement?

`SELECT emp_id FROM person ORDER BY emp_id;`

Answer & Solution

58.
The shebang line is . . . . . . . .

Answer & Solution

59.
Which statement is used for updating existing information in the table?

Answer & Solution

60.
Which type can store a collection of objects of any type?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

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

Answer & Solution

52. What is the meaning of the "WHERE" clause in Mysql?

Answer & Solution

53. Illegal values converted to the appropriate 'zero' value for . . . . . . . .

Answer & Solution

54. What does the expression '12 DIV 5? evaluate to?

Answer & Solution

55. The function returning an array of row values is . . . . . . . .

Answer & Solution

56. The option that executes all SQL statements in a SQL script irrespective of the number of errors is . . . . . . . .

Answer & Solution

57. If emp_id contain the following set {-1, -2, 2, 3, -3, 1}, what will be the output on execution of the following MySQL statement? SELECT emp_id FROM person ORDER BY emp_id;

Answer & Solution

58. The shebang line is . . . . . . . .

Answer & Solution

59. Which statement is used for updating existing information in the table?

Answer & Solution

60. Which type can store a collection of objects of any type?

Answer & Solution

Read More Section(MySQL Miscellaneous)

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

52.
What is the meaning of the "WHERE" clause in Mysql?

53.
Illegal values converted to the appropriate 'zero' value for . . . . . . . .

54.
What does the expression '12 DIV 5? evaluate to?

55.
The function returning an array of row values is . . . . . . . .

56.
The option that executes all SQL statements in a SQL script irrespective of the number of errors is . . . . . . . .

57.
If emp_id contain the following set {-1, -2, 2, 3, -3, 1}, what will be the output on execution of the following MySQL statement?

`SELECT emp_id FROM person ORDER BY emp_id;`

58.
The shebang line is . . . . . . . .

59.
Which statement is used for updating existing information in the table?

60.
Which type can store a collection of objects of any type?