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

61.
Which line is written at the top of the script to write a Perl script using CGI.pm?

A. use this CGI

B. put CGI

C. use CGI

D. include CGI

Answer & Solution Discuss in Board Save for Later

62.
The search mode that uses natural language search as a subroutine is . . . . . . . .

A. Natural language

B. Boolean mode

C. Query expansion

D. Cross mode

Answer & Solution Discuss in Board Save for Later

63.
What is the meaning of "Temporary Tables" in Mysql?

A. Rows returned by sub query

B. Permanent tables

C. Virtual tables

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

64.
The header that should be included first is . . . . . . . .

A. my_global.h

B. my_sys.h

C. mysql.h

D. my_local.h

Answer & Solution Discuss in Board Save for Later

65.
Bulk loading is less efficient than single row loading.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

66.
Which among the following operators is/are belongs to "Inequality conditions"?

A. <>

B. !=

C. =

D. Both <> and !=

Answer & Solution Discuss in Board Save for Later

67.
The property of InnoDB that enforces foreign key relationships stay intact is called . . . . . . . .

A. atomicity

B. durability

C. consistency

D. referential integrity

Answer & Solution Discuss in Board Save for Later

68.
CGI.pm does not support an object oriented style of use.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

69.

What will be the output of the following MySQL command?

SELECT fname
FROM person
WHERE emp_id != 6;

A. Only those names whose emp_id is not equal to 6

B. Only those names whose emp_id is equal to 6

C. No output

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

70.
Which option is supplied to ensure TCP/IP connection to local server?

A. -localhost

B. -host

C. -hostlocal

D. -connectlocal

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

61.
Which line is written at the top of the script to write a Perl script using CGI.pm?

Answer & Solution

62.
The search mode that uses natural language search as a subroutine is . . . . . . . .

Answer & Solution

63.
What is the meaning of "Temporary Tables" in Mysql?

Answer & Solution

64.
The header that should be included first is . . . . . . . .

Answer & Solution

65.
Bulk loading is less efficient than single row loading.

Answer & Solution

66.
Which among the following operators is/are belongs to "Inequality conditions"?

Answer & Solution

67.
The property of InnoDB that enforces foreign key relationships stay intact is called . . . . . . . .

Answer & Solution

68.
CGI.pm does not support an object oriented style of use.

Answer & Solution

69.
What will be the output of the following MySQL command?

`SELECT fname FROM person WHERE emp_id != 6;`

Answer & Solution

70.
Which option is supplied to ensure TCP/IP connection to local server?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

61. Which line is written at the top of the script to write a Perl script using CGI.pm?

Answer & Solution

62. The search mode that uses natural language search as a subroutine is . . . . . . . .

Answer & Solution

63. What is the meaning of "Temporary Tables" in Mysql?

Answer & Solution

64. The header that should be included first is . . . . . . . .

Answer & Solution

65. Bulk loading is less efficient than single row loading.

Answer & Solution

66. Which among the following operators is/are belongs to "Inequality conditions"?

Answer & Solution

67. The property of InnoDB that enforces foreign key relationships stay intact is called . . . . . . . .

Answer & Solution

68. CGI.pm does not support an object oriented style of use.

Answer & Solution

69. What will be the output of the following MySQL command? SELECT fname FROM person WHERE emp_id != 6;

Answer & Solution

70. Which option is supplied to ensure TCP/IP connection to local server?

Answer & Solution

Read More Section(MySQL Miscellaneous)

61.
Which line is written at the top of the script to write a Perl script using CGI.pm?

62.
The search mode that uses natural language search as a subroutine is . . . . . . . .

63.
What is the meaning of "Temporary Tables" in Mysql?

64.
The header that should be included first is . . . . . . . .

65.
Bulk loading is less efficient than single row loading.

66.
Which among the following operators is/are belongs to "Inequality conditions"?

67.
The property of InnoDB that enforces foreign key relationships stay intact is called . . . . . . . .

68.
CGI.pm does not support an object oriented style of use.

69.
What will be the output of the following MySQL command?

`SELECT fname FROM person WHERE emp_id != 6;`

70.
Which option is supplied to ensure TCP/IP connection to local server?