H14-311_V1.0-ENU 実際試験問題と解答 - 模擬練習 - 受験自信を増やす

Question No : 1
NUMA distance (NUMA: Non-Uniform Memory Access refers to the physical distance between the processor and memory block of a NUM anode).
Reasonable distance.
Which of the following tools can be used to query CPU access distance information?

A.coreinfo
B.numactl
C.numastat
D.numacheck

正解:

Question No : 2
When was OpenGuass released as an open-source application?

A.2019
B.2020
C.2021
D.2022

正解:

Question No : 3
What is the relationship between a database management system and an operating system?

A.Mutual Invocation
B.Database system calls the operating system
C.The operating system calls the database management system.
D.Concurrent operation

正解:

Question No : 4
After enabling the separation of duties in GaussDB (for openGauss), which administrator can view the audit logs?

A.Security Administrator
B.Storage Administrator
C.Audit Administrator
D.System Administrator

正解:

Question No : 5
An application can set its own parameters by calling gsguc. What does -NI mean?

A.Represents all hosts in openGaussl
B.Represents all instances of the host.
C.Indicates that clients are allowed to connect to any database.
D.Indicates the statement that needs to be added to "pg_hba.conf".

正解:

Question No : 6
Which of the following tools is used to set parameters in the openGauss configuration file ("postgresql..conf" "pghba.conf"), where the default values for the parameters are in standalone configuration mode?

A.gsql
B.gs_guc
C.gs_checkos
D.gs_om

正解:

Question No : 7
Which thread is responsible for copying dirty page data to the double-write area and writing it to disk, and then forwarding the dirty page to the bgwriter child thread for data write-to-disk operation?

A.bgwriter thread
B.PageWriter thread
C.bgwriter thread
D.walwriter thread

正解:

Question No : 8
openGauss integrates anomaly_detection, a tool that can be used for database metric collection, prediction, and anomaly monitoring and diagnosis.
Which of the following descriptions about anomaly_detection is incorrect?

A.anomaly_detection can monitor multiple metrics simultaneously and predict the future trend of each metric.
B.anomaly_detection consists of two parts: agent and detector.
C.The agent module of anomaly_detection can be deployed on different servers from the openGauss database environment.
D.The detector module of anomaly_detection communicates with the agent module via HTTP or HTTP

正解:

Question No : 9
Which of the following commonly used data types is aliased as INT4?

A.TINYINT
B.SMALLINT
C.INTEGER
D.BIGINT

正解:

Question No : 10
Which of the following type conversion functions is used to convert x to the type specified by y?

A.hextoraw (string)
B.cast (x as y)
C.pg_systimestamp()
D.to_bigint(varchar)

正解:

Question No : 11
Which of the following keywords indicates that if there are objects that depend on this DataSource, then the DataSource cannot be deleted?

A.src_name
B.CASCADE
C.RESTRICT
D.IFEXISTS

正解:

Question No : 12
The WAL (WriteAheadLog) log is very important in the openGauss database and may be used for operation recovery in the event of a system crash.
Which of the following is the default folder where WAL logs are located?

A.pg_log
B.pg_xlog
C.pg_audit
D.global

正解:

Question No : 13
Regarding the second normal form of a database, which of the following statements is incorrect?

A.When a table has a composite primary key, other non-primary key fields can partially depend on a field in the composite key.
B.2NF is built on the foundation of 1NF, meaning that to satisfy 2NF, 1NF must first be satisfied.
C.c. 2NF requires that each instance or row in a database table must be uniquely distinguishable.
D.d.2NF emphasizes full functional dependency.

正解:

Question No : 14
In openGauss, which of the following permissions do all created users and roles have by default?

A.admin
B.dba
C.PUBLIC
D.administrator

正解:

Question No : 15
In openGauss, system tables and all built-in data types, functions, and operators belong to which schema?

A.pg_catalog
B.pg_temp
C.information schema
D.public

正解:

Huawei H14-311_V1.0-ENU 問題練習