1.
Which of the following methods can be used to determine the storage engine of your table named "Country"?
- A.SHOW CREATE TABLE Country
- B.SHOW STORAGE ENGINE Country
- C.SHOW TABLE STATUS LIKE 'Country'
- D.SELECT ENGINE FROM INFORMATION SCHEMA TABLES WHERE TABLE_NAME='Country'
- Answer
- Report
Answer : [A,C,D]
2.
Which types of startup options can be configured for the server ?
- A.Location of important directories and files
- B.Logging setting
- C.Backing intervals
- D.Storage engine dependent options
- E.Performance related settings
- Answer
- Report
Answer : [A,B,D,E]
3.
When you upgrade from one version of MYSQL to another which of these steps are considered necessary ?
- A.Check the MYSQL Reference Manual upgrading section and read the parts that concern your upgrade
- B.Backup your databases
- C.Stop the MYSQL server
- D.Install the new version of MYSQL on top of the existing version
- E.Start the new server
- Answer
- Report
Answer : [A,B,C,D,E]
4.
MYSQL is a multi-threaded database server. Every connection to the database server is handled by it's own thread.
- A.True
- B.False
- Answer
- Report
Answer : [A]
5.
Which mysqld command line option disables incoming TCP/IP connections?
- A.--Shared-memory
- B.--Memlock
- C.--No-networking
- D.--Skip-networking
- Answer
- Report
Answer : [D]
|
|
||||||||||||||||||||||||||||
