IBM C2090-558 - Informix 11.70 Fundamentals Exam
Page: 3 / 24
Total 120 questions
Question #11 (Topic: Topic 1)
When encountering an assertion failure or performance issue, which Informix utility, when
run by the DBA, collects and bundles the basic diagnostic data?
run by the DBA, collects and bundles the basic diagnostic data?
A. ontape
B. onmode
C. ifxcollect
D. onparams
Answer: C
Question #12 (Topic: Topic 1)
Which Informix data movement utilities listed below can be used to move database from a
computer running Windows operating system to an Apple computer?
computer running Windows operating system to an Apple computer?
A. ontape
B. onunload and onload
C. ifxsend and ifxreceive
D. dbexport and dbimport
Answer: D
Question #13 (Topic: Topic 1)
What functionality is exclusive to onbar (i.e. not present in ontape)?
A. Restore of a single dbspace
B. Level 1 archive of the instance
C. Parallel restore of the instance
D. Change logging modes of a database
Answer: C
Question #14 (Topic: Topic 1)
Click the Exhibit button.
[IBM-C2090-558-6.0/IBM-C2090-558-8_2.png]
Which of the following will display the values in the lead_time column from highest to
lowest?
[IBM-C2090-558-6.0/IBM-C2090-558-8_2.png]
Which of the following will display the values in the lead_time column from highest to
lowest?
A. SELECT * FROM manufact ORDER BY lead_time
B. SELECT * FROM manufact ORDER BY lead_time ASC
C. SELECT * FROM manufact ORDER BY lead_time HIGH
D. SELECT * FROM manufact ORDER BY lead_time DESC
Answer: D
Question #15 (Topic: Topic 1)
You have a database server environment where all databases use buffered logging. In
which two conditions are the logical-log buffers in shared memory flushed to the logical log
on disk? (Choose two.)
which two conditions are the logical-log buffers in shared memory flushed to the logical log
on disk? (Choose two.)
A. When the buffer is full.
B. When a checkpoint occurs.
C. When a user issues a begin work.
D. When a user commits the transaction.
E. When a user rolls back the transaction.
Answer: A,B
