MySQL mcq questions and answers | MySQL MCQs

Home / MySQL / MySQL Miscellaneous

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

21.

What is true about the following SQL statement?

SELECT * FROM table_1;

A. invalid

B. display contents of table_1

C. improper case being used

D. display only column names in table_1

Answer & Solution Discuss in Board Save for Later

22.
The key declares that an index in one table is related to that in another is called . . . . . . . .

A. primary

B. secondary

C. foreign

D. cross

Answer & Solution Discuss in Board Save for Later

23.
SBR replication is . . . . . . . .

A. Statement based

B. Row based

C. Column based

D. Table based

Answer & Solution Discuss in Board Save for Later

24.
If a column contains 7 values and 6 distinct values, the cardinality is . . . . . . . .

A. 7

B. 6

C. 13

D. 1

Answer & Solution Discuss in Board Save for Later

25.
What is the maximum number of characters allowed for a database name to have?

A. 16

B. 32

C. 64

D. 128

Answer & Solution Discuss in Board Save for Later

26.
If a column is expected to store values up to 2 million, the best datatype for it is . . . . . . . .

A. SMALLINT

B. TINYINT

C. MEDIUMINT

D. BIGINT

Answer & Solution Discuss in Board Save for Later

27.
Which line of the following statements will produce error?

A. SELECT * FROM person WHERE person_id=1;

B. SELECT pname FROM person;

C. SELECT pname, lname, person_id FROM person;

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

28.
What is the maximum non zero value for FLOAT?

A. 3.402823466E+38

B. 3.402823466E+37

C. 3.402823466E+39

D. 3.402823466E+35

Answer & Solution Discuss in Board Save for Later

29.
Which server mode value enables use of double quotes to wrap identifier names?

A. ANSI

B. ANSI_QUOTES

C. TRADITIONAL

D. PIPES_AS_CONCAT

Answer & Solution Discuss in Board Save for Later

30.
The slow query log can be used to identify queries that may be performing badly.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

21.
What is true about the following SQL statement?

`SELECT * FROM table_1;`

Answer & Solution

22.
The key declares that an index in one table is related to that in another is called . . . . . . . .

Answer & Solution

23.
SBR replication is . . . . . . . .

Answer & Solution

24.
If a column contains 7 values and 6 distinct values, the cardinality is . . . . . . . .

Answer & Solution

25.
What is the maximum number of characters allowed for a database name to have?

Answer & Solution

26.
If a column is expected to store values up to 2 million, the best datatype for it is . . . . . . . .

Answer & Solution

27.
Which line of the following statements will produce error?

Answer & Solution

28.
What is the maximum non zero value for FLOAT?

Answer & Solution

29.
Which server mode value enables use of double quotes to wrap identifier names?

Answer & Solution

30.
The slow query log can be used to identify queries that may be performing badly.

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

21. What is true about the following SQL statement? SELECT * FROM table_1;

Answer & Solution

22. The key declares that an index in one table is related to that in another is called . . . . . . . .

Answer & Solution

23. SBR replication is . . . . . . . .

Answer & Solution

24. If a column contains 7 values and 6 distinct values, the cardinality is . . . . . . . .

Answer & Solution

25. What is the maximum number of characters allowed for a database name to have?

Answer & Solution

26. If a column is expected to store values up to 2 million, the best datatype for it is . . . . . . . .

Answer & Solution

27. Which line of the following statements will produce error?

Answer & Solution

28. What is the maximum non zero value for FLOAT?

Answer & Solution

29. Which server mode value enables use of double quotes to wrap identifier names?

Answer & Solution

30. The slow query log can be used to identify queries that may be performing badly.

Answer & Solution

Read More Section(MySQL Miscellaneous)

21.
What is true about the following SQL statement?

`SELECT * FROM table_1;`

22.
The key declares that an index in one table is related to that in another is called . . . . . . . .

23.
SBR replication is . . . . . . . .

24.
If a column contains 7 values and 6 distinct values, the cardinality is . . . . . . . .

25.
What is the maximum number of characters allowed for a database name to have?

26.
If a column is expected to store values up to 2 million, the best datatype for it is . . . . . . . .

27.
Which line of the following statements will produce error?

28.
What is the maximum non zero value for FLOAT?

29.
Which server mode value enables use of double quotes to wrap identifier names?

30.
The slow query log can be used to identify queries that may be performing badly.