Download IBM.C2090-558.Pass4Sure.2018-12-12.67q.tqb
| Vendor: | IBM |
| Exam Code: | C2090-558 |
| Exam Name: | Informix 11.70 Fundamentals |
| Date: | Dec 12, 2018 |
| File Size: | 390 KB |
Demo Questions
Question 1
Why would you want to create a table with a lock mode row as opposed to a lock mode page?
- to reduce disk I/O
- to keep more information in memory for each locked row
- to increase concurrency among multiple users on the same table
- to reduce the number of locks when accessing rows out of the table
Correct answer: C
Question 2
Which isolation level is appropriate if you do not want your query to place any locks?
- Dirty Read
- Cursor Stability
- Committed Read
- Repeatable Read
Correct answer: A
Question 3
Which of the following is true about system catalog tables access?
- Only user informix can read system catalog tables
- Only system administrators can read system catalog tables
- Only database administrators can read system catalog tables
- Any user that can connect to the database can read system catalog tables
Correct answer: D
