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

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.
If $a represents an array with numeric indices in PHP, the first element accessed by . . . . . . . .

A. $a[1]

B. $a[0]

C. $a.1

D. $a.0

Answer & Solution Discuss in Board Save for Later

72.
The variable that checks for availability of SSL support is . . . . . . . .

A. have_ssl

B. has_ssl

C. avail_ssl

D. ssl_avail

Answer & Solution Discuss in Board Save for Later

73.
Which option turns on the -extended-insert?

A. -opt

B. -opti

C. -op

D. -optimize

Answer & Solution Discuss in Board Save for Later

74.
An embedded application includes the server side and client side.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

75.
To reactivate indexes the command used is . . . . . . . .

A. DISABLE KEYS

B. DISABLE INDEXES

C. ENABLE KEYS

D. ENABLE INDEXES

Answer & Solution Discuss in Board Save for Later

76.

What will be the order of sorting in the following MySQL statement?

SELECT emp_id, emp_name
FROM person
ORDER BY emp_id, emp_name;

A. Sorting {emp_id, emp_name}

B. Sorting {emp_name, emp_id}

C. Sorting (emp_id} but not emp_name

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

77.
Which keyword is used to create a table as a temporary copy of itself?

A. TEMP

B. TEMPO

C. TEMPR

D. TEMPORARY

Answer & Solution Discuss in Board Save for Later

78.
Which function returns NULL if expr1 = expr2?

A. CASE

B. IF()

C. IFNULL()

D. NULLIF()

Answer & Solution Discuss in Board Save for Later

79.
What performs a key distribution analysis and stores the distribution for the named table or tables?

A. ANALYZE TABLE

B. CHECK TABLE

C. CHECKSUM TABLE

D. OPTIMIZE TABLE

Answer & Solution Discuss in Board Save for Later

80.
In inner join, result is produced by matching rows in one table with rows in another table.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

71.
If $a represents an array with numeric indices in PHP, the first element accessed by . . . . . . . .

Answer & Solution

72.
The variable that checks for availability of SSL support is . . . . . . . .

Answer & Solution

73.
Which option turns on the -extended-insert?

Answer & Solution

74.
An embedded application includes the server side and client side.

Answer & Solution

75.
To reactivate indexes the command used is . . . . . . . .

Answer & Solution

76.
What will be the order of sorting in the following MySQL statement?

`SELECT emp_id, emp_name FROM person ORDER BY emp_id, emp_name;`

Answer & Solution

77.
Which keyword is used to create a table as a temporary copy of itself?

Answer & Solution

78.
Which function returns NULL if expr1 = expr2?

Answer & Solution

79.
What performs a key distribution analysis and stores the distribution for the named table or tables?

Answer & Solution

80.
In inner join, result is produced by matching rows in one table with rows in another table.

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

71. If $a represents an array with numeric indices in PHP, the first element accessed by . . . . . . . .

Answer & Solution

72. The variable that checks for availability of SSL support is . . . . . . . .

Answer & Solution

73. Which option turns on the -extended-insert?

Answer & Solution

74. An embedded application includes the server side and client side.

Answer & Solution

75. To reactivate indexes the command used is . . . . . . . .

Answer & Solution

76. What will be the order of sorting in the following MySQL statement? SELECT emp_id, emp_name FROM person ORDER BY emp_id, emp_name;

Answer & Solution

77. Which keyword is used to create a table as a temporary copy of itself?

Answer & Solution

78. Which function returns NULL if expr1 = expr2?

Answer & Solution

79. What performs a key distribution analysis and stores the distribution for the named table or tables?

Answer & Solution

80. In inner join, result is produced by matching rows in one table with rows in another table.

Answer & Solution

Read More Section(MySQL Miscellaneous)

71.
If $a represents an array with numeric indices in PHP, the first element accessed by . . . . . . . .

72.
The variable that checks for availability of SSL support is . . . . . . . .

73.
Which option turns on the -extended-insert?

74.
An embedded application includes the server side and client side.

75.
To reactivate indexes the command used is . . . . . . . .

76.
What will be the order of sorting in the following MySQL statement?

`SELECT emp_id, emp_name FROM person ORDER BY emp_id, emp_name;`

77.
Which keyword is used to create a table as a temporary copy of itself?

78.
Which function returns NULL if expr1 = expr2?

79.
What performs a key distribution analysis and stores the distribution for the named table or tables?

80.
In inner join, result is produced by matching rows in one table with rows in another table.