HCIP-GaussDB-OLTP V1.5 (H13-921_V1.5) Practice Test

Questions # 1:

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

Options:

Questions # 2:

An e-commerce platform is experiencing a surge in users and needs a database architecture with optimal parallel processing and scalability. Which architecture should be enabled?

Options:

Shared-Disk

Shared-Memory

Shared-Everything

Shared-Nothing

Questions # 3:

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

Options:

Global: affects entire statement

Query block: affects a specific query block

Table-level: affects a table in a block

Index-level: affects an index in a table

Questions # 4:

When changing a DB instance password, read-only node passwords must be updated manually.

Options:

True

False

Questions # 5:

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

Options:

Use the “Space” function in Cloud DBA to clearly view the fragmentation rate

Query information_schema.TABLES and check the data_free value

Query performance_schema.TABLES and check the data_free value

Use the command SHOW TABLE STATUS LIKE 'table_name' and check the data_free value

Questions # 6:

Which parameters can limit resources per user?

Options:

MAX_QUERIES_PER_HOUR

MAX_UPDATES_PER_HOUR

MAX_CONNECTIONS_PER_HOUR

MAX_USER_CONNECTIONS

Questions # 7:

Object Storage Service (OBS) is a massive, secure, reliable, and low-cost storage service.

Options:

True

False

Questions # 8:

GaussDB (for MySQL) is a single-process, multi-threaded database. What are the advantages of threads?

Options:

Easier creation/management, no memory allocation overhead

Easier creation/management, no merge overhead

Fast context switching

Misbehaving threads won’t affect the entire system

Questions # 9:

Splitting common and uncommon fields into separate storage is called vertical partitioning.

Options:

True

False

Questions # 10:

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

Options:

True

False

Viewing page 1 out of 7 pages

Viewing questions 1-10 out of questions

Big Halloween Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple70

Pass the Huawei Certification H13-921_V1.5 Questions and answers with ExamsMirror

Exam H13-921_V1.5 Premium Access

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

TOP CODES