Machine Learning Tutorials, Courses and Certifications
Course Name :- Getting started with MySQL command line
Getting started with MySQL command line Cognitive Class Final Exam Answers:-
Question 1 : Which one of these statements is incorrect?
- MySQL was a key component in the LAMP (Linux operating system, Apache web server, MySQL database, and PHP scripting language) stack
- The dolphin in the MySQL logo is named Sakila
- MySQL was first developed by a Swedish company MySQL AB
- None of the above statements
Question 2 : Which edition of MySQL is free to use under a General Public License?
- Cluster
- Enterprise
- Community
- Standard
Question 3 : Which one of these MySQL forks has been led by the original developers of MySQL?
- MariaDB
- Percona Server for MySQL
- WebScaleSQL
- All of the above
Question 4 : Which one of the following commands is used to explore the structure of a table in MySQL command line interface?
- Tip: Try to run and validate the options for a table of Sakila Database in Cloud IDE terminal.
- DESCRIBE table_name;
- SHOW COLUMNS FROM table_name;
- EXPLAIN table_name;
- All of the above
Question 5 : Which one of the following commands can be used to dump first 5 rows of a table from your database in MySQL command line interface of Cloud IDE?
- Tip: Try to run and validate the options for a table of Sakila Database in Cloud IDE terminal.
- mysqldump –host=127.0.0.1 –port=3306 –user=root –password database_name table_name -w “true limit 5” <- backup.sql
- mysqldump –host=127.0.0.1 –port=3306 –user=root –password table_name database_name -w “true limit 5” -> backup.sql
- mysqldump –host=127.0.0.1 –port=3306 –user=root –password database_name table_name -w “true limit 5” > backup.sql
- mysqldump –host=127.0.0.1 –port=3306 –user=root –password table_name database_name -w “true limit 5” < backup.sql
