H13-921_V1.5 Practice Exam Questions with Answers HCIP-GaussDB-OLTP V1.5 Certification

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

In DRS, backup migration means reading local backup files and restoring to target DB.

MD5(str) returns a 128-bit checksum as a 40-character hex string.

Which statements about storage engines are correct?

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

Which of the following statements about GaussDB (for MySQL) fault detection are correct?

Which statements about GaussDB (for MySQL)'s high reliability and scalability are correct?

Which of the following descriptions about Hint optimization strategies isincorrect?

Which of the following descriptions about GaussDB (for MySQL) CPU and memory expansion isincorrect?

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

What does GaussDB (for MySQL) use in stored procedures to implement the effect of dynamic SQL updates?

GaussDB (for MySQL) supports compute-storage separation.

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

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

Which type of tree does the InnoDB engine use by default to store index information?

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

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

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?

GaussDB (for MySQL) has a strong access control system. Which permissions cannot currently be modified?

What are the main features of GaussDB 100?

Frequent UPDATE operations can cause page splits, leading to severe fragmentation.

Huawei Cloud DAS (Cloud DBA) provides intelligent monitoring, diagnostics, and optimization to ensure stable DB operation.

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

Which of the following are common SQL tuning practices?

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

Which of the following methods cannot be used to view a table's fragmentation rate?

Which roles exist in DAS Enterprise Edition?

The MyISAM engine supports tables with different storage formats. Which are supported?

Which steps belong to the overall installation process?

Which types of backup does GaussDB (for MySQL) support?

Which methods can be used during requirements investigation?

What are the parameter types for stored procedures?

Which of the following are Huawei Cloud’s database management tools?

DAS Enterprise Edition supports export tasks: data only, structure only, or both, in SQL or CSV format.

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

Which of the following statements about stored procedures and functions are correct?

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

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 window functions are supported by 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) allows backup policy configuration in Huawei Cloud Console. Which of the following cannot be modified?

When creating a GaussDB (for MySQL) instance, system accounts are automatically created. Which of the following are such accounts?

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

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

In regex, a* matches 0 or more “a” characters.

Creating partitioned tables is a form of vertical partitioning.

The delay between read-only and primary nodes mainly comes from which of the following?

Which statements about distributed transactions are correct?

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

Which of the following isnotan option of the EXPLAIN command?

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

Hints in GaussDB (for MySQL) mainly include which categories?

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

What is the maximum number of read-only nodes that can be added to a GaussDB (for MySQL) cluster?

Which statements about SQL execution process are correct?

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

UGO (DB & App Migration) is a professional cloud service for heterogeneous DB structure migration and SQL conversion.

With shared storage, GaussDB (for MySQL) can expand by adding compute nodes, completed within minutes regardless of data size.

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