It is impossible to pass IBM C2090-558 exam without any help in the short term. Come to Actualtests soon and find the most advanced, correct and guaranteed IBM C2090-558 practice questions. You will get a surprising result by our Replace Informix 11.70 Fundamentals (C2090-558) practice guides.


♥♥ 2021 NEW RECOMMEND ♥♥

Free VCE & PDF File for IBM C2090-558 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW C2090-558 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/C2090-558-exam-dumps.html

Q51. 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 correctly and consistently when there are multiple applications and developers? 

A. Use a trigger. 

B. Create a foreign key. 

C. Use a nightly batch process. 

D. Define a task in the sysadmin database. 

Answer: A 


Q52. Which command option should be used to resume an interrupted onbar restore? 

A. -RETRY 

B. -RESTART 

C. -REINTIIALZE 

D. -BEGIN_AGAIN 

Answer: B 


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

A. The keyword WORK is optional. 

B. A single COMMIT WORK can end several BEGIN WORK statements. 

C. The COMMIT WORK statement releases all row locks but not table locks. 

D. All of the successful modifications that the transaction makes are saved to disk when you issue a COMMIT WORK statement. 

E. A new transaction automatically starts after each COMMIT WORK or ROLLBACK WORK statement in a nonlogged database. 

Answer: A,D 


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


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

A. DROP FROM table_name ; 

B. DELETE FROM table_name ; 

C. DELETE * FROM table_name ; 

D. TRUNCATE TABLE table_name ; 

E. DELETE ALL FROM table_name ; 

Answer: B,D 


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


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


Q58. Why would you want to create a table with a lock mode row as opposed to a lock mode page? 

A. to reduce disk I/O 

B. to keep more information in memory for each locked row 

C. to increase concurrency among multiple users on the same table 

D. to reduce the number of locks when accessing rows out of the table 

Answer: C 


Q59. What functionality is exclusive to ontape (i.e. not present in onbar)? 

A. Level 1 Backup of instance 

B. Rename spaces during a restore 

C. Applying a filter to the backup data 

D. Back up the instance to standard out 

Answer: D 


Q60. Given the query shown below: 

What will happen? 

A. All rows will be retrieved in which item_desc contains the characters 'pencil'. 

B. All rows will be retrieved in which item_desc does not contain the characters 'pencil'. 

C. All rows will be retrieved in which item_desc contains the letters 'p', 'e', 'n', 'c', 'i' and 'l' in any order. 

D. All rows will be retrieved in which item_desc contains the letters "P', 'E', 'N, C', I' and 'L' in any order. 

Answer: A