MySQL mcq questions and answers | MySQL MCQs Page-7 section-5

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.
What is the minimum value stored by signed TINYINT?

A. -256

B. -128

C. 0

D. 128

Answer & Solution Discuss in Board Save for Later

62.
What is used to reload a delimited text data file?

A. mysqldump

B. mysqld

C. mysqlimport

D. mysqlnaive

Answer & Solution Discuss in Board Save for Later

63.
What is the clause that filters JOIN results called?

A. WHERE

B. SORT

C. GROUP

D. GROUP BY

Answer & Solution Discuss in Board Save for Later

64.
What is the type of Audit_log_events system variable?

A. string

B. integer

C. float

D. double

Answer & Solution Discuss in Board Save for Later

65.
Which subquery returns a single value?

A. scalar

B. column

C. row

D. table

Answer & Solution Discuss in Board Save for Later

66.
Which mode tells cache queries that begin with SELECT SQL_CACHE?

A. 0

B. 1

C. 2

D. 3

Answer & Solution Discuss in Board Save for Later

67.
Which of the following table exist in Mysql?

A. Permanent Tables

B. Virtual tables

C. Temporary tables

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

68.
Which operator is used to perform integer divisions in MySQL?

A. /

B. \

C. DIV

D. //

Answer & Solution Discuss in Board Save for Later

69.
REPAIR TABLE does not work for . . . . . . . .

A. MyISAM

B. ARCHIVE

C. InnoDB

D. CSV

Answer & Solution Discuss in Board Save for Later

70.
To reload a delimited text data file use . . . . . . . .

A. mysqldump

B. mysqld

C. mysqlimport

D. mysqlnaive

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

MySQL mcq questions and answers | MySQL MCQs

61. What is the minimum value stored by signed TINYINT?

Answer & Solution

62. What is used to reload a delimited text data file?

Answer & Solution

63. What is the clause that filters JOIN results called?

Answer & Solution

64. What is the type of Audit_log_events system variable?

Answer & Solution

65. Which subquery returns a single value?

Answer & Solution

66. Which mode tells cache queries that begin with SELECT SQL_CACHE?

Answer & Solution

67. Which of the following table exist in Mysql?

Answer & Solution

68. Which operator is used to perform integer divisions in MySQL?

Answer & Solution

69. REPAIR TABLE does not work for . . . . . . . .

Answer & Solution

70. To reload a delimited text data file use . . . . . . . .

Answer & Solution

Read More Section(MySQL Miscellaneous)

61.
What is the minimum value stored by signed TINYINT?

62.
What is used to reload a delimited text data file?

63.
What is the clause that filters JOIN results called?

64.
What is the type of Audit_log_events system variable?

65.
Which subquery returns a single value?

66.
Which mode tells cache queries that begin with SELECT SQL_CACHE?

67.
Which of the following table exist in Mysql?

68.
Which operator is used to perform integer divisions in MySQL?

69.
REPAIR TABLE does not work for . . . . . . . .

70.
To reload a delimited text data file use . . . . . . . .