Which of the following is not a valid reason to choose the MySQL RDBMS as stated

Question

Which of the following is not a valid reason to choose the MySQL RDBMS as stated in your book? (Points : 5)

Speed

SQL support

Portability

Scalability

Question 2.2. (TCO 1) When you want to terminate a session in MySQL, which of the following commands is not valid? (Points : 5)

quit

exit

q

Control-Q

Question 3.3. (TCO 2) You would need to install this client program in order to issue queries and see the results. (Points : 5) mysaladmin

mysqldump

mysql

mysqlquery

Question 4.4. (TCO 2) You would need to install this client program in order to be able to dump table contents into a file. (Points : 5)

mysaladmin

mysqldump

mysql

mysqlquery

Question 5.5. (TCO 3) When installing MySQL on a Windows server you would run _____ to initialize the data directory. (Points : 5)

mysql_install_db

mysql_install_dd

mysql_install_dir

none of the above, as it is comepre-initialized with the MySQL distribution.

Question 6.6. (TCO 3) On a Unix server, if you start the server after logging in then the server starts as _____. (Points : 5)

the root user

the user designated as the administrator

the user you are logged in as

the SYSTEM user

Question 7.7. (TCO 3) The server maintains several system variables that are involved in various aspects of character set support. Which one of the following is not a character set variable that influences how communication occurs between the client and the server? (Points : 5)

character_set_server

character_set_client

character_set_filesystem

character_set_connection

Question 8.8. (TCO 3) Which of the following is stated in your textbook as being a way that MySQL handles of out-of-range or otherwise improper values numeric or time data-type columns in a table? (Points : 5)

Data that is too long is truncated to fit the maximum length of the column.

Values outside the legal range are clipped to the nearest endpoint of the range and the resulting value is stored.

It depends on the values that are listed as legal in the column definition.

An error is raised and the value is not allowed.

Question 9.9. (TCO 4) Which of the following types of variables are designed to allow you to monitor the runtime operations of the database? (Points : 5)

STATUS

GLOBAL

SESSION

LOCAL

Question 10.10. (TCO 4) To perform the initial setup of the system tablespace, which of the following steps would not be valid? (Points : 5)

Add the appropriate lines to the options file.

Make sure that all of the component files already exist.

Make sure that the directories exist for the tablespace component files.

Start the server.

Question 11.11. (TCO 6) MySQL stores information about system variables in a set of tables that can be queried to get different pieces of data. Which one of the following is the name of the Schema these tables are found in? (Points : 5) VARIABLES_SCHEMA

INFORMATION_SCHEMA

SYSTEM_SCHEMA

GLOBAL_SESSION_SCHEMA

Question 12.12. (TCO 6) Of the four MySQL logs listed below, which one is used to record when clients connect to the server and events such as server startup and shutdown? (Points : 5)

Relay Log

Slow Query Log

General Query Log

Binary Log

Question 13.13. (TCO 6) Which one of the following is not a valid method for keeping MySQL logs manageable? (Points : 5)

Log rotation

Use-based expiration

Log table truncation or rotation

Replication-related expiration

Question 14.14. (TCO 8) You are using the InnoDB storage engine and are using the default 10MB tablespace file which is named _____ by default. (Points : 5)

innodb_data_file

innodb_data_home

idbata1

innodb_tbls

Question 15.15. (TCO 8) Which of the following is not a system variable listed in your book as being one useful for general performance tuning? (Points : 5) back_log system_log max_connections open_files_limit Question 16.16. (TCO 9) Which of the following would be considered a specific benefit of using a database such as MySQL as listed in your textbook? (Points : 5) less time in the office reduced record retrieval time reduced overtime pay flexible input formatting

Explanation / Answer

1. MySQL RDBMS is good at speed, portability and scalability but it doesn't implement the complete SQL support.

Answer: SQL Support

-------------

2. exit, q and control-q can be used to exit. But exit is not a valid command.

Answer: exit

-------------

3. mysqldump is used to create the sql queries which will help to reproduce the database.
mysql is the whole thing
mysqlquery browser is the client program we can use.

Answer: mysqlquery

-------------

4. mysqldump is used to create the sql queries which will help to reproduce the database.

Answer: mysqldump

-------------

5. mysql_install_db is used to initialize the data directory.

Answer: mysql_install_db

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

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