C2090-558 Exam Questions

In which way is a Remote Standalone (RS) secondary server different from a High- Availability Data Replication (HDR) secondary server?

Which two statements are true about the COMMIT WORK statement? (Choose two.)

How can you determine which databases are created in an instance?

In which two places may a function be used in a SELECT statement? (Choose two.)

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

Which statement will change the column address1 to a null value?

You are about to create and load a table that will initially have a size of 50,000 KB. Once the table has been loaded, there will be very few additional inserts or updates to the t...

Which two installation modes are available for Informix? (Choose two.)

Which of the following statements can be used to prevent duplicate values in an indexed column?

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

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

When encountering an assertion failure or performance issue, which Informix utility, when run by the DBA, collects and bundles the basic diagnostic data?

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...

Which of the following is true about star schemas?

Which of the following modes is NOT supported by Informix?

Which of the following methods will allow you to determine how much space is currently in use?

Which authentication functionality allows you to implement different authentication mechanisms for different applications?

Which of the following utilities can be used for quick installation of pre-configured IBM Informix instances to many computers?

When storing string "ABCD" in a column, which of the following data types will result in a string stored with 2 padded spaces?

Which of these commands will create a table containing a column that will be automatically populated with a numeric value starting from an initial value of 2301 and incremented as...

You want to use sqlhosts file /newlocation/newsqlhosts. Which of the following is true?

Which document provides details on preparing an operating system to run Informix?

What are two ways to create table t1 with row level locking? (Choose two.)

What are two system level databases? (Choose two.)

Which table type is always nonlogging?

Assuming the tables and columns mentioned below exist, which of the following SQL statements will return an error?

A progammer wants to unload a table to a file inside a stored procedure. What functionality listed below will help the programmer accomplish the task?

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

Which of the following privileges can NOT be granted to a role?

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...

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

Given the query shown below: What will happen?

Click the Exhibit button. The query.sql file contains the information shown in the exhibit. The following command is run: dbaccess -query.sql How many rows will be returned by the...

Click the Exhibit button. In the exhibit, which statement is true regarding the update statement of Client 2 if both of the clients are connected to the same logged database?

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

Which two statements will delete all rows from table_name? (Choose two.)

Given INFORMIXCONTIME = 60 and INFORMIXCONRETRY = 3, if the initial connection attempt fails, what subsequent attempts will be made to connect?

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

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

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

Which of the following environment variables allow an application to specify formatting of locale- sensitive data such as of date and currency values?

Which one of the following will generate a typical Decision Support System (DSS) type of workload?

Which Informix utility listed below will allow an administrator to run ad hoc SQL against the instance?

Which two storage objects exist in Informix? (Choose two.)

What is the lowest level of granularity supported by Enterprise Replication?

Which two SQL commands can be used to invoke a stored procedure? (Choose two.)

Which two statements will update all rows in the customer table? (Choose two.)

What is the minimum database-level privilage required for a user to create Stored Procedure Language routines?

Which command would you execute to restore an instance without using or restoring the logical logs?

What is true about poll threads?