Informix 11.70 Fundamentals

Here you have the best IBM C2090-558 practice exam questions

You have 120 total questions to study from
Each page has 5 questions, making a total of 24 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on November 12, 2025
This site is not affiliated with or endorsed by IBM.

Question 1 of 120

When restoring data, which granularity of object may NOT be restored?

a single table

a single chunk

a single dbspace

an entire instance

Correct Answer: B

Question 2 of 120

Click the Exhibit button.
Exam C2090-558: Question 2 - Image 1

In the exhibit, which statement is true regarding the update statement of Client 2 if both of the clients are connected to the same logged database?

Client 2 will update col2 of the rows having col1=20.

Client 2 will return successfully without updating any rows.

Client 2 will keep waiting for client 1 to finish its transaction.

Client 2 will get an error that the "record is locked" or the "table is locked".

Correct Answer: D

Question 3 of 120

Under which of the following conditions does the LAST COMMITTED option have an effect on the COMMITTED READ isolation level?

Row level lock

Page level locking

RAW or unlogged tables

Tables containing complex data types

Correct Answer: A

Question 4 of 120

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.)

When the buffer is full.

When a checkpoint occurs.

When a user issues a begin work.

When a user commits the transaction.

When a user rolls back the transaction.

Correct Answer: A, B

Question 5 of 120

What are two ways to create table t1 with row level locking? (Choose two.)

Execute the command "create table t1 (c1 int) locking row".

Execute the command "create table t1 (c1 int) lock level row".

Execute the command "create table t1 (c1 int) lock mode row".

Set DEF_TABLE_LOCKMODE to ROW in ONCONFIG before executing "create table t1(c1 int)".

Set the environment variable DEF_TABLE_LOCKMODE to ROW before executing "create table t1(c1 int)".

Correct Answer: C, D