H13-921_V1.5問題集、Huawei実際の試験問題

質問 1

In GaussDB (for MySQL), what is the default slow SQL threshold in seconds?

A. 15s

B. 20s

C. 5s

D. 10s

正解: D

質問 2

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

A. True

B. False

正解: A

質問 3

Which parameter types can be used when writing stored procedures?

A. INOUT

B. OUT

C. IN

D. OUTIN

正解: A,B,C

質問 4

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

A. HA monitor promotes standby on primary failure, recovers standby on fault

B. Each node periodically outputs status (faults, CPU, memory, etc.)

C. A node is marked faulty only after 3 consecutive failures to reduce false positives

D. Fault detection is handled by HA monitor component

正解: A,B,D

質問 5

Which statements about field optimization in GaussDB (for MySQL) are correct?

A. Match field type to business use (e.g., numeric for amounts)

B. Design adequate length to avoid later schema changes

C. Choose shorter field lengths when possible

D. Choose efficient field types when possible

正解: A,B,C,D

質問 6

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

A. True

B. False

正解: A

質問 7

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

A. True

B. False

正解: A

質問 8

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

A. Index-level: affects an index in a table

B. Table-level: affects a table in a block

C. Query block: affects a specific query block

D. Global: affects entire statement

正解: A,B,C,D

質問 9

GaussDB (for MySQL) permissions are project-level. When authorizing, the scope must be set to a project in the selected region, and only applies there.

A. True

B. False

正解: A

質問 10

Which of the following statements are incorrect?

A. Log Store defaults to multi-replica sync

B. Slice is independent and max size is 1GB

C. Log Store uses append-only

D. Page Store persists Pages and SQL reads pages

正解: A,B

質問 11

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

A. High scalability

B. Ultra-high performance

C. High compatibility

D. High reliability

正解: A,B,C,D

質問 12

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

A. 8

B. 13

C. 10

D. 12

正解: B

Huawei HCIP-GaussDB-OLTP V1.5 - H13-921_V1.5 模擬練習