H13-921_V1.5 Questions and Answers

Which statements about SQL execution process are correct?

What are the parameter types for stored procedures?

Which of the following operationscannotbe performed on a diagnostic report?

GaussDB (for MySQL) supports compute-storage separation.

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

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

Which of the following isnota functional module of Cloud Audit?

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

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

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

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

Which are common denormalization practices in DB design?

Which statements about GaussDB (for MySQL) read-only nodes are correct?

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

Which of the following is a normal tenant creation process?

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

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

Which of the following statements about PLOG objects in Log Stores are correct?

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

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

Which statements about storage engines are correct?

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

Which of the following are entities?

What is the result of the SQL command: SELECT RPAD('hi', 5, 'u');?

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

If private IP cannot connect to GaussDB (for MySQL), bind an Elastic Public IP and connect via ECS or public host.

GaussDB (for MySQL) log management supports viewing DB-level logs, including error logs and slow SQL logs.

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

In GaussDB (for MySQL), session and connection are the same concept.

If read hit ratio is below 99%, lowering innodb_buffer_pool_size can improve cache hit rate.

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

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

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

GaussDB (for MySQL) currently only supports the InnoDB storage engine.

Which of the following isnota binary data type?

Which of the following are part of GaussDB (for MySQL)'s Cloud Native design philosophy?

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

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

Which descriptions about session parameters are correct?

Which command in GaussDB (for MySQL) is used to view server status information?

Which of the following is NOT a system built-in user in GaussDB (for MySQL)?

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

Xiao Hai deployed an application on an Elastic Cloud Server that resides in the same region and VPC as the GaussDB (for MySQL) instance. What is the best way to connect the application to the database in this scenario?

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

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 statements about GaussDB (for MySQL) compatibility are correct?

When executing stored procedures, which end delimiters are allowed?

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

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?

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 of the following statements about GaussDB (for MySQL) fault detection are correct?

Which statements about slow query logs are correct?

Which roles exist in DAS Enterprise Edition?

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

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

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

Performance can be measured against a baseline. Ideally, what should a performance baseline include?

In GaussDB (for MySQL), roles cannot log in but can execute SQL statements.

For multidimensional clue analysis in data security auditing, which clues are supported by Huawei Cloud?