Question 1. 1. (TCO 6) MySQL stores information about system variables in a set
ID: 3582468 • Letter: Q
Question
Question 1.1. (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 : 4) VARIABLES_SCHEMAINFORMATION_SCHEMA
SYSTEM_SCHEMA
GLOBAL_SESSION_SCHEMA Question 2.2. (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 : 4) Relay log
Slow query log
General query log
Binary log Question 3.3. (TCO 6) Which one of the following is not a valid method for keeping MySQL logs manageable? (Points : 4) Log rotation
Use-based expiration
Log table truncation or rotation
Replication-related expiration Question 4.4. (TCO 6) MySQL represents every table on disk by at least one file which is the _____
format file that contains a description of the table’s structure. (Points : 4) .frm
.cvs
.ini
.dll Question 5.5. (TCO 6) The MySQL data directory contains a number of status and log files. Which log file contains information on data modifications received by a slave server from the master? (Points : 4) Process ID file
General binary log
Binary log
Relay log Question 6.6. (TCO 6) The structure of the MySQL data directory is easy to understand because it uses the _____ structure filesystem. (Points : 4) hierarchical
parent/child
logical
tier Question 7.7. (TCO 7) To prepare against potential database problems, which of the following is not really a viable action to take? (Points : 4) Enable the auto-recovery capabilities of MySQL
Set up scheduled preventive maintenance
Limit the number of users to the database
Set up a database backup schedule Question 8.8. (TCO 7) You must use the LOCK, FLUSH, and UNLOCK statements within _____. (Points : 4) a single session
two simultaneous sessions
two concurrent sessions
the same hour Question 9.9. (TCO 7) Which of the following storage engines do not have binary portable tables? (Points : 4) InnoDB
MyISAM
MEMORY
CVS Question 10.10. (TCO 7) The REPAIR TABLE statement provides and interface to the server’s table repair capabilities, but it does not work with which of the following storage engines? (Points : 4) InnoDB
MyISAM
ARCHIVE
CVS Question 11.11. (TCO 8) Which of the following is not listed in your text as a valid reason to use raw partitions as components of the InnoDB Sytem Tablespace? (Points : 4) You can easily create very large tablespaces.
Raw partitions reduce overhead by eliminating the filesystem management layer.
Each raw partition file is guaranteed to have entirely contiguous space on disk, whereas regular files are subject to filesystem fragmentation.
You can easily create very large tables. Question 12.12. (TCO 8) Which of the following is not a valid InnoDB storage engine variable? (Points : 4) innodb_buffer_pool_size
innodb_log_group_home_dir
innodb_log_file_size
innodb_log_buffer_size Question 13.13. (TCO 8) As stated in your textbook, increasing a system variable by a huge amount on the theory that more is always better could result in _____. (Points : 4) your system being more fault tolerant
your system running out of resources
your system speeding up dramatically
your system not changing at all Question 14.14. (TCO 8) Instead of bumping up the sizes of per-session buffers by a large amount all at once, a best practice listed in your textbook would be to (Points : 4) change the sizes incrementally and test your changes.
make the changes as each user logs into the server.
change the size and let the users tell you how the database reacted.
never change the sizes by a large amount. Question 15.15. (TCO 9) Which of the following would not be considered a responsibility of administering a MySQL server? (Points : 4) Securing your MySQL setup after installing it
Monitoring and setting the server’s operating parameters
Monitoring the network
Maintaining server logs Question 1.1. (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 : 4) VARIABLES_SCHEMA
INFORMATION_SCHEMA
SYSTEM_SCHEMA
GLOBAL_SESSION_SCHEMA
Explanation / Answer
Answer :
Question 1.1. (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 : 4)
VARIABLES_SCHEMA
INFORMATION_SCHEMA
SYSTEM_SCHEMA
GLOBAL_SESSION_SCHEMA
Answer :
INFORMATION_SCHEMA
Explanation :
MySQL stores information about system variables in a set of tables that can be queried to get different pieces of data. INFORMATION_SCHEMA is the name of the Schema these tables are found in.
............
Question 2.2. (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 : 4)
Relay log
Slow query log
General query log
Binary log
Answer :
General query log
Explanation :
General query log is used to record when clients connect to the server and events, such as server startup and shutdown.
..........
Question 3.3. (TCO 6) Which one of the following is not a valid method for keeping MySQL logs manageable? (Points : 4) Log rotation
Use-based expiration
Log table truncation or rotation
Replication-related expiration
Answer :
Use-based expiration
Explanation :
Available method for keeping MySQL logs manageable are Log rotation,Log table truncation or rotation,Replication-related expiration.So Use-based expiration is not a valid method for keeping MySQL logs manageable.
.............
Question 4.4. (TCO 6) MySQL represents every table on disk by at least one file which is the _____
format file that contains a description of the table’s structure. (Points : 4)
.frm
.cvs
.ini
.dll
Answer :
.frm
................
Question 5.5. (TCO 6) The MySQL data directory contains a number of status and log files. Which log file contains information on data modifications received by a slave server from the master? (Points : 4)
Process ID file
General binary log
Binary log
Relay log
Answer :
Binary log
...............
Question 6.6. (TCO 6) The structure of the MySQL data directory is easy to understand because it uses the _____ structure filesystem. (Points : 4)
hierarchical
parent/child
logical
tier
Answer :
hierarchical
Explanation :
The structure of the MySQL data directory is easy to understand because it uses the hierarchical structure filesystem.
....
Question 9.9. (TCO 7) Which of the following storage engines do not have binary portable tables? (Points : 4) InnoDB
MyISAM
MEMORY
CVS
Answer :
CVS
.......................
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.