IBM Informix 12.10 System Administrator (000-619) Free Practice Test

Question 1

Which two statements are true about blobspace? (Choose two.)

A. A newly created blobspace is immediately available for storage of TEXT or BYTE data.

B. A blobspace is a logical storage unit that stores only TEXT and BYTE data.

C. The database server writes data stored in a blobspace directly to disk without passing it through the bufferpool.

D. The TEXT or BYTE objects that are assigned to a blobspace are physically logged.

E. The TEXT or BYTE objects are stored in the logical log files.

Correct Answer: B,C

Question 2

Which two statements are true about archecker utility? (Choose two.)

A. Archecker can use all kind of connections protocols, including shared memory connections.

B. Archecker can help developers team to debug procedures.

C. Archecker can do data restore (physical or logical) of database portions, table portions, or even a set of tables.

D. Archecker can do backup testing, fully integrated with onbar and ontape utilities.

E. Archecker can copy data from different servers, even restoring from a remote device.

Correct Answer: C,D

Question 3

Which technology does NOT use the Secure Sockets Layer (SSL) protocol for an end-to- end secure connection?

A. On-disk encryption

B. High-Availability Data Replication

C. Server-to-server distributed query communication

D. Enterprise Replication

Correct Answer: A

Question 4

Which two statements are true about Enterprise Replication of TimeSeries data types?
(Choose two.)

A. The WHERE clause in the participant definition must include a TimeSeries column.

B. The conflict resolution rule must be always-apply.

C. CDR_TSINSTANCEID configuration parameter must be set to the same value for every replication server.

D. ATS and RIS files must be in XML format.

E. The replicate must be a mastered replicate.

Correct Answer: B,E

Question 5

During the database server initialization process, a number of environment variables are required. What is the order of precedence if the -file option is used?

A. Onconfig file, user local shell, system global

B. System global, user local shell, onconfig file

C. User local shell, system global

D. System global, user local shell

Correct Answer: A

Question 6

"informix_stores" is an established primary server with a SDS server. What is the effect of running the following command? EXECUTE FUNCTION sysadmin:admin("ha sds clear",
"informix_stores");

A. Converts the shared disk secondary server to a standard server and shuts down the primary server.

B. Clears the log position of the SDS servers and restarts replication.

C. Shuts down the primary server and converts the secondary server to be the primary.

D. Stops replication to the shared disk secondary servers and converts the primary server to a standard server.

Correct Answer: D

Question 7

Which statement is true about restartable restore?

A. ontape can perform restartable restores if a backup is taken to disk.

B. Restartable restore is the ability to restart a failed restore using onbar.

C. Restartable restore is the ability to restart an instance using a restore from some other computer.

D. Restartable restore is the ability to restart a failed restore using ontape.

Correct Answer: B

Welcome to TestSimulate

IBM Informix 12.10 System Administrator (000-619) Free Practice Test