C2090-558 Online Practice Questions and Answers
Given INFORMIXCONTIME = 60 and INFORMIXCONRETRY = 3, if the initial connection attempt fails, what subsequent attempts will be made to connect?
A. 60 and 120 seconds before aborting
B. Every 3 minutes within one hour before aborting
C. Every 3 seconds within one hour before aborting
D. Wait indefinitely until it is successfully completed
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 rows are inserted?
A. CREATE TABLE customer (cust_num SERIAL(2301), ?;
B. CREATE TABLE customer (cust_num SERIAL INIT 2301,?;
C. CREATE TABLE customer (cust_num INT SET SERIAL 2301,?;
D. CREATE TABLE customer (cust_num SERIAL,? SET SERIAL 2301;
When installing Informix, which two installation methods can be used? (Choose two.)
A. quiet
B. native
C. staged
D. console
E. graphical
What is the minimum database-level privilage required for a user to create Stored Procedure Language routines?
A. DBA
B. Execute
C. Connect
D. Resource
From the items listed below, what is the smallest granularity of item which may be restored?
A. a single table
B. a single dbspace
C. an entire instance
D. a set of dbspaces
What is the default isolation level on a database with unbuffered logging?
A. Dirty Read
B. Cursor Stability
C. Committed Read
D. Repeatable Read
Click the Exhibit button.
In the exhibit, which two statements are correct? (Choose two.)
A. the rootdbs dbspace is online
B. the dataspace dbspace is online
C. the rootdbs dbspace contains 2 chunks
D. the dataspace dbspace contains 2 chunks
E. the dataspace and rootdbs are both online
Which of the following can be used to move the physical log?
A. onlog
B. ondblog
C. onspaces
D. onparams
Which command can be executed against a view?
A. DEFRAGMENT
B. CREATE INDEX
C. CREATE SYNONYM
D. UPDATE STATISTICS
Which of the following statement is correct about Shared Disk (SD) secondary servers?
A. SD secondary servers support automatic index repair
B. SD secondary servers use paging files to track pages between checkpoints
C. SD secondary servers require an HDR secondary server to be present in order to function
D. SD secondary servers can become a High-Availability Data Replication (HDR) secondary server