C2090-558 Exam Questions
117 real C2090-558 exam questions with expert-verified answers and explanations. Page 1 of 3.
- Question #1
In which way is a Remote Standalone (RS) secondary server different from a High- Availability Data Replication (HDR) secondary server?
- Question #2
Which two statements are true about the COMMIT WORK statement? (Choose two.)
- Question #3
How can you determine which databases are created in an instance?
- Question #4
In which two places may a function be used in a SELECT statement? (Choose two.)
- Question #5
Which two operations are performed with the onspaces command? (Choose two.)
- Question #6
Which statement will change the column address1 to a null value?
- Question #7
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...
- Question #8
Which two installation modes are available for Informix? (Choose two.)
- Question #9
Which of the following statements can be used to prevent duplicate values in an indexed column?
- Question #10
Which utility can be used to relocate the physical log to a new dbspace?
- Question #11
How does an administrator allocate a new dbspace from the storagepool?
- Question #12
When encountering an assertion failure or performance issue, which Informix utility, when run by the DBA, collects and bundles the basic diagnostic data?
- Question #13
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...
- Question #14
Which of the following is true about star schemas?
- Question #15
Which of the following modes is NOT supported by Informix?
- Question #16
Which of the following methods will allow you to determine how much space is currently in use?
- Question #17
Which authentication functionality allows you to implement different authentication mechanisms for different applications?
- Question #18
Which of the following utilities can be used for quick installation of pre-configured IBM Informix instances to many computers?
- Question #19
When storing string "ABCD" in a column, which of the following data types will result in a string stored with 2 padded spaces?
- Question #20
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...
- Question #21
You want to use sqlhosts file /newlocation/newsqlhosts. Which of the following is true?
- Question #22
Which document provides details on preparing an operating system to run Informix?
- Question #23
What are two ways to create table t1 with row level locking? (Choose two.)
- Question #24
What are two system level databases? (Choose two.)
- Question #25
Which table type is always nonlogging?
- Question #26
Assuming the tables and columns mentioned below exist, which of the following SQL statements will return an error?
- Question #27
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?
- Question #28
Which one of the following is most suitable for scheduling the periodic collection of data about an instance?
- Question #29
Which of the following privileges can NOT be granted to a role?
- Question #30
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...
- Question #31
Which Informix data movement utilities listed below can be used to move database from a computer running Windows operating system to an Apple computer?
- Question #32
Given the query shown below: What will happen?
- Question #33
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...
- Question #34
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?
- Question #35
In which database does Informix store the information when a new task is created in OpenAdmin Tool's Task Scheduler?
- Question #36
Which two statements will delete all rows from table_name? (Choose two.)
- Question #37
Given INFORMIXCONTIME = 60 and INFORMIXCONRETRY = 3, if the initial connection attempt fails, what subsequent attempts will be made to connect?
- Question #38
Which of the following can be used to create and drop logical logs?
- Question #39
Which two products can be used by client applications to connect to Informix instances? (Choose two.)
- Question #40
Which of the following is true about system catalog tables access?
- Question #41
Which of the following environment variables allow an application to specify formatting of locale- sensitive data such as of date and currency values?
- Question #42
Which one of the following will generate a typical Decision Support System (DSS) type of workload?
- Question #43
Which Informix utility listed below will allow an administrator to run ad hoc SQL against the instance?
- Question #44
Which two storage objects exist in Informix? (Choose two.)
- Question #45
What is the lowest level of granularity supported by Enterprise Replication?
- Question #46
Which two SQL commands can be used to invoke a stored procedure? (Choose two.)
- Question #47
Which two statements will update all rows in the customer table? (Choose two.)
- Question #48
What is the minimum database-level privilage required for a user to create Stored Procedure Language routines?
- Question #49
Which command would you execute to restore an instance without using or restoring the logical logs?
- Question #51
What is true about poll threads?