C2090-558 Exam Questions

What is the only isolation level available on an unlogged database?

Which statement is used to create a permanent nonlogged table in a logged database?

What is the default isolation level on a database with unbuffered logging?

You received an error, "Chunk is not empty", while trying to remove a chunk. How do you verify which objects still occupy space in the chunk?

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

Which two statements about oninit are correct? (Choose two.)

Which two statements cause Stored Procedure Language (SPL) routine optimization? (Choose two.)

Which two commands would create a table t1 with page level locking assuming default configuration parameter settings? (Choose two.)

Which of the following statement is true of System Monitoring Interface (SMI) tables?

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

Which technology can be used to execute Data Definition Language (DDL) command across multiple instances?

Which of the following Informix server modes disable execution of SQL statements for all users while allowing administrative users to perform maintenance tasks?

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

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

Which keyword is used to determine whether a comparison is true for every value returned from a subquery?

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

Which command listed below can be used to change the state of an operating Informix server?

There are two open sessions (session A and session B) that are updating the same tables. Session B is trying to read all rows in the table and is continuously receiving the error "...

Click the Exhibit button. In the exhibit, which two statements are correct? (Choose two.)

Which of the following methods can be used to tranfer data in EXPRESS mode?

From the items listed below, what is the smallest granularity of item which may be restored?

Which two tasks can be accomplished using the OpenAdmin Tool (OAT)? (Choose two.)

Adding a row to which one of the following tables is required to create a database scheduler job?

What are the three major steps in implementing Label-Based Access Control (LBAC) in an instance environment? (Choose three.)

Which command can be executed against a view?

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

Which two database objects can be created using fragmentation? (Choose two.)

Which of the following is true of system catalogs?

Which of the following can be used to move the physical log?

Which utility would you use to print out the physical layout of the instance?

Which of the following can be used in a SELECT statement to set one or more qualifying conditions to a group of records after they are formed?

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

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

What is the purpose of DB_LOCALE?

Which configuration parameters are used by ontape logical log backup?

Which two column definitions can store whole numbers from -(2^63-1) to (2^63-1)? (Choose two.)

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

Which statement is true when using onload/onunload?

What is the default isolation level on a mode ANSI database?

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

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

Which search condition is allowed in a check constraint?

Which statement can be used to roll back SQL statements within a transaction?

Which isolation level is appropriate if you do not want your query to place any locks?

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

When restoring data, which granularity of object may NOT be restored?

Click the Exhibit button. An administrator created a table using the SQL statement shown in the exhibit to perform a load operation every day at 11:00 AM. What is the best way to o...

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

Which of the following statement is correct about Shared Disk (SD) secondary servers?

Which of the following statements is true about referential integrity?