File Info
| Exam | Informix 11.70 Fundamentals |
| Number | C2090-558 |
| File Name | IBM.C2090-558.Pass4Sure.2018-12-12.67q.tqb |
| Size | 390 KB |
| Posted | Dec 12, 2018 |
| Download | IBM.C2090-558.Pass4Sure.2018-12-12.67q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
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
