Exclusive Black Friday Deal: 70% Off All Exam Bundles! Use coupon code below to unlock your savings! - Ends in 0d 00h 00m 00s - Coupon code: Friday70

Free HCIP-GaussDB-OLTP V1.5 Practice Questions

Question # 21

Read-only nodes replay WAL and read Page Store to sync with the primary node’s memory state, including active transactions and buffer pool.

Options:

A.  

True

B.  

False

Discussion 0
Question # 22

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

Options:

A.  

True

B.  

False

Discussion 0
Question # 23

Which of the following isnota feature provided by the Data Replication Service (DRS)?

Options:

A.  

Real-time migration

B.  

Backup migration

C.  

Real-time synchronization

D.  

Operation audit

Discussion 0
Question # 24

Using the EXPLAIN command in GaussDB (for MySQL), which of the following isnota valid Select_type?

Options:

A.  

SIMPLE

B.  

COMPLEX

C.  

PRIMARY

D.  

SUBQUERY

Discussion 0
Question # 25

After executing CREATE USER user1@'100.%' IDENTIFIED BY 'Database_123';, user1 can connect from any host.

Options:

A.  

True

B.  

False

Discussion 0
Question # 26

The Data Management Service (DAS) is used for logging into and operating cloud databases on Huawei Cloud. Which of the following versions isnotprovided by DAS?

Options:

A.  

Professional Edition: for business personnel

B.  

Standard Edition: for developers

C.  

Cloud DB

D.  

Enterprise Edition: for enterprise users

E.  

For DBAs and O&M personnel

Discussion 0
Question # 27

Which command in GaussDB (for MySQL) is used to view server status information?

Options:

A.  

print status

B.  

select status

C.  

desc status

D.  

show status

Discussion 0
Question # 28

In a 16-core, 64GB GaussDB (for MySQL) instance, what is the default size of the innodb_log_buffer_size parameter?

Options:

A.  

128MB

B.  

256MB

C.  

512MB

D.  

1024MB

Discussion 0
Question # 29

Which of the following are GaussDB (for MySQL) thread statuses?

Options:

A.  

Inserting data: thread inserting data

B.  

Executing: thread executing statement

C.  

Killed: thread terminates after receiving kill signal

D.  

Creating table: thread creating a table

Discussion 0
Question # 30

In GaussDB (for MySQL), which of the following is offloaded to the storage node for execution?

Options:

A.  

Transaction

B.  

Buffer Pool

C.  

SQL Parse

D.  

Log Write

Discussion 0

H13-921_V1.5 PDF

H13-921_V1.5 PDF (Printable)
$46.5
$154.99

H13-921_V1.5 Testing Engine

H13-921_V1.5 PDF (Printable)
$51
$169.99

H13-921_V1.5 PDF + Testing Engine

H13-921_V1.5 PDF (Printable)
$63.9
$212.99

Free Exams Sample Questions