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

examout.co

When executing select * from processlist; to view instance-related information in GaussDB (for MySQL), which database should be used?

A.

sys

B.

mysql

C.

information_schema

D.

performance_schema

Which of the following is a normal tenant creation process?

A.

Add parent tenant

B.

Add tenant

C.

Plan resource management

D.

Bind roles and tenant

The MyISAM engine supports tables with different storage formats. Which are supported?

A.

Dynamic tables

B.

Compressed tables

C.

Temporary tables

D.

Static tables

Which of the following statements are incorrect?

A.

Page Store persists Pages and SQL reads pages

B.

Slice is independent and max size is 1GB

C.

Log Store defaults to multi-replica sync

D.

Log Store uses append-only

System tables and views record metadata for DB objects and users. Which system table or viewcannotbe used to query user information?

A.

pg_roles

B.

pg_user

C.

pg_auth_members

D.

pg_authid

Which are Huawei Cloud security services?

A.

Database Security Service (DBSS)

B.

Cloud Audit Service (CTS)

C.

VPC network security functions

D.

Identity and Access Management (IAM)

When querying information_schema.TABLES, which parameter indicates the size of table fragmentation?

A.

data volume

B.

data slice

C.

data_free

D.

data page

Which of the following is NOT a system built-in user in GaussDB (for MySQL)?

A.

rdsAdmin

B.

rdsRoot

C.

rdsMetric

D.

rdsBackup

In DRS, backup migration means reading local backup files and restoring to target DB.

A.

True

B.

False

Which of the following descriptions about Hint optimization strategies isincorrect?

A.

JOIN_PREFIX: uses the specified table order as thelastjoin order

B.

JOIN_FIXED_ORDER: uses the FROM clause's table order as the join order

C.

JOIN_ORDER: uses the specified table order as the join order

D.

MAX_EXECUTION_TIME: limits the statement execution time