C2090-558 Online Practice Questions and Answers

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

A. onlog

B. ontape

C. onspaces

D. onparams

Which two operations are performed with the onspaces command? (Choose two.)

A. Add space to the server.

B. Compress server space.

C. Encrypt the server space.

D. Remove space from the server.

E. Restrict access to the server space.

Which Informix data movement utilities listed below can be used to move database from a computer running Windows operating system to an Apple computer?

A. ontape

B. onunload and onload

C. ifxsend and ifxreceive

D. dbexport and dbimport

Informix is currently in online mode. As a DataBase System Administrator (DBSA), you switch to administration mode with ADMIN_USER_MODE_WITH_DBSA = 0. Who can access Informix databases?

A. only Informix

B. only a DBSA

C. only Informix or a DBSA

D. only root, Informix or a DBSA

In which database does Informix store the information when a new task is created in OpenAdmin Tool's Task Scheduler?

A. sysutils

B. sysusers

C. sysadmin

D. sysmaster

How does an administrator allocate a new dbspace from the storagepool?

A. Use the SQL Admin API

B. Use the oninit command

C. Use the onadmin command

D. Use the onspaces command.

Click the Exhibit button.

The tables shown in the exhibit have been created for a class enrollment system where a course can be assigned to many classes. The class table joins to the course table on the course_num columns. Which two of the following SQL statements are required to establish a referential integrity relationship between these tables? (Choose two.)

A. ALTER TABLE class ADD CONSTRAINT (PRIMARY KEY (class_id));

B. ALTER TABLE class ADD CONSTRAINT (PRIMARY KEY (course_num));

C. ALTER TABLE course ADD CONSTRAINT (PRIMARY KEY (course_num));

D. ALTER TABLE class ADD CONSTRAINT (FOREIGN KEY (course_num) REFERENCES course);

E. ALTER TABLE course ADD CONSTRAINT (FOREIGN KEY (course_num) REFERENCES class);

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?

A. Use a trigger.

B. Create a foreign key.

C. Use a nightly batch process.

D. Define a task in the sysadmin database.

Which of the following is required for a cold restore?

A. A restore that includes the rootdbs

B. A restore that includes temp dbspaces

C. A restore that includes only non-critical dbspaces.

D. A restore that includes multiple level to be restored.

Which two SQL API commands can be used to create a 10 MB dbspace? (Choose two.)

A. task ( )

B. admin ( )

C. oncmd ( )

D. ifxcreate ( )

E. oncreate ( )