Actualtests offers free demo for C2090-558 exam. "Informix 11.70 Fundamentals (C2090-558)", also known as C2090-558 exam, is a IBM Certification. This set of posts, Passing the IBM C2090-558 exam, will help you answer those questions. The C2090-558 Questions & Answers covers all the knowledge points of the real exam. 100% real IBM C2090-558 exams and revised by experts!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-558 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-558 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-558-exam-dumps.html
Q41. Click the Exhibit button.
In the exhibit, which two statements are correct? (Choose two.)
A. the rootdbs dbspace is online
B. the dataspace dbspace is online
C. the rootdbs dbspace contains 2 chunks
D. the dataspace dbspace contains 2 chunks
E. the dataspace and rootdbs are both online
Answer: A,C
Q42. Which two events can initiate a trigger on a table? (Choose two.)
A. DROP B.
ALTER C.
INSERT D.
SELECT
E. TRUNCATE
Answer: C,D
Q43. Which one of the following is most suitable for scheduling administrative functions that need to be performed periodically?
A. Task
B. Trigger
C. Stored Procedure
D. User Defined Routine
Answer: A
Q44. There are two open sessions (session A and session B) that are updating the same tables. Session B is trying to read all rows in the table and is continuously receiving the error "-143 ISAM error: deadlock detected". Which action in session B would allow it to read all of the rows?
A. commit work;
B. set isolation to dirty read;
C. set lock mode to not wait;
D. set lock mode to nolocking;
Answer: B
Q45. What is the default isolation level on a database with unbuffered logging?
A. Dirty Read
B. Cursor Stability
C. Committed Read
D. Repeatable Read
Answer: C
Q46. From the items listed below, what is the smallest granularity of item which may be restored?
A. a single table
B. a single dbspace
C. an entire instance
D. a set of dbspaces
Answer: A
Q47. Which one of the following is a characteristic of a Decision Support System (DSS) or Data Warehousing environment?
A. frequent writes
B. frequent updates
C. uses query parallelization
D. typically uses memory resident tables
Answer: C
Q48. You create a table with the statement shown below: CREATE TABLE foo(col INTEGER) In which dbspace will the table reside?
A. in a temporary dbspace
B. in the default dbspace that is defined in onconfig
C. in the dbspace where the current database was created
D. in the dbspace specified by the IFX_DBSPACE environment variable
Answer: C
Q49. Which of the following is required for a cold restore?
A. A restore that includes the rootdbs
B. A restore that includes temp dbspaces
C. A restore that includes only non-critical dbspaces.
D. A restore that includes multiple level to be restored.
Answer: A
Q50. When encountering an assertion failure or performance issue, which Informix utility, when run by the DBA, collects and bundles the basic diagnostic data?
A. ontape
B. onmode
C. ifxcollect
D. onparams
Answer: C