1.
Why would you want to create a table with a lock mode row as opposed to a lock mode page?
2.
Which isolation level is appropriate if you do not want your query to place any locks?
3.
Which of the following is true about system catalog tables access?
4.
How can you determine which databases are created in an instance?
5.
You want to use sqlhosts file /newlocation/newsqlhosts. Which of the following is true?
6.
Which utility can be used to relocate the physical log to a new dbspace?
7.
A progammer wants to unload a table to a file inside a stored procedure. What functionality listed below will help the programmer accomplish the task?
8.
Which Informix data movement utilities listed below can be used to move database from a computer running Windows operating system to an Apple computer?
9.
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?
10.
Which Informix utility listed below will allow an administrator to run ad hoc SQL against the instance?