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

Question 1

Which two statements are true for onbar only but not for ontape? (Choose two.)

A. It can restore data to a given point in time (PIT).

B. It can apply external programs using filters.

C. It can back up to or restore from cloud storage.

D. It can execute an external backup and restore.

E. It can restart a restore from the place it failed.

Correct Answer: A,E

Question 2

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

Question 3

Which statement about auditing is NOT true?

A. You can enable auditing row updates for all rows in the table.

B. You can enable auditing row updates just for a subset of rows in the table.

C. You can enable auditing row updates for all rows from all tables in the database and for the system catalog tables.

D. You can enable auditing row updates for all rows from all tables in the database except for system catalog tables.

Correct Answer: B

Question 4

Assuming the DBSPACETEMP onconfig and environment variables are set to valid dbspace names, where is the first location the instance will attempt to create a temporary non logged table?

A. rootdbs.

B. One of the dbspaces listed in the DBSPACETEMP configuration parameter.

C. The dbspace the database was created in.

D. One of the dbspaces listed in the DBSPACETEMP environment variable.

Correct Answer: D

Question 5

Which of the following schema privileges allows you to rename a fragment?

A. AMEND

B. RENAME

C. ALTER

D. MODIFY

Correct Answer: C

Question 6

Which storage space should be used to store columns defined as a BLOB or a CLOB?

A. sbspace

B. dbspace

C. blobspace

D. extspace

Correct Answer: A

Question 7

Which is NOT valid information in the SQLHOSTS connectivity file (or on windows the SQLHOSTS registry key)?

A. Number of listener threads.

B. Database server name or alias.

C. Connection type.

D. Host name and service name.

Correct Answer: A

Question 8

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

A. onstat

B. onmachinfo

C. dbinfo

D. dbschema

Correct Answer: A

Question 9

For a given procedure name, what is the objective of the SQL query shown below?

A. The query returns both ordered text and ordered compiled form of the specified procedure body.

B. The query returns neither the ordered text nor the ordered compiled form of the specified procedure body.

C. The query returns the ordered text form of the specified procedure body.

D. The query returns the ordered compiled form of the specified procedure body.

Correct Answer: C

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

Question 10

By default, the alarm program gets executed for which event(s)?

A. Only for events with Severity code 5.

B. Only for events with Severity code greater than 1.

C. Only for events with Severity code 1.

D. All events.

Correct Answer: B

Welcome to TestSimulate

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