MySQL mcq questions and answers | MySQL MCQs Page-9 section-1

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

81.
Each database has a data directory located under database directory.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

82.
The locking statements LOCK TABLES and UNLOCK TABLES are not permitted in stored routines.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

83.

The following MySQL query belongs to which condition types?

SELECT fname
FROM person
WHERE title=’TELLER’;

A. Equality condition

B. Inequality condition

C. Range condition

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

84.
Deletion of an employee from table also deletes that employee from another table. This kind of delete is called . . . . . . . .

A. transparent

B. concrete

C. elaborate

D. cascaded

Answer & Solution Discuss in Board Save for Later

85.
The default case sensitivity of the database and table names depends on . . . . . . . .

A. Server SQL mode

B. Operating system of machine

C. Does not depend on anything

D. SQL server

Answer & Solution Discuss in Board Save for Later

86.
What is the default format for "Year" data type?

A. YYYY

B. YYYY-DD-MM

C. MM-YYYY-DD

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

87.
Association between one or more MyISAM tables and the named key cache is set by . . . . . . . .

A. BEGIN

B. CACHE INDEX

C. ALTER DATABASE

D. ALTER EVENT

Answer & Solution Discuss in Board Save for Later

88.

In the following SQL code, InnoDB is . . . . . . . .

CREATE TABLE student (
		name CHAR(30),
		student_id INT,
		PRIMARY KEY (student_id)
	) ENGINE = InnoDB;

A. database name

B. table name

C. reference engine

D. storage engine

Answer & Solution Discuss in Board Save for Later

89.
Which command is used for showing current date and time in Mysql command line tool?

A. select now()

B. SELECT time();

C. SELECT currenttime()

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

90.
Which datatype means a variable length non binary string?

A. VARCHAR

B. BINARY

C. VARBINARY

D. BLOB

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

81.
Each database has a data directory located under database directory.

Answer & Solution

82.
The locking statements LOCK TABLES and UNLOCK TABLES are not permitted in stored routines.

Answer & Solution

83.
The following MySQL query belongs to which condition types?

`SELECT fname FROM person WHERE title=’TELLER’;`

Answer & Solution

84.
Deletion of an employee from table also deletes that employee from another table. This kind of delete is called . . . . . . . .

Answer & Solution

85.
The default case sensitivity of the database and table names depends on . . . . . . . .

Answer & Solution

86.
What is the default format for "Year" data type?

Answer & Solution

87.
Association between one or more MyISAM tables and the named key cache is set by . . . . . . . .

Answer & Solution

88.
In the following SQL code, InnoDB is . . . . . . . .

`CREATE TABLE student ( name CHAR(30), student_id INT, PRIMARY KEY (student_id) ) ENGINE = InnoDB;`

Answer & Solution

89.
Which command is used for showing current date and time in Mysql command line tool?

Answer & Solution

90.
Which datatype means a variable length non binary string?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

81. Each database has a data directory located under database directory.

Answer & Solution

82. The locking statements LOCK TABLES and UNLOCK TABLES are not permitted in stored routines.

Answer & Solution

83. The following MySQL query belongs to which condition types? SELECT fname FROM person WHERE title=’TELLER’;

Answer & Solution

84. Deletion of an employee from table also deletes that employee from another table. This kind of delete is called . . . . . . . .

Answer & Solution

85. The default case sensitivity of the database and table names depends on . . . . . . . .

Answer & Solution

86. What is the default format for "Year" data type?

Answer & Solution

87. Association between one or more MyISAM tables and the named key cache is set by . . . . . . . .

Answer & Solution

88. In the following SQL code, InnoDB is . . . . . . . . CREATE TABLE student ( name CHAR(30), student_id INT, PRIMARY KEY (student_id) ) ENGINE = InnoDB;

Answer & Solution

89. Which command is used for showing current date and time in Mysql command line tool?

Answer & Solution

90. Which datatype means a variable length non binary string?

Answer & Solution

Read More Section(MySQL Miscellaneous)

81.
Each database has a data directory located under database directory.

82.
The locking statements LOCK TABLES and UNLOCK TABLES are not permitted in stored routines.

83.
The following MySQL query belongs to which condition types?

`SELECT fname FROM person WHERE title=’TELLER’;`

84.
Deletion of an employee from table also deletes that employee from another table. This kind of delete is called . . . . . . . .

85.
The default case sensitivity of the database and table names depends on . . . . . . . .

86.
What is the default format for "Year" data type?

87.
Association between one or more MyISAM tables and the named key cache is set by . . . . . . . .

88.
In the following SQL code, InnoDB is . . . . . . . .

`CREATE TABLE student ( name CHAR(30), student_id INT, PRIMARY KEY (student_id) ) ENGINE = InnoDB;`

89.
Which command is used for showing current date and time in Mysql command line tool?

90.
Which datatype means a variable length non binary string?