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

System tables and views record metadata for DB objects and users. Which system table or viewcannotbe used to query user information?

Which statements about storage engines are correct?

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

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

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

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

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

GaussDB (for MySQL) uses V5 CPU + Optane DC SSD + RDMA network hardware combo, ensuring stable and fast performance.

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

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

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

What is the output of the following SQL statement?

SELECT JSON_EXTRACT(10, 20, [30, 40], "$$"$$11);

GaussDB (for MySQL) supports compute node bidirectional scaling: vertical (1 write, 15 reads) and horizontal (elastic online scaling, pay-as-you-go).

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

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?

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

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

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

Which methods can be used during requirements investigation?

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

Which strings can the regex 'x?z|food' (simplified from source) match?

During SQL execution, which component generates the execution plan?

Which of the following descriptions about Hint optimization strategies isincorrect?

Which of the following is a normal tenant creation process?

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

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

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

Which of the following is the correct sequence for connecting to a GaussDB (for MySQL) instance via the internet?

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

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

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

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

Which factors should be considered when designing database objects?

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

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

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

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

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?

DAS Enterprise Edition defines three types of user roles. Which of the following isnota role in DAS Enterprise Edition?

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

Which of the following are entities?

What are the main advantages of the GaussDB (for MySQL) product?

What are the parameter types for stored procedures?

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

Database instance status refers to the running status of the DB instance. Which of the following is NOT a valid status for GaussDB (for MySQL)?

GaussDB (for MySQL) supports compute-storage separation.

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

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

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

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

Which of the following statements about the VACUUM FULL operation isincorrect?

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

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

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

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

A database administrator received a "cannot connect" error. Diagnosis revealed that a new business caused client connections to exceed the preset limit. Which parameter should be adjusted to fix the error?

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

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

What is the maximum number of read-only nodes that can be created in one GaussDB (for MySQL) cluster?

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