This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “Using Views”. 1. Which of these is also known as a virtual table? a) SCHEMA b) DATABASE c) JOIN d) VIEW 2. A View can be used to select a subset of the table columns. a) True b) False 3. What is … Read more
This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “Table Retrievals with Union”. 1. To combine multiple retrievals, we write several SELECT statements and put the keyword between them. What is the keyword? a) COMBINE b) CONCAT c) JOIN d) UNION 2. What is ‘xyz’ in the following SQL statement? SELECT … Read more
This set of MySQL Interview Questions and Answers for freshers focuses on “Performing Multiple – Table Retrievals with Subqueries”. 1. The facility that allows nesting one select statement into another is called __________ a) nesting b) binding c) subquerying d) encapsulating 2. Which subquery returns a single value? a) scalar b) column c) row d) … Read more
This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “Performing Multiple – Table Retrievals with Joins”. 1. SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; Which of these is not optional? a) select_list b) table_list c) row_constraint d) grouping_columns 2. In inner join, result is produced by matching rows in … Read more
This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “Obtaining Database Metadata”. 1. The general term for information about databases and the objects in MySQL is _________ a) datum b) info c) record d) metadata 2. Which statement is used to determine the storage engine for individual tables? a) SHOW STATUS … Read more
This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “Creating, Dropping, Indexing and Altering Tables”. 1. Which statement is used to remove indexes on tables? a) DROP INDEX b) DELETE INDEX c) REMOVE INDEX d) FLUSH INDEX 2. Which storage engine is not available in MySQL 5.0? a) InnoDB b) ARCHIVE … Read more
This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “Selecting, Creating, Dropping and Altering Databases”. 1. Which statement is used to select a default database? a) USE b) CREATE c) DROP d) SCHEMA 2. Which keyword is the synonym for DATABASE? a) TABLE b) OBJECT c) DB d) SCHEMA 3. It … Read more
This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “Character Set Support”. 1. What is the maximum collations a character set can have? a) 0 b) 1 c) 2 d) more than 1 2. Unicode support is provided in MySQL. a) True b) False 3. Which clause can be used to … Read more
This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “Case Sensitivity in SQL Statements”. 1. Case sensitivity in SQL statements does not vary for different operating systems of the machine on which the server is running. a) True b) False 2. What is true about the following SQL statement? SELECT * … Read more
This set of MySQL Questions and Answers for Freshers focuses on “MySQL Identifier Syntax and Naming Rules”. 1. Which of the following characters is illegal in naming an unquoted identifier in SQL? a) _ b) $ c) 2 d) . 2. In MySQL, identifier names can start with a digit. a) True b) False 3. … Read more
