Pre-Summer Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: validbest

Discussions
  1. Home
  2. Huawei
  3. Huawei
  4. H13-921_V1.5
  5. HCIP-GaussDB-OLTP V1.5 Questions and Answers

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

Exam H13-921_V1.5 All Questions
Exam H13-921_V1.5 Premium Access

View all detail and faqs for the H13-921_V1.5 exam

Go to Exam
Viewing page 6 out of 7 pages
Viewing questions 51-60 out of questions
Questions # 51:

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

Options:

A.

True

B.

False

Questions # 52:

Which are common performance bottlenecks in database servers?

Options:

A.

Improper memory allocation

B.

High CPU usage

C.

Network problems

D.

Slow physical I/O

Questions # 53:

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?

Options:

A.

max_connect_errors

B.

max_connections

C.

max_user_connections

D.

connect_timeout

Questions # 54:

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

Options:

A.

An instance contains multiple background threads

B.

An instance includes continuous memory regions

C.

An instance contains various files

D.

An instance corresponds one-to-one with a database

Questions # 55:

Regarding users, roles, and permissions, which of the following descriptions isincorrect?

Options:

A.

Database users are primarily used to connect to and access database objects

B.

Roles have the ability to log in and execute SQL statements

C.

Databases use roles to organize and divide permissions

D.

Creating a role requires the user to have CREATE ROLE or CREATE USER permissions

Questions # 56:

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

Options:

A.

12

B.

13

C.

14

D.

15

Questions # 57:

When creating a GaussDB (for MySQL) instance, the system automatically creates system accounts (usable by users) to support backend O&M. Which are these accounts?

Options:

A.

rdsAdmin

B.

rdsRepl

C.

rdsBackup

D.

rdsMetric

Questions # 58:

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

Options:

A.

Key Partitioning

B.

Range Partitioning

C.

List Partitioning

D.

Hash Partitioning

Questions # 59:

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

Options:

A.

5s

B.

10s

C.

15s

D.

20s

Questions # 60:

Which of the following are common SQL tuning practices?

Options:

A.

Always use SELECT statements

B.

Minimize use of GROUP BY

C.

Use LIMIT when querying a single record

D.

For large data inserts, drop indexes and constraints first

Viewing page 6 out of 7 pages
Viewing questions 51-60 out of questions