MySQL MCQs with answers Page - 8

Dear candidates you will find MCQ questions of MySQL here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

📊 MySQL
Q. Which property determines whether a database object is case sensitive?
  • (A) ATOMICITY
  • (B) NORMALIZATION
  • (C) COLLATION
  • (D) COLLABORATION
💬 Discuss
✅ Correct Answer: (C) COLLATION
📊 MySQL
Q. Which of the following is case sensitive in MySQL?
  • (A) Indexes
  • (B) Column names
  • (C) Event names
  • (D) Logfile group names
💬 Discuss
✅ Correct Answer: (D) Logfile group names
📊 MySQL
Q. Regardless of whether a database or table name is case sensitive on the system, it must be referred to using the same lettercase throughout a given query.
  • (A) False
  • (B) True
  • (C) ----
  • (D) ----
💬 Discuss
✅ Correct Answer: (B) True
📊 MySQL
Q. Which case does InnoDB store database names in?
  • (A) upper
  • (B) mixed
  • (C) random
  • (D) lower
💬 Discuss
✅ Correct Answer: (D) lower
📊 MySQL
Q. Which variable is used to set table alias names as non-case sensitive?
  • (A) lower_case_all
  • (B) lower_case_alias
  • (C) lower_case_aliases
  • (D) lower_case_table_names
💬 Discuss
✅ Correct Answer: (D) lower_case_table_names
📊 MySQL
Q. Which of the following is case sensitive?
  • (A) Stored procedure name
  • (B) Stored function name
  • (C) Event name
  • (D) Trigger name
💬 Discuss
✅ Correct Answer: (D) Trigger name
📊 MySQL
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
💬 Discuss
✅ Correct Answer: (B) Operating system of machine
📊 MySQL
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
💬 Discuss
✅ Correct Answer: (D) display contents of Student
📊 MySQL
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) ----
💬 Discuss
✅ Correct Answer: (A) False
📊 MySQL
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`
💬 Discuss
✅ Correct Answer: (C) SELECT * FROM `sampledb`.`member`

Programming Categories

📱 Download Our App

Learn MCQs on the go with our easy-to-use Android app

Get it on Google Play