C2090-619 Dumps

C2090-619 Free Practice Test

IBM C2090-619: IBM Informix 12.10 System Administrator (C2090-619)

QUESTION 31

In which table can you find a history of all SQL Administration API functions executed in the last 30 days?

Correct Answer: C

QUESTION 32

Which is NOT a component of the IBM Mobile Database offering?

Correct Answer: D

QUESTION 33

Which two statements are true about Informix OpenAdmin Tool? (Choose two.)

Correct Answer: BE

QUESTION 34

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;

Correct Answer: B

QUESTION 35

The 'onstat -k' output is showing '56 lock table overflows'. Which catalog table can be used to display the relevant lock statistics?

Correct Answer: C