C2090-619 Free Practice Test

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

1. A. sysadmin:admin_history
2. B. sysmaster:admin_history
3. C. sysadmin:command_history
4. D. sysmaster:command_history

Correct Answer: C

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

1. A. IBM DB2
2. B. IBM Informix
3. C. IBM solidDB
4. D. IBM InfoSphere Warehouse

Correct Answer: D

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

1. A. Informix OpenAdmin Tool does not support multiple languages.
2. B. Ontape backup can be taken using Informix OpenAdmin Tool.
3. C. Informix cluster cannot be managed using Informix OpenAdmin Tool.
4. D. Informix OpenAdmin Tool cannot be used to run the equivalent of onstat commands.
5. E. SQL explorer feature provides Query Drill Down functionality to analyze SQL statements.

Correct Answer: BE

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;

1. A. SUM
2. B. OVER
3. C. FROM
4. D. AVG (SUM(dollars))

Correct Answer: B

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

1. A. syslocks
2. B. systables
3. C. sysprofile
4. D. sysoverflow

Correct Answer: C