C2090-619問題集、IBM実際の試験問題

質問 1

Which two technologies use the ENCRYPT_MAC configuration parameter to control the level of message authentication code (MAC) generation? (Choose two.)

A. Enterprise Replication

B. Column level encryption

C. Server-to-server distributed query communication

D. On-disk encryption

E. High-Availability Data Replication

正解: A,E

質問 2

Which statement is FALSE about dbspace configurable page sizes?

A. Possible page sizes are multiples of the default page size up to 16 kb.

B. Configure page sizes as close to the backup / restore and network buffer size as possible for efficient data transfer across the wire.

C. Dbspace page size should be configured to accommodate the greatest number of average row sizes with a minimum of remainder pages being used.

D. Dbspace page size can only be set for non-critical dbspaces.

正解: B

質問 3

When configuring Informix server for DRDA connection, which statement is true?

A. The database server name for DRDA connection must correspond to the
DBSERVERALIASES onconfig parameter.

B. The database server name should correspond to either the DBSERVERNAME or the
DBSERVERALIASES onconfig parameter.

C. The connection protocol must be drsoctcp.

D. The database server name for DRDA connection must correspond to the
DBSERVERNAME onconfig parameter.

正解: A

質問 4

Which one keyword in this query makes the AVG an OLAP window expression instead of the regular aggregate operator? SELECT AVG(SUM(dollars)) OVER() FROM sales;

A. SUM

B. AVG (SUM(dollars))

C. OVER

D. FROM

正解: C

質問 5

Which technology does NOT use the Secure Sockets Layer (SSL) protocol for an end-to- end secure connection?

A. Enterprise Replication

B. Server-to-server distributed query communication

C. On-disk encryption

D. High-Availability Data Replication

正解: C

質問 6

Which Enterprise Replication command CANNOT be used on replicates that include
TimeSeries columns?

A. cdr start

B. cdr sync

C. cdr realize

D. cdr remaster

正解: D

質問 7

During the database server initialization process, a number of environment variables are required. What is the order of precedence if the -file option is used?

A. Onconfig file, user local shell, system global

B. User local shell, system global

C. System global, user local shell

D. System global, user local shell, onconfig file

正解: A

質問 8

What is the primary benefit of a Storage Pool?

A. It allows space to automatically be added to dbspaces.

B. It allows data to be shared across dbspaces.

C. It allows space to be reserved for critical database operations.

D. It allows data to be shared across instances.

正解: A

質問 9

When the server is in administration mode, which users are NOT allowed to connect?

A. informix

B. Members of the DBSSO group

C. Users specified by ADMIN_MODE_USERS

D. Members of the DBSA group

正解: B

IBM Informix 12.10 System Administrator - C2090-619 模擬練習