Free C2090-619 Exam Dumps

No Installation Required, Instantly Prepare for the C2090-619 exam and please click the below link to start the C2090-619 Exam Simulator with a real C2090-619 practice exam questions.
Use directly our on-line C2090-619 exam dumps materials and try our Testing Engine to pass the C2090-619 which is always updated.

Exam Code: C2090-619
Exam Title: IBM Informix 12.10 System Administrator (C2090-619)
Vendor: IBM
Exam Questions: 130
Last Updated: December 18th,2024

Question 1

Which Informix utility can be used to customize the onconfig file?

A. ifxdeploy
B. genoncfg
C. dbaccess
D. onparams

Correct Answer:B

Question 2

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

A. The connection protocol must be drsoctcp.
B. The database server name for DRDA connection must correspond to the DBSERVERNAME onconfig parameter.
C. The database server name for DRDA connection must correspond to the DBSERVERALIASES onconfig parameter.
D. The database server name should correspond to either the DBSERVERNAME or the DBSERVERALIASES onconfig parameter.

Correct Answer:C

Question 3

The Rolling Window clause of the ALTER FRAGMENT MODIFY INTERVAL statement CANNOT define a purging policy on a table that has which two attributes? (Choose two.)

A. The table has a ROWID shadow column.
B. The table has a Fragment By Range index.
C. The table has a Unique Key being used by ER.
D. The Fragment Key is defined with multiple columns.
E. The Primary Key for the table is referenced by a foreign key constraint.

Correct Answer:AE

Question 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. OVER
C. FROM
D. AVG (SUM(dollars))

Correct Answer:B

Question 5

What is the earliest version you can migrate / upgrade directly to Informix 12.10?

A. 7.30
B. 8.0
C. 9.40
D. 10.0

Correct Answer:D