Huawei Certification H13-921_V1.5 Passing Score

HCIP-GaussDB-OLTP V1.5 Questions and Answers

Question 29

Which window function generates a ranking within groups, where the same value gets the same rank?

DENS

RANK()

PERCENT_RANK()

ROW_NUMBER()

Question 30

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

Dynamic tables

Compressed tables

Temporary tables

Static tables

Question 31

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

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

Roles have the ability to log in and execute SQL statements

Databases use roles to organize and divide permissions

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

Question 32

What is the impossible result of executing: SELECT FLOOR(8 + (RAND()* 5));?