C2090-558 Online Practice Questions and Answers

Which two of the following are required for creating a dbspace? (Choose two.)

A. a mirror chunk

B. two or more chunks

C. a cooked file or raw device

D. a file owned by root or administrator

E. dbspace name containing only letters, digits, underscores, or $ characters.

What Informix data type is suitable for storing video clips up to a size of 4 TB?

A. BLOB

B. BYTE

C. CLOB

D. COLLECTION

Which two products can be used by client applications to connect to Informix instances? (Choose two.)

A. IBM Global Connect

B. IBM Informix Connect

C. IBM Informix JDBC Driver

D. IBM Informix Office Manager

E. IBM Informix Universal Driver Kit

Which command could be used to display the definition of user-defined and complex data types?

A. onstat -g smb

B. oncheck -cc database_name

C. oncheck -pB database_name

D. dbschema -u all -d database_name

Which phase of Fast Recovery rolls forward (restores) all transactions since the last checkpoint and rolls back any uncommitted transactions?

A. Logical Recovery

B. Physical Recovery

C. Dbspace Recovery

D. Transactional Recovery

Given the following: CREATE TABLE customer (customer_num INT, company CHAR(25)); Which of the following SQL statements will return an error?

A. INSERT INTO customer VALUES (453);

B. INSERT INTO customer VALUES (453, '"ABC Company");

C. INSERT INTO customer (company) VALUES ("ABC Company");

D. INSERT INTO customer (customer_num, company) VALUES (453, "ABC Company");

What does the dbschema -ss option explicitly show besides lock mode, fragmentation strategy, and dbspace name?

A. pagesize

B. extent size

C. creation date

D. partition partnum

Which of the following statements is true about referential integrity?

A. Primary and foreign key values must be integers.

B. You must explicitly define constraint names for primary and foreign key columns.

C. A row in a table cannot be deleted if it contains a foreign key value that exists as a primary key value in the referenced table.

D. A row in a table cannot be deleted if it contains a primary key value that is referenced by a foreign key value in another table.

Which database contains the system-monitoring interface (SMI) tables which provide information about the state of the database server?

A. sysutils

B. sysstate

C. sysmaster

D. sysmonitor

You create a table with the statement shown below: CREATE TABLE foo(col INTEGER) In which dbspace will the table reside?

A. in a temporary dbspace

B. in the default dbspace that is defined in onconfig

C. in the dbspace where the current database was created

D. in the dbspace specified by the IFX_DBSPACE environment variable