Which of the following is true about system catalog tables access?

A. Only user informix can read system catalog tables

B. Only system administrators can read system catalog tables

C. Only database administrators can read system catalog tables

D. Any user that can connect to the database can read system catalog tables

Which of the following can be used to create and drop logical logs?

A. onlog

B. ondblog

C. onspaces

D. onparams

Which one of the following is most suitable for scheduling the periodic collection of data about an instance?

A. Sensor

B. Trigger

C. Stored Procedure

D. User Defined Routine

Given the query shown below:

What will happen?

A. All rows will be retrieved in which item_desc contains the characters 'pencil'.

B. All rows will be retrieved in which item_desc does not contain the characters 'pencil'.

C. All rows will be retrieved in which item_desc contains the letters 'p', 'e', 'n', 'c', 'i' and 'l' in any order.

D. All rows will be retrieved in which item_desc contains the letters "P', 'E', 'N, C', I' and 'L' in any order.

Which document describes new Informix features?

A. oncofig.std file

B. Release Notes

C. Machine Notes

D. Quick Start Guide

Given the following table definition: CREATE TABLE t1(col1 BOOLEAN); Which of the following statements will fail to insert a row?

A. INSERT INTO t1 values ('t');

B. INSERT INTO t1 values ('f');

C. INSERT INTO t1 values (1);

D. INSERT INTO t1 values (NULL);

When you execute an INSERT statement, the database server will insert a NULL value into any column that meets which two conditions? (Choose two.)

A. Columns that are used in indexes.

B. Columns that are used in constraints.

C. You provide no value for a specific column.

D. Where a zero is specified in the VALUES clause of a serial column.

E. Where you specify the NULL keyword in the VALUES clause for a specific column.

Which configuration parameter allows you to reduce the dependency on local OS user accounts and to enable a DBSA to grant database server access to specific users without the OS user accounts?

A. USERMAPPING

B. IFX_EXTEND_ROLE

C. SECURITY_LOCALCONNECTION

D. ADMIN_USER_MODE_WITH_DBSA

Click the Exhibit button.

In the exhibit, which ALTER TABLE statement is used to add the foreign key constraint where customer_num column in the orders table is a foreign key that references the customer_num column in the customer table?

A. ALTER TABLE customer ADD CONSTRAINT (FOREIGN KEY (order_num) REFERENCES order );

B. ALTER TABLE orders ADD CONSTRAINT (FOREIGN KEY (order_num) REFERENCES customer );

C. ALTER TABLE customer ADD CONSTRAINT (FOREIGN KEY (customer_num) REFERENCES order );

D. ALTER TABLE orders ADD CONSTRAINT (FOREIGN KEY (customer_num) REFERENCES customer );

Which of the following is true of system catalogs?

A. one system catalog per chunk

B. one system catalog per instance

C. one system catalog per database

D. one system catalog per installation