单项选择题
You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory. Why is it important to remove snapshots after completing a RAW backup in this way?（）
A.The snapshot size will continue to grow as changes to the volume are made
B.The snapshots take a significant amount of disk space as they are a duplicate copy of the data
C.The system can only support one snapshot per volume, and you need to remove it to be able to take your next backup
D.The system keeps a copy of changes in memory and can cause an out of memory event
相关考题
-
单项选择题
MySQL is installed on a Linux server and has the following configuration: What is the purpose of changing ownership of datadir to the ‘mysql’ user?（）
A.MySQL requires correct file ownership while remaining secure
B.MySQL needs to be run as the root user, but file cannot be owned by it
C.MySQL cannot be run as the root user -
多项选择题
Which two options describe how MySQL Server allocates memory?（）
A.Thread memory is pre-allocated up to thread_cache_size for performance
B.Each connection may have its own per-thread memory allocations
C.Global memory resources are allocated at server startup
D.Each thread allocates memory from a global pool -
多项选择题
Which two statements describe the behavior of the server's SQL mode?（）
A.The server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax
B.The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE
C.The server's SQL mode can be changed at the session level with a SET SESSION sql_mode="new_value" command
D.The server's SQL mode, when globally set on a slave server, applies to events sent from the master
