MySQL MCQs with answers Page - 8

Here, you will find a collection of MCQ questions on MySQL. Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 831.35K Points
Coach

Q. Which of the following is case sensitive?

  • (A) Stored procedure name
  • (B) Stored function name
  • (C) Event name
  • (D) Trigger name

A

Admin • 831.35K Points
Coach

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

  • (A) Does not depend on anything
  • (B) Operating system of machine
  • (C) SQL server
  • (D) Server SQL mode

A

Admin • 831.35K Points
Coach

Q. What is true about the following SQL statement?

Code: 
SELECT * FROM Student;
  • (A) display only column names in Student
  • (B) improper case being used
  • (C) invalid
  • (D) display contents of Student

A

Admin • 831.35K Points
Coach

Q. Case sensitivity in SQL statements does not vary for different operating systems of the machine on which the server is running

  • (A) False
  • (B) True
  • (C) ----
  • (D) ----

A

Admin • 831.35K Points
Coach

Q. Which of the following statements is valid if ‘`sampledb`’ is a database and ‘`tbl`’ is a table in it?

  • (A) SELECT * FROM `member`.`sampledb`
  • (B) SELECT * FROM `member.sampledb`
  • (C) SELECT * FROM `sampledb`.`member`
  • (D) SELECT * FROM `sampledb.member`

A

Admin • 831.35K Points
Coach

Q. If no database has been selected, specifying a database qualifier is necessary.

  • (A) False
  • (B) True
  • (C) ----
  • (D) ----

A

Admin • 831.35K Points
Coach

Q. What does a fully qualified table name consist of?

  • (A) only the database name
  • (B) only the table name
  • (C) database name followed by table name
  • (D) table name followed by database name

A

Admin • 831.35K Points
Coach

Q. What is the maximum length for alias names in terms of characters?

  • (A) 32
  • (B) 64
  • (C) 128
  • (D) 256

A

Admin • 831.35K Points
Coach

Q. Which server mode value disables use of built in function names as identifiers?

  • (A) TRADITIONAL
  • (B) IGNORE_SPACE
  • (C) IGNORE_FUNC
  • (D) ANSI

A

Admin • 831.35K Points
Coach

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

  • (A) PIPES_AS_CONCAT
  • (B) ANSI
  • (C) ANSI_QUOTES
  • (D) TRADITIONAL

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.