C2090-558 Free Practice Test

Business rules require that every time a row in table A is updated in your OLTP database, a row in table B must also be updated. How can you guarantee this rule will be maintained correctly and consistently when there are multiple applications and developers?

1. A. Use a trigger.
2. B. Create a foreign key.
3. C. Use a nightly batch process.
4. D. Define a task in the sysadmin database.

Correct Answer: A

Which Informix utility listed below will allow an administrator to run ad hoc SQL against the instance?

1. A. onsql
2. B. onadmin
3. C. dbaccess
4. D. dbschema

Correct Answer: C

Which of the following is true of system catalogs?

1. A. one system catalog per chunk
2. B. one system catalog per instance
3. C. one system catalog per database
4. D. one system catalog per installation

Correct Answer: C

Which utility can be used to relocate the physical log to a new dbspace?

1. A. onlog
2. B. ontape
3. C. onspaces
4. D. onparams

Correct Answer: D

Which two statements about oninit are correct? (Choose two.)

1. A. oninit can be used to initialize an Informix instance.
2. B. oninit -m starts an Informix instance in multi-user mode.
3. C. oninit -j starts an Informix instance in administration mode.
4. D. oninit has a functionally equivalent Administration API command string.
5. E. oninit can be used to change an instance from quiescent mode to online mode.

Correct Answer: AC