C2090-918 Exam Questions

Free Download IBM C2090-918 PDF Full Version Now

Vendor: IBM
Exam Code: C2090-918
Exam Name: System Administration for IBM Informix Dynamic Server V11

QUESTION 1
An application uses temporary tables which currently reside in the rootdbs. The DBA has just added a temporary dbspace called “tempdbs” but notices that none of the temporary tables are using the dbspaces. Which action would the DBA take to force the temporary tables into the temporary dbspace?

A.    Set TEMP DBSPACE to “tempdbs”.
B.    Add another temp dbspace since the temp dbspace must be full.
C.    Set the onconfig parameter TEMPTAB_NOLOG to 1.
D.    Drop and re-create the temp dbspace.

Answer: C

Continue reading