IBM C2090-558 Exam Questions

Question 6 of 120

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 7 of 120

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 8 of 120

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

Question 9 of 120

How can you determine which databases are created in an instance?

use dbschema utility

inspect ONCONFIG file

List reserved pages with oncheck -pr

run SELECT name FROM sysmaster:sysdatabases

Correct Answer: D

Question 10 of 120

You want to use sqlhosts file /newlocation/newsqlhosts. Which of the following is true?

sqlhosts file must be called sqlhosts

set INFORMIXSQLHOSTS variable to /newlocation/sqlhosts

set INFORMIXSQLHOSTS variable to /newlocation/newsqlhosts

sqlhosts file must be defined under $INFORMIXDIR/etc/ directory

Correct Answer: C