H13-921_V1.5 HCIP-GaussDB-OLTP V1.5 Question and Answers

FETCH retrieves the current cursor row and moves to the next. If already at last row, overflow occurs.

In GaussDB (for MySQL), the default failover priority is “0”, where “0” is the highest. It can be manually modified.

Which of the following VPC connection methods can achieve private IP communication between different VPCs in the same region?

If an administrator finds that the InnoDB read cache hit rate is low in GaussDB (for MySQL), what should be optimized first?

When creating a GaussDB (for MySQL) instance, the system automatically creates system accounts (usable by users) to support backend O&M. Which are these accounts?

Which of the following descriptions about Hint optimization strategies isincorrect?

Which steps belong to the overall installation process?

Using DAS → Space tab → “Database Space”, users can search by DB name to view size and fragmentation rate.

Which statements about the InnoDB engine in GaussDB (for MySQL) are correct?

In Cloud DBA’s performance module, “Slow SQL” includes which functions?

Using SHOW PROCESSLIST provides session-related info. Which of the following are common thread statuses?

In GaussDB (for MySQL), what is the default value of the long_query_time parameter (i.e., the slow log threshold)?

Which factors should be considered when designing database objects?

User sessions correspond to user connection threads — one session equals one connection thread.

GaussDB (for MySQL) deployment supports both public cloud and hybrid cloud.

Which of the following are DAS Enterprise Edition user roles?

Using the EXPLAIN command in GaussDB (for MySQL), which of the following isnota valid Select_type?

Under the performance tab, in which module can users view server uptime, connection information, and buffer pool status?

Which of the following isnota feature provided by the Data Replication Service (DRS)?

Which regex pattern is used to match one or more ‘h’ characters?

When changing a DB instance password, read-only node passwords must be updated manually.

When using security group functionality, which of the following is not a configurable setting?

Which of the following are correct descriptions of read-only nodes?

In a 16-core, 64GB GaussDB (for MySQL) instance, what is the default size of the innodb_log_buffer_size parameter?

A company platform has 29 categories of products. If partitioning tables based on products, which partitioning method is recommended?

GaussDB (for MySQL) supports compute-storage separation.

The Com_insert and similar Com_xx parameters are used to monitor the number of different operations executed in a database instance. Which of the following commands correctly retrieves this parameter?

When purchasing GaussDB (for MySQL), storage space must be pre-planned in addition to CPU, to avoid later expansion.

Compared to RDS for MySQL, GaussDB (for MySQL) has no standby nodes; all read-only are active and handle read traffic, improving utilization.

Which descriptions about session parameters are correct?

When creating a user in GaussDB (for MySQL), which symbol represents all hosts?

When using hints, different scopes apply. Which scope descriptions are correct?

Object Storage Service (OBS) is a massive, secure, reliable, and low-cost storage service.

SQL statements exceeding slow_launch_time are recorded in the slow SQL log.

The command show [session|global] status defaults to "global".

After executing CREATE USER user1@'100.%' IDENTIFIED BY 'Database_123';, user1 can connect from any host.

Which of the following is NOT a feature of a read-only node?

Regarding users, roles, and permissions, which of the following descriptions isincorrect?

In execution plans, the id indicates SELECT sequence number. Larger IDs execute first; same IDs execute top to bottom.

When performance drops sharply, Cloud DBA’s SQL module can quickly identify problematic SQL for diagnosis.

Slow query logs in GaussDB (for MySQL) are controlled by slow_query_log. 0/OFF disables, 1/ON enables.

What is the impossible return value of SELECT FLOOR(7 + (RAND()*5));?

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?

Which of the following statements about GaussDB (for MySQL) instances is incorrect?

Which statements about Schema are correct?

Which factors affect database performance?

Which statements about storage engines are correct?

When executing stored procedures, which end delimiters are allowed?

In GaussDB (for MySQL), which of the following is offloaded to the storage node for execution?

Which of the following is a normal tenant creation process?

Which of the following are GaussDB (for MySQL) thread statuses?

Which of the following services provides a dedicated public IP resource, including public IP address and outbound bandwidth?

Which of the following are advanced features of GaussDB (for MySQL)?

When declaring a user variable, which of the following formats is correct?

GaussDB (for MySQL) allows backup policy configuration in Huawei Cloud Console. Which of the following cannot be modified?

Which parameter types can be used when writing stored procedures?

Which statements about distributed transactions are correct?

What are the core advantages of GaussDB (for MySQL)?

Which descriptions of important modules in GaussDB (for MySQL) architecture are correct?

Which of the following are key operations supported by Cloud Audit (CTS) for GaussDB (for MySQL) instances?