New Year Sale Special - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

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?

A.

ALL

B.

Range

C.

Full

D.

NULL

Which descriptions about session parameters are correct?

A.

max_connections: maximum allowed connections

B.

wait_timeout: max idle time for non-interactive connections

C.

interactive_timeout: max idle time for interactive connections

D.

connect_timeout: exception thrown if connection not established in time

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

A.

Regular expressions

B.

Scheduler

C.

Cursor

D.

Trigger

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

A.

True

B.

False

Log Store uses append-only storage. Like Page Store, it also produces holes.

A.

True

B.

False

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

A.

True

B.

False

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

A.

High reliability

B.

High scalability

C.

Ultra-high performance

D.

High compatibility

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

A.

15s

B.

20s

C.

10s

D.

5s

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

A.

True

B.

False

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

A.

Key Partitioning

B.

Range Partitioning

C.

List Partitioning

D.

Hash Partitioning