Informix 11.70 System Administrator (C2090-919) Free Practice Test

Question 1

Which command line utility displays real time statistics about the instance?

A. onstat

B. onmachinfo

C. dbinfo

D. dbschema

Correct Answer: A

Question 2

To maximize the performance of your OnBar backup and recovery operations, what should you do?

A. Use a combination of disk-based and tape-based backup devices.

B. Use a commercial storage manager.

C. Use the bundled Informix Storage Manager (ISM).

D. Use separate storage devices for instance spaces and logical logs.

Correct Answer: D

Question 3

How many paging files are required for SD secondary instances?

A. It depends on how many CPU VPs you have.

B. It depends on how many data dbspaces you have.

C. It depends on how many temporary dbspaces you have.

D. There should always be two.

Correct Answer: D

Question 4

The user 'guest' connected to a local database world@lsys and wants to execute the following query:

What two permissions does the user 'guest' need to access the remote table? (Choose two.)

A. User 'guest' must have CONNECT permission on 'globe'

B. User 'guest' must have RESOURCE permission on 'world@lsys'

C. User 'guest' must have SELECT permission on 'globe@rsys:position'

D. User 'guest' must have SELECT permission on 'globe'

E. User 'guest' must have CONNECT permission on 'globe@rsys:sadm.position'

Correct Answer: A,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

The following shrink command has what effect on the customer table? execute function sysadmin:task("table shrink","customer")

A. Moves all rows to the beginning of the table while users can modify the table.

B. Locks the table in exclusive mode and releases all free space at the end of the table.

C. Locks the table in exclusive mode and moves all rows to the beginning of the table.

D. Releases all free space at the end of the table to the dbspace while users can modify the table.

Correct Answer: D

Question 6

Which action will NOT occur when the following command is executed? UPDATE STATISTICS HIGH

A. Update statistics high on all tables.

B. Recompile all stored procedures.

C. Update statistics low on all tables.

D. Update statistics medium on all tables.

Correct Answer: D

Question 7

What two onconfig parameters will help improve performance of new network connections? (Choose two.)

A. FET_BUF_SIZE

B. NETTYPE

C. NUMFDSERVERS

D. VPCLASS

E. NS_CACHE

Correct Answer: C,E

Welcome to TestSimulate

IBM Informix 11.70 System Administrator (C2090-919) Free Practice Test