C2090-558 Online Practice Questions and Answers

You have a database server environment where all databases use buffered logging. In which two conditions are the logical-log buffers in shared memory flushed to the logical log on disk? (Choose two.)

A. When the buffer is full.

B. When a checkpoint occurs.

C. When a user issues a begin work.

D. When a user commits the transaction.

E. When a user rolls back the transaction.

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 authentication functionality allows you to implement different authentication mechanisms for different applications?

A. Single Sign-On

B. Secure Socket Layer

C. Pluggable Authentication Modules

D. Lightweight Directory Access Protocol

Which of the following is true about star schemas?

A. A star schema is optimal for OLTP systems.

B. A star schema is also known as a 3rdNormal Form schema.

C. A star schema is associated with master-detail relationships between tables.

D. A star schema is not necessarily a snowflake schema, but a snowflake schema is always a star schema.

When installing Informix, which two installation methods can be used? (Choose two.)

A. quiet

B. native

C. staged

D. console

E. graphical

Which configuration parameters are used by ontape logical log backup?

A. LOGFILES, LOGSIZE, TAPEDEV

B. LTAPEBLK, TAPEDEV, TAPESIZE

C. LTAPESIZE, LTAPEDEV, LTAPEBLK

D. TAPEDEV, BAR_ACT_LOG, BACKUP_FILTER

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.

A DBA wants to know which commands have been executed through the SQL Admin API. What is the correct action?

A. Use the built-in tasks in the sysadmin database.

B. Query the ph_run table in the sysadmin database.

C. Query the ph_task table in the sysadmin database.

D. Query the command_history table in the sysadmin database.

What is true about poll threads?

A. poll threads always run on a CPU vp

B. poll threads always run on a NET vp

C. poll threads always run on an ADM vp

D. poll threads can be configured on a CPU or NET vp