MySQL Answer as soon as possible Multiple Choice 1. As of MySQL 5.5, which of th

Question

MySQL
Answer as soon as possible
Multiple Choice

1. As of MySQL 5.5, which of the following is the default table storage engine?
(a) Blackhole
(b) SuperNova
(c) Memory
(d) MyISAM
(e) InnoDB

2. Which of the following is NOT a MySQL table storage engine?
(a) Blackhole
(b) SuperNova
(c) MyISAM
(d) MRG_MyISAM
(e) InnoDB

3. MySQL 8 is the first version that supports JSON Objects.
(a) True
(b) False

4. Which of the following is not a command for determining if MySQL is running on Linux (Ubuntu)?
(a) sudo service mysql status
(b) ps -ef | grep 'mysql'
(c) sudo check status mysql
(d) sudo systemctl status mysql

5. In Windows, the only was to start/stop MySQL Server is from the Command Prompt.
(a) True
(b) False

Explanation / Answer

1.InnoDB is the default storage engine as of MySQL 5.5

other non-default engines are
PERFORMANCE_SCHEMA
MRG_MYISAM
BLACKHOLE
MyISAM

2.
SuperNova is NOT a MySQL table storage engine

3. False
MySQL supports the native JSON data type since version 5.7.8.

4.
sudo check status mysql is not a command for for determining if MySQL is running on Linux

5.
There are 2 ways to start/stop mysql server
first METHOD #1:
using the control panel, search for services. search for the MySQL service.
click the service to Start/stop Service
second METHOD #2: Command Line Execution
Open DOS Window
Example C:> "C:Program FilesMySQLMySQL Server 8.0inmysqld"

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.