Pearson H13-921_V1.5 New Attempt

HCIP-GaussDB-OLTP V1.5 Questions and Answers

Question 33

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

True

False

Question 34

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

True

False

Question 35

GaussDB for MySQL adopts a compute-storage separation design. What is its greatest value?

Compatible with MySQL client

Reduces deployment costs and server requirements

Maintains open-source control

Distributes data access load before server startup, allowing fast server switch during failures

Question 36

Which of the following window functions are supported by GaussDB (for MySQL)?

LEAD()

MIDDLE_VALUE()

FIRST_VALUE()

LAG()