MySQL Questions and Answers – Storage Engine Configuration

This set of MySQL Database Multiple Choice Questions & Answers (MCQs) focuses on “Storage Engine Configuration”.

1. For which of these storage engines are configuration options always built?
a) Falcon
b) FEDERATED
c) InnoDB
d) MyISAM
View Answer

Answer: d
Explanation: The configuration options for the storage engine ‘MyISAM’ are always built. The runtime options for MyISAM are also always enabled. For the others, runtime options are explicitly enabled.

2. The storage engine for which the runtime options are always enabled is ______________
a) Falcon
b) FEDERATED
c) InnoDB
d) MEMORY
View Answer

Answer: d
Explanation: The configuration options for the storage engine ‘MEMORY’ are always built. The runtime options for ‘MEMORY’ are also always enabled. For the others, runtime options are explicitly enabled byt specifications.

3. The most important configurable resource for MyISAM is ______________
a) key cache
b) memory cache
c) time cache
d) speed cache
View Answer

Answer: a
Explanation: For the index processing, ‘MyISAM’ manages its own key cache, which is the most important configurable resource for the MyISAM storage engine. It is used for index based retrievals and sorts.
advertisement
advertisement

4. Which system variable enables mysqld to keep more tables open simultaneously?
a) table_cache
b) max_connect
c) delayed_queue_size
d) max_allowed_packet
View Answer

Answer: a
Explanation: The ‘table_cache’ stores the size of the table cache. Increasing the value enables ‘mysqld’ to keep more tables open simultaneously by reducing the number of files open and close operations.

5. xyz in the following MySQL statement is __________

Note: Join free Sanfoundry classes at Telegram or Youtube
CREATE VIEW xyz AS SELECT a, b FROM t;

a) table
b) column
c) view
d) database
View Answer

Answer: c
Explanation: A ‘View’ is created in MySQL by writing the clause ‘CREATE VIEW’ followed by the view name. Then follows the list of column names of the table that are to be presented as the view.
advertisement

6. abc in the following MySQL statement is ____________

CREATE VIEW xyz (abc) AS SELECT a FROM t;

a) row name
b) column name
c) view
d) database
View Answer

Answer: b
Explanation: Column names for a view can be explicitly provided in the ‘CREATE VIEW’ clause itself. It presents the table view with the aliased column names instead of the original column names.
advertisement

7. How can a view refer to multiple tables?
a) UNION
b) JOIN
c) GROUP
d) SELECT
View Answer

Answer: b
Explanation: In MySQL, a ‘View’ can refer to multiple tables. This makes it a lot simpler to execute the queries involving joins. When a selection is made from the view, the join is executed producing the results.

8. What is the mantissa in -1.58E5?
a) -1.58
b) 1.58
c) E
d) 5
View Answer

Answer: a
Explanation: In MySQL, the scientific notation for real numbers is possible. Some values are represented as floating point numbers in scientific notation consisting of a mantissa and exponent.

9. What is the precision of BIGINT?
a) 32
b) 64
c) 128
d) 16
View Answer

Answer: b
Explanation: In MySQL, for the expressions containing only exact values that are all integers, the evaluation uses BIGINT (64 – bit) precision. MySQL evaluates expressions using exact/approximate math.

10. How many digits is the DECIMAL used for expressions containing only exact values with fractional part?
a) 32
b) 64
c) 65
d) 16
View Answer

Answer: c
Explanation: In MySQL, for the expressions containing only exact values and where one or more values have a fractional part, the DECIMAL arithmetic is used with digits of precision equal to 65.

Sanfoundry Global Education & Learning Series – MySQL Database.

To practice all areas of MySQL Database, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.