Which of the following is the GaussDB200 database instance type?
A . CN
B . DN
C . WLM
D . GTM
Answer: A B C D
Are the following data distributed that do not belong to GaussDB200 OLAP?
Are the following data distributed that do not belong to GaussDB200 OLAP?
A . Hash
B . Replication
C . Partition
D . Sort
Answer: C D
Which of the following options is correct in the description of expansion and reduction
Which of the following options is correct in the description of expansion and reduction
A . Support DDL operations in user concurrent transaction blocks during capacity expansion
B . User concurrent transaction blocks are not supported during expansion to create Temp tables.
C . Physical clusters support scaling
D . For logical cluster scaling, it can be performed with only one DN
Answer: B
(Which of the following Hints cannot specify the result set of table t1 as 5 rows?
(Which of the following Hints cannot specify the result set of table t1 as 5 rows?
A . /* + row (t1% 5) * /
B . /* + rows (t1 # 5) * /
C . /* + rows (t1 # 5 t1)
D . /* + rows (t1 t2 *) * /
Answer: A C D
Any user can create table spaces.
Any user can create table spaces.
A . True
B . False
Answer: B
What types of execution engines are included?
What types of execution engines are included?
A . Line execution engine
B . Vectorized execution engine
C . Row and column hybrid execution engine
D . None of the above
Answer: A B C
Which of the following options is not the process of expanding the physical cluster to the logical cluster?
Which of the following options is not the process of expanding the physical cluster to the logical cluster?
A . Node preprocessing
B . Data redistribution
C . Add nodes to the elastic cluster
D . Capacity verification
Answer: C
Which of the following are important statistics for the execution of the statement
Which of the following are important statistics for the execution of the statement
A . Number of tuples in the table
B . Field width
C . NULL record ratio
D . ISTINCT value
E . MCV value (Most common value)
F . HB value
Answer: A B C D E F
FULL JOIN and CROSS JOIN results are equivalent
FULL JOIN and CROSS JOIN results are equivalent
A . TRUE
B . FALSE
Answer: B
In the logical cluster mode, if a user needs to perform SQL operations across a logical cluster, the system can be configured to reserve resources for the purpose of resource control.
In the logical cluster mode, if a user needs to perform SQL operations across a logical cluster, the system can be configured to reserve resources for the purpose of resource control.
A . T
B . F
Answer: A