Online Access Free 000-556 Practice Test

You wish to show a user a total balance across all of their savings and checking accounts. However, you do not want them to be blocked or to see inconsistent information if money is being transferred between their accounts at the time of the query. What isolation level would you use?

• A.COMMITTED READ LAST COMMITTED
• B.CURSOR STABILITY LAST COMMITTED
• C.REPEATABLE READ
• D.READ COMMITTED

What are the default privileges when a table is created by the user?

• A.No access if NODEFDAC is zero.
• B.Select, Insert, Update, Delete and Execute.
• C.Select, Insert, Update and Delete.
• D.Select and Execute.

What does the TRACE PROCEDURE statement do when debugging stored procedures?

• A.Traces the routine calls and return values, but not the body of the stored procedure.
• B.Traces the routine calls and return values, automatically setting the debug file to the name of the stored procedure.
• C.Activates the TRACE statements embedded in the stored procedure.
• D.Traces the routine calls and return values, and every parsed statement in the stored procedure.

Which of the following data types can be directly cast to a DATE type?

• A.SMALLINT
• B.SMALLFLOAT
• C.DATETIME
• D.DECIMAL

Which Informix Datablade provides an infrastructure for distributed, asynchronous communication of data in a distributed, heterogeneous environment?

• A.Node Datablade
• B.MQ Datablade
• C.Binary Datablade
• D.Basic Text Search Datablade