Which are valid plan display formats?
Which functions are provided by Huawei Cloud Data Replication Service (DRS)?
What is the output of the following SQL statement?
SELECT JSON_EXTRACT(10, 20, [30, 40], "$$"$$11);
Which of the following statements about GaussDB (for MySQL) compatibility are correct?
Which are Huawei Cloud security services?
GaussDB (for MySQL) enforces password complexity rules for new users. Which of the following passwords donotcomply?
Which strings can the regex 'x?z|food' (simplified from source) match?
Which methods can be used to find fragmented tables in GaussDB (for MySQL)?
In GaussDB (for MySQL), which of the following is offloaded to the storage node for execution?
GaussDB (for MySQL) supports compute node bidirectional scaling: vertical (1 write, 15 reads) and horizontal (elastic online scaling, pay-as-you-go).
Using SHOW PROCESSLIST provides session-related info. Which of the following are common thread statuses?
When performance drops sharply, Cloud DBA’s SQL module can quickly identify problematic SQL for diagnosis.
What is the maximum number of read-only nodes that can be added to a GaussDB (for MySQL) cluster?
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.
Which of the following are part of GaussDB (for MySQL)'s Cloud Native design philosophy?
Which command in GaussDB (for MySQL) is used to view server status information?
Which methods can be used during requirements investigation?
The EXPLAIN command can be used to view the execution plan of SQL statements. In the execution plan, Type indicates the access method to the table. Which of the following is not a valid Type value?
Which window function generates a ranking within groups, where the same value gets the same rank?
Which of the following operationscannotbe performed on a diagnostic report?
Which of the following are Huawei Cloud’s database management tools?
Which statements about SQL execution process are correct?
In GaussDB (for MySQL), roles cannot log in but can execute SQL statements.
DAS Enterprise Edition supports export tasks: data only, structure only, or both, in SQL or CSV format.
The regex function REGEXP_INSTR returns the starting index of a match. If return_option=1, it returns the last position.
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?
Regarding users, roles, and permissions, which of the following descriptions isincorrect?
When executing stored procedures, which end delimiters are allowed?
GaussDB (for MySQL) currently only supports the InnoDB storage engine.
When using “Full SQL Insight,” DAS must be enabled to collect all SQL. After enabling, what is the performance overhead within?
With shared storage, GaussDB (for MySQL) can expand by adding compute nodes, completed within minutes regardless of data size.
Huawei Cloud DAS (Cloud DBA) provides intelligent monitoring, diagnostics, and optimization to ensure stable DB operation.
What does GaussDB (for MySQL) use in stored procedures to implement the effect of dynamic SQL updates?
The command show [session|global] status defaults to "global".
When creating a user in GaussDB (for MySQL), which symbol represents all hosts?
GaussDB (for MySQL) supports compute-storage separation.
Hints are used when the user knows the optimal execution plan or to stabilize SQL execution plans for performance tuning.
DAS Enterprise Edition defines three types of user roles. Which of the following isnota role in DAS Enterprise Edition?
Which Huawei Cloud service is used to control external access operations to virtual machines?
Response time calculation model = network transmission time (request) + server processing time (one or more layers) + network transmission time (response) + frontend parsing time.
Huawei Cloud DB Security Audit supports analyzing SQL behavior by risk levels, SQL injection, blacklist statements, and unauthorized operations.
Which are common denormalization practices in DB design?
Which window function can be used to generate group-based ranks with the same rank for identical values?
The parameter innodb_log_buffer_size is used to set the size of the InnoDB log buffer, primarily to improve I/O performance for writing logs. What is the default size in a 16-core, 64GB GaussDB (for MySQL) instance?
What is the impossible result of executing: SELECT FLOOR(8 + (RAND()* 5));?
Which types of backup does Huawei Cloud provide?
In execution plans, the id indicates SELECT sequence number. Larger IDs execute first; same IDs execute top to bottom.
Hints in GaussDB (for MySQL) mainly include which categories?
Which command can GaussDB (for MySQL) use to view server status information?
GaussDB (for MySQL) uses the same backup mechanism as community MySQL and supports xtrabackup for physical backups.
SQL statements exceeding slow_launch_time are recorded in the slow SQL log.
Which types of backup does GaussDB (for MySQL) support?
Which of the following statements about GaussDB (for MySQL) instances is incorrect?
To elastically scale read capacity and reduce GaussDB (for MySQL) pressure, read-only nodes can be created. Which statements are correct?
To facilitate management, DAS Enterprise Edition includes several user roles. Which of the following isnotamong them?
Which factors should be considered when designing database objects?
What are the main features of GaussDB 100?
Horizontal partitioning always improves query performance.
User sessions correspond to user connection threads — one session equals one connection thread.
If read hit ratio is below 99%, lowering innodb_buffer_pool_size can improve cache hit rate.
What are the core advantages of GaussDB (for MySQL)?
Which of the following statements are incorrect?
MD5(str) returns a 128-bit checksum as a 40-character hex string.
Which SQL O&M features does Cloud DBA provide?