Create Database Suggestions
- A . Object name does not exceed 64 bytes
- B . Use UTF-8 as the database default encoding set
- C . Don’t use multiple characters for object names
FULL JOIN and CROSS JOIN results are equivalent
- A . TRUE
- B . FALSE
Are the following execution methods of Stream operator?
- A . Sorted
- B . Broadcast
- C . Gather
- D . Hashed
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
Which two steps are involved in a two-phase transaction submission
- A . Transaction verification phase
- B . Transaction pre-commit phase
- C . Transaction back stage
- D . Global commit phase
When using the Migration Tool under Linux to migrate, entering the file permission setting process will cause the process to be terminated due to security issues
- A . T
- B . F
Which of the following modules guarantees high availability through active-standby replication?
- A . CN
- B . DN
- C . GTM
- D . CM Server
When the cluster status is Degraded: The cluster is available, but the data is not redundantly backed up. The DN master has one and only one exits abnormally. The GTM has only one host and the highest available mode. The CN has and only partially exits abnormally.
- A . True
- B . False
Which part of the overall installation process does the "planning data" belong to?
- A . Preparation before installation
- B . Software installation and deployment
- C . Inspection after installation
- D . System configuration
What other optimizations can be made to the audit function?
- A . Visualization (web graphics, reports)
- B . Security alarm
- C . Deep Security Analysis
- D . All of the above are correct
Are the following data distributed that do not belong to GaussDB200 OLAP?
- A . Hash
- B . Replication
- C . Partition
- D . Sort
(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 *) * /
The following values can be expressed as Boolean "true"
- A . TRUE
- B . "t"
- C . "true"
- D . "y"
What are the types of redistribution
- A . Slow redistribution
- B . Fast read-only redistribution
- C . Fast online redistribution
- D . Slow online redistribution
(Multiple choices) Which databases does GaussDB 200 database system initially include?
- A . template1
- B . postgres
- C . GaussDB 200
- D . template0
The main function of the execution engine is to parse the SQL query entered by the user. Generate execution plan
- A . TRUE
- B . FALSE
What kind of logs can be used for recovery in the event of a system crash
- A . System Log
- B . Performance Log
- C . pg_xlog
- D . pg_clog
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
Which of the following components does the user service use to access the GaussDB 200 database?
- A . DN
- B . GTM
- C . CM
- D . CN
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
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
What are the technical characteristics of GuassDB 200 database products?
- A . Low cost
- B . High performance
- C . High reliability
- D . Support massive data
(Which of the following clauses is dedicated to the condition filtering function in GROUP BY operation
- A . WHERE clause
- B . HAVING clause
- C . LIMIT clause
- D . ORDER BY clause
Table space that can be viewed when the view is modified
- A . TRUE
- B . FALSE
What are the implementation strategies of the Agg operator?
- A . 4
- B . 3
- C . 2
- D . 1
The lock mode used by the insert transaction is
- A . AccessShareLock
- B . RowExclusiveLock
- C . ShareUpdateExlusiveLock
- D . ExclusiveLock
Which of the following is the GaussDB200 database instance type?
- A . CN
- B . DN
- C . WLM
- D . GTM
DBMD_JOB is mainly used to handle large object types
- A . TRUE
- B . FALSE
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