Exam Code: C2090-558 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Informix 11.70 Fundamentals (C2090-558)
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-558 Exam.
2021 May C2090-558 Study Guide Questions:
Q1. Which Informix data movement utilities listed below can be used to move database from a computer running Windows operating system to an Apple computer?
A. ontape
B. onunload and onload
C. ifxsend and ifxreceive
D. dbexport and dbimport
Answer: D
Q2. Informix is currently in online mode. As a DataBase System Administrator (DBSA), you switch to administration mode with ADMIN_USER_MODE_WITH_DBSA = 0. Who can access Informix databases?
A. only Informix
B. only a DBSA
C. only Informix or a DBSA
D. only root, Informix or a DBSA
Answer: C
Q3. 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
Answer: B
Update C2090-558 question:
Q4. Which of the following statements can be used to prevent duplicate values in an indexed column?
A. CREATE HASH INDEX
B. CREATE UNIQUE INDEX
C. CREATE DISTINCT TYPE
D. CREATE CLUSTER INDEX
Answer: B
Q5. 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.
Answer: D
Q6. You want to use sqlhosts file /newlocation/newsqlhosts. Which of the following is true?
A. sqlhosts file must be called sqlhosts
B. set INFORMIXSQLHOSTS variable to /newlocation/sqlhosts
C. set INFORMIXSQLHOSTS variable to /newlocation/newsqlhosts
D. sqlhosts file must be defined under $INFORMIXDIR/etc/ directory
Answer: C
Tested C2090-558 tutorials:
Q7. Which Informix utility listed below will allow an administrator to run ad hoc SQL against the instance?
A. onsql
B. onadmin
C. dbaccess
D. dbschema
Answer: C
Q8. 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 optimize a backup strategy to recover the client table in case of a failure?
A. a level-1 backup at 6:00 AM everyday
B. a level-0 backup soon after the load operation
C. a level-1 backup on Sunday and continuous log backup
D. a level-2 backup at 6:00 AM every day and continuous log backup
Answer: B
Q9. What are two system level databases? (Choose two.)
A. sysperf
B. sysadmin
C. sysmaster
D. sysmonitor
E. sysscheduler
Answer: B,C
Q10. Which of the following modes is NOT supported by Informix?
A. On-Line
B. Quiescent
C. Replication
D. Administration
Answer: C