C2090-619 Free Practice Test

Which action can be taken if an instance is down?

1. A. A point-in-time mixed restore.
2. B. Warm restore of non-critical storage spaces.
3. C. Cold restore by onbar using storage space backups taken by ontape on tape devices.
4. D. A mixed restore using onbar whole system backup and incremental dbspace level backups.

Correct Answer: A

Given the following:

How many locks will be used on tab1 to run the query?

1. A. 1
2. B. 2
3. C. Depends on the number of index pages accessed

Correct Answer: A

Which log file CANNOT be rotated using the default "message log rotate" SQL admin command?

1. A. audit log
2. B. message log
3. C. onbar debug log
4. D. onbar activity log

Correct Answer: A

Which feature can be enabled in Informix?

1. A. Automatic addition of a CPU VP.
2. B. Automatic addition of an ADM VP.
3. C. Automatic extension of storage spaces.
4. D. Automatic addition of message log files.

Correct Answer: C

Which type of device does Primary Storage Manager support?

1. A. File
2. B. Tape
3. C. Directory
4. D. Named pipe

Correct Answer: A