GaussDB (for MySQL) has a strong access control system. Which permissions cannot currently be modified?
GaussDB (for MySQL) permissions are project-level. When authorizing, the scope must be set to a project in the selected region, and only applies there.
DAS Enterprise Edition supports export tasks: data only, structure only, or both, in SQL or CSV format.
When creating a GaussDB (for MySQL) instance, system accounts are automatically created. Which of the following are such accounts?
In DRS, backup migration means reading local backup files and restoring to target DB.
Which of the following statements about GaussDB (for MySQL) compatibility are correct?
Which of the following statements about GaussDB (for MySQL) instances is incorrect?
A connection is a physical concept: a client establishes a network connection to GaussDB (for MySQL), which creates one or more threads in the instance.
What is the output of the following SQL statement?
SELECT JSON_EXTRACT(10, 20, [30, 40], "$$"$$11);
Regarding users, roles, and permissions, which of the following descriptions isincorrect?
Which of the following are part of GaussDB (for MySQL)'s Cloud Native design philosophy?
The frequency of flushing logs from the buffer to disk is related to the parameter innodb_flush_log_at_trx_commit. Which value means "write log buffer data to log file and flush to disk every second"?
When DAS can log into an instance, it is recommended to use Cloud DBA “Emergency Kill Session” to terminate sessions.
GaussDB (for MySQL) is 100% compatible with MySQL ecosystem, applications can migrate to cloud without modification.
Which of the following statements about GaussDB (for MySQL) fault detection are correct?
In the EXPLAIN command output of GaussDB (for MySQL), which Select_type values are valid?
Which of the following isnota feature provided by the Data Replication Service (DRS)?
Which of the following descriptions about GaussDB (for MySQL) CPU and memory expansion isincorrect?
If private IP cannot connect to GaussDB (for MySQL), bind an Elastic Public IP and connect via ECS or public host.
Which window function can be used to generate group-based ranks with the same rank for identical values?
The regex function REGEXP_INSTR returns the starting index of a substring matching the regex. If return_option=1, it returns the last matched position.
Compared to RDS for MySQL, GaussDB (for MySQL) has no standby nodes; all read-only are active and handle read traffic, improving utilization.
In GaussDB (for MySQL), the optimizer generates execution plans, which are executed by the executor.
Which of the following is the correct sequence for connecting to a GaussDB (for MySQL) instance via the internet?
After executing CREATE USER user1@'100.%' IDENTIFIED BY 'Database_123';, user1 can connect from any host.
To facilitate management, DAS Enterprise Edition includes several user roles. Which of the following isnotamong them?
Slow query logs in GaussDB (for MySQL) are controlled by slow_query_log. 0/OFF disables, 1/ON enables.
What is the maximum number of read-only nodes that can be created in one GaussDB (for MySQL) cluster?
Which of the following VPC connection methods can achieve private IP communication between different VPCs in the same region?
In GaussDB (for MySQL), which parameter is used to control the maximum idle time for interactive connections?
System tables and views record metadata for DB objects and users. Which system table or viewcannotbe used to query user information?
Object Storage Service (OBS) is a massive, secure, reliable, and low-cost storage service.
Which of the following services provides a dedicated public IP resource, including public IP address and outbound bandwidth?
Which statements about GaussDB (for MySQL)'s high reliability and scalability are correct?
Which type of tree does the InnoDB engine use by default to store index information?
Using SHOW PROCESSLIST provides session-related info. Which of the following are common thread statuses?
If read hit ratio is below 99%, lowering innodb_buffer_pool_size can improve cache hit rate.
In a 16-core, 64GB GaussDB (for MySQL) instance, what is the default size of the innodb_log_buffer_size parameter?
In GaussDB (for MySQL), which of the following is offloaded to the storage node for execution?
The frequency of flushing the log from buffer to disk is related to the parameter innodb_flush_log_at_trx_commit. If you want to flush the log buffer and write it to disk every time a transaction is committed, what should the parameter value be?
In execution plans, the id indicates SELECT sequence number. Larger IDs execute first; same IDs execute top to bottom.
In GaussDB (for MySQL), user variables are session variables that can be saved and shared across sessions.
When looping over cursors, overflow can occur if end-of-data isn’t checked. Which handlers can be used to control execution properly?
TESTED 05 Oct 2025
