MySQL mcq questions and answers | MySQL MCQs Page-8 section-3

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

71.
SPATIAL indexes cannot be created on NOT NULL spatial columns.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

72.

What will be the output of the following MySQL statement?

SELECT *
FROM employee
WHERE lname LIKE %t%f%n%;

A. All employees whose last name contain 't' in the second position

B. All employees whose last name contains 'f' in the fourth position

C. All employees whose last name contains 'n' in second last position

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

73.

Which of these is preferred when stored procedures are not being used?

CLIENT_MULTI_STATEMENTS, mysql_set_server_option()

A. CLIENT_MULTI_STATEMENTS

B. mysql_set_server_option()

C. any of the two

D. neither of the two

Answer & Solution Discuss in Board Save for Later

74.
Which among the following have the maximum bytes?

A. Varchar

B. Char

C. Text type

D. Both Varchar and Char

Answer & Solution Discuss in Board Save for Later

75.
The numbers that are prefixed with '0x' are in base . . . . . . . .

A. 8

B. 16

C. 32

D. 64

Answer & Solution Discuss in Board Save for Later

76.
The date and time datatype that stores time value in 'hh:mm:ss' format is . . . . . . . .

A. DATE

B. TIME

C. DATETIME

D. TIMESTAMP

Answer & Solution Discuss in Board Save for Later

77.
What is the mantissa in -1.58E5?

A. -1.58

B. 1.58

C. E

D. 5

Answer & Solution Discuss in Board Save for Later

78.
In PHP, how is the first element accessed if $a represents an array with numeric indices?

A. $a[1]

B. $a[0]

C. $a.1

D. $a.0

Answer & Solution Discuss in Board Save for Later

79.

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

SELECT emp_id
FROM person
ORDER BY emp_id;

A. {1, 2, 3, 4, 6, 7, 9}

B. {2, 1, 4, 3, 7, 9, 6}

C. {9, 7, 6, 4, 3, 1, 2}

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

80.
To use 'mysqldbcopy' which privileges are required on the source server?

A. CREATE

B. INSERT

C. UPDATE

D. SELECT

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

71.
SPATIAL indexes cannot be created on NOT NULL spatial columns.

Answer & Solution

72.
What will be the output of the following MySQL statement?

`SELECT * FROM employee WHERE lname LIKE %t%f%n%;`

Answer & Solution

73.
Which of these is preferred when stored procedures are not being used?

`CLIENT_MULTI_STATEMENTS, mysql_set_server_option()`

Answer & Solution

74.
Which among the following have the maximum bytes?

Answer & Solution

75.
The numbers that are prefixed with '0x' are in base . . . . . . . .

Answer & Solution

76.
The date and time datatype that stores time value in 'hh:mm:ss' format is . . . . . . . .

Answer & Solution

77.
What is the mantissa in -1.58E5?

Answer & Solution

78.
In PHP, how is the first element accessed if $a represents an array with numeric indices?

Answer & Solution

79.
If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the following MySQL statement?

`SELECT emp_id FROM person ORDER BY emp_id;`

Answer & Solution

80.
To use 'mysqldbcopy' which privileges are required on the source server?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

71. SPATIAL indexes cannot be created on NOT NULL spatial columns.

Answer & Solution

72. What will be the output of the following MySQL statement? SELECT * FROM employee WHERE lname LIKE %t%f%n%;

Answer & Solution

73. Which of these is preferred when stored procedures are not being used? CLIENT_MULTI_STATEMENTS, mysql_set_server_option()

Answer & Solution

74. Which among the following have the maximum bytes?

Answer & Solution

75. The numbers that are prefixed with '0x' are in base . . . . . . . .

Answer & Solution

76. The date and time datatype that stores time value in 'hh:mm:ss' format is . . . . . . . .

Answer & Solution

77. What is the mantissa in -1.58E5?

Answer & Solution

78. In PHP, how is the first element accessed if $a represents an array with numeric indices?

Answer & Solution

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

Answer & Solution

80. To use 'mysqldbcopy' which privileges are required on the source server?

Answer & Solution

Read More Section(MySQL Miscellaneous)

71.
SPATIAL indexes cannot be created on NOT NULL spatial columns.

72.
What will be the output of the following MySQL statement?

`SELECT * FROM employee WHERE lname LIKE %t%f%n%;`

73.
Which of these is preferred when stored procedures are not being used?

`CLIENT_MULTI_STATEMENTS, mysql_set_server_option()`

74.
Which among the following have the maximum bytes?

75.
The numbers that are prefixed with '0x' are in base . . . . . . . .

76.
The date and time datatype that stores time value in 'hh:mm:ss' format is . . . . . . . .

77.
What is the mantissa in -1.58E5?

78.
In PHP, how is the first element accessed if $a represents an array with numeric indices?

79.
If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the following MySQL statement?

`SELECT emp_id FROM person ORDER BY emp_id;`

80.
To use 'mysqldbcopy' which privileges are required on the source server?