MySQL mcq questions and answers | MySQL MCQs

Home / MySQL / MySQL Miscellaneous

51.
What is the statement used to select a default database?

Answer & Solution Discuss in Board Save for Later

52.
Multiple MySQL servers can be run on the same machine.

Answer & Solution Discuss in Board Save for Later

53.
Mysql command line tool is used to show "how many rows are returned and how long SQL command took to execute".

Answer & Solution Discuss in Board Save for Later

54.
Find the missing clause from the following SQL statement?
CREATE VIEW person_1 AS
SELECT fname, lname, person_id
_________ person;

Answer & Solution Discuss in Board Save for Later

55.
AUTO_INCREMENT columns must be NOT NULL.

Answer & Solution Discuss in Board Save for Later

56.
Which of these take more space?
Variable length columns, Fixed length columns

Answer & Solution Discuss in Board Save for Later

57.
The server listens on a network port for TCP/IP connections unless started with the option . . . . . . . .

Answer & Solution Discuss in Board Save for Later

58.
Stored routines refers to stored functions and procedures.

Answer & Solution Discuss in Board Save for Later

59.
The maximum length of the varchar columns is . . . . . . . .

Answer & Solution Discuss in Board Save for Later

60.
The keyword used with UNION that does not retain duplicate rows is . . . . . . . .

Answer & Solution Discuss in Board Save for Later

Read More Section(MySQL Miscellaneous)

Each Section contains maximum 100 MCQs question on MySQL Miscellaneous. To get more questions visit other sections.