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

For composite indexes, B+ tree is built left-to-right.

Read-only nodes replay WAL and read Page Store to sync with the primary node’s memory state, including active transactions and buffer pool.

Which command can GaussDB (for MySQL) use to view server status information?

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

Which of the following statements about the VACUUM FULL operation is incorrect ?

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

When DAS can log into an instance, it is recommended to use Cloud DBA “Emergency Kill Session” to terminate sessions.

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

GaussDB (for MySQL) uses snapshots for both full and incremental backups, with second-level creation efficiency.

Which roles exist in DAS Enterprise Edition?

GaussDB (for MySQL) and GaussDB (openGauss) are both relational databases.

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

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

Which of the following is not a feature provided by the Data Replication Service (DRS)?

In GaussDB (for MySQL), the optimizer generates execution plans, which are executed by the executor.

Which of the following is not an object included in a schema?

Which of the following is a supported storage engine in GaussDB (for MySQL)?

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

Compared with physical backup, logical backup has the advantage of faster backup and recovery.

Which statements about slow query logs are correct?

To elastically scale read capacity and reduce GaussDB (for MySQL) pressure, read-only nodes can be created. Which statements are correct?

In DAS → Sessions tab → “Real-time Sessions”, users can kill system account rdsRepl.

Which of the following are entities?

Which of the following is not a binary data type?

In GaussDB (for MySQL), which parameter is used to control the maximum idle time for interactive connections?

In GaussDB (for MySQL), the Log Store is responsible for persisting logs. What is the size of the unique ID used to identify Log Store?

Which are advantages/features of GaussDB (for MySQL)?

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.

GaussDB (for MySQL) uses the same backup mechanism as community MySQL and supports xtrabackup for physical backups.

Which statements about distributed transactions are correct?

The parameter max_user_connections can limit user connections per instance, and can differ per user.

Which statements about SQL execution process are correct?

Using DROP USER must be cautious because deleted objects cannot be recovered even if interrupted.

In the EXPLAIN command output of GaussDB (for MySQL), which Select_type values are valid?

What are the main features of GaussDB 100?

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"?

Which of the following statements is correct?

In GaussDB (for MySQL), parameters can show whether the workload is mainly inserts/updates or queries, and the approximate SQL type ratio.

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

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

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

Trigger events specify the statements that activate triggers. Which are included?

Which of the following are DAS Enterprise Edition user roles?

GaussDB (for MySQL) enforces password complexity rules for new users. Which of the following passwords do not comply?

Which methods can be used to find fragmented tables in GaussDB (for MySQL)?

What are the features of Huawei Cloud’s Cloud Audit service?

Which of the following are core functions of the UGO database migration tool?

In GaussDB (for MySQL), user variables are session variables that can be saved and shared across sessions.

Which of the following statements are incorrect?

DRS provides complete heterogeneous database migration to the cloud, ensuring smooth business cutover.

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

What is the impossible result of executing: SELECT FLOOR(8 + (RAND()* 5));?

EXPLAIN cannot show the impact of triggers, stored procedures, or user-defined functions on queries.

GaussDB (for MySQL) supports bidirectional scalability for compute nodes and 1 read-write node. What is the maximum number of read-only nodes it supports?

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

To meet data reliability requirements, GaussDB (for MySQL) can retain automatic backup recovery for up to how many days?

Huawei Cloud DB Security Audit supports analyzing SQL behavior by risk levels, SQL injection, blacklist statements, and unauthorized operations.

When querying information_schema.TABLES, which parameter indicates the size of table fragmentation?

What are the parameter types for stored procedures?

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

The regex function REGEXP_INSTR returns the starting index of a match. If return_option=1, it returns the last position.