Which of the following is the GaussDB200 database instance type?

Which of the following is the GaussDB200 database instance type?A . CNB . DNC . WLMD . GTMView AnswerAnswer: A B C D

October 17, 2020 No Comments READ MORE +

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 . HashB . ReplicationC . PartitionD . SortView AnswerAnswer: C D

October 16, 2020 No Comments READ MORE +

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 reductionA . Support DDL operations in user concurrent transaction blocks during capacity expansionB . User concurrent transaction blocks are not supported during expansion to create Temp tables.C . Physical clusters support scalingD . For logical cluster scaling,...

October 15, 2020 No Comments READ MORE +

(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 *) * /View...

October 15, 2020 No Comments READ MORE +

Any user can create table spaces.

Any user can create table spaces.A . TrueB . FalseView AnswerAnswer: B

October 15, 2020 No Comments READ MORE +

What types of execution engines are included?

What types of execution engines are included?A . Line execution engineB . Vectorized execution engineC . Row and column hybrid execution engineD . None of the aboveView AnswerAnswer: A B C

October 15, 2020 No Comments READ MORE +

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 preprocessingB . Data redistributionC . Add nodes to the elastic clusterD . Capacity verificationView AnswerAnswer: C

October 14, 2020 No Comments READ MORE +

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 statementA . Number of tuples in the tableB . Field widthC . NULL record ratioD . ISTINCT valueE . MCV value (Most common value)F . HB valueView AnswerAnswer: A B C D E F

October 14, 2020 No Comments READ MORE +

FULL JOIN and CROSS JOIN results are equivalent

FULL JOIN and CROSS JOIN results are equivalentA . TRUEB . FALSEView AnswerAnswer: B

October 13, 2020 No Comments READ MORE +

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 . TB . FView AnswerAnswer: A

October 13, 2020 No Comments READ MORE +