TCO 1) Which of the following is not a valid reason to choose the MySQL RDBMS as
ID: 3582467 • Letter: T
Question
TCO 1) Which of the following is not a valid reason to choose the MySQL RDBMS as stated in your book? (Points : 4) SpeedSQL 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 : 4) quit
exit
q
Control-Q Question 3.3. (TCO 2) To set up a MySQL account to use for connecting to the server it is necessary to connect to the server as the MySQL _____ user. (Points : 4) admin
root
general
DBA Question 4.4. (TCO 2) You would need to install this client program in order to be able to check on the status of the server and perform other administrative tasks. (Points : 4) 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 : 4) mysql_install_db
mysql_install_dd
mysql_install_dir
None of the above as it comes pre-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 : 4) 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 indicates properties of the server or the current database? (Points : 4) character_set_system
character_set_server
character_set_client
character_set_database Question 8.8. (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 : 4) character_set_server
character_set_client
character_set_filesystem
character_set_connection Question 9.9. (TCO 3) Which of the following is stated in your textbook as being a way that MySQL handles out-of-range or otherwise improper values numeric or time data type columns in a table? (Points : 4) 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 10.10. (TCO 3) In which of the examples below does EXPLAIN actually execute part of a query to analyze the query? (Points : 4) When a join is involved
When a subquery is involved
When a LIKE clause is involved
When a GROUP BY is involved Question 11.11. (TCO 3) The data type used to define a column and the way it is defined can have a direct impact on how a query runs. Which of the following would not be considered a good practice based on information presented in your textbook? (Points : 4) Using an enum or set data type for columns used in numeric operations when the columns have a limited number of values
Using smaller data types like MEDIUMINT or FLOAT when appropriate
Always allowing columns to have NULL values
Using BLOB or TEXT columns to allow data to be packed Question 12.12. (TCO 3) When using MYSQLDUMP to generate backup files, which of the following options should be avoided in order to increase efficiency when reloading the data?(Points : 4) complete-insert
opt
extended-insert
delay_key_write Question 13.13. (TCO 4) Which of the following is not an option for setting system variables? (Points : 4) Setting at server startup
Setting in an option file
Setting before server startup
Setting at runtime Question 14.14. (TCO 4) The MySQL server provides a number of different storage engines to select from. Which of the storage engines listed below is not available by default? (Points : 4) MyISAM
MEMORY
CSV
FEDEERATED Question 15.15. (TCO 4) Which one of the following variables should be used to control the number, size, and placement of the files in the system tablespace? (Points : 4) default_temp_storage
innodb_data_home_dir
innodb_data_storage
innodb_data_path Question 16.16. (TCO 5) Which one of the following statements is not a valid statement to use in the creation or modification of a USER in MySQL? (Points : 4) CREATE
GRANT
PROFILE
REVOKE Question 17.17. (TCO 5) If you needed to recreate a user account using the same password you would do which of the following? (Points : 4) Because passwords are hashed you cannot do this.
Look up the hashed password using SHOW GRANTS and use the hashed password shown.
Use the hashed password value preceded by the keyword PASSWORD.
Use a new password to create the account and then change it. Question 18.18. (TCO 5) Which of the following user privileges is not considered an administrative privilege? (Points : 4) CREATE USER
PROCESS
LOCK TABLES
SHOW DATABASES Question 19.19. (TCO 5) Which of the following user privileges is not considered an object privilege? (Points : 4) ALTER
RELOAD
FILE
GRANT OPTION Question 20.20. (TCO 5) In order for a user to be able to grant its own privileges to another user the original user must have which of the following privileges? (Points : 4) GRANT
ALTER
GRANT OPTION
SUPER TCO 1) Which of the following is not a valid reason to choose the MySQL RDBMS as stated in your book? (Points : 4) Speed
SQL support
Portability
Scalability
Explanation / Answer
Answer :
Question 2.2. (TCO 1) When you want to terminate a session in MySQL, which of the following commands is not valid? (Points : 4)
quit
exit
q
Control-Q
Answer :
Control-Q
Explanation :
When you want to terminate a session in MySQL, we use commands quit, exit,q,Control-D.So Control -Q is not valid.
...............
Question 3.3. (TCO 2) To set up a MySQL account to use for connecting to the server it is necessary to connect to the server as the MySQL _____ user. (Points : 4)
admin
root
general
DBA
Answer :
root
Explanation :
To set up a MySQL account to use for connecting to the server it is necessary to connect to the server as the MySQL root user.
.........
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.