Free IBM 000-556 Exam Dumps Questions & Answers

How is the DBINFO function used in the SQL statement below?
SELECT FIRST 1 DBINFO('sessionid') FROM systables;

• A.The DBINFO function sets the session id.
• B.The DBINFO function is a wrapper to the systables table.
• C.The DBINFO function creates a new session.
• D.The DBINFO function returns the current session id.

Which SQL statement is used in an Informix ESQL/C application to return diagnostic information about the most recently executed SQL statement?

• A.UPDATE STATISTICS
• B.DESCRIBE
• C.GET DESCRIPTOR
• D.GET DIAGNOSTICS

What occurs when the following statement is issued?
SET DEBUG FILE TO "eric";

• A.A file called eric.debug will be created in INFORMIXDEBUG if they are connected to a local database
• B.A file called eric.debug will be create in users home directory if they are connected to a remote database.
• C.A file called eric will be created in the users current directory if they are connected to a local database.
• D.A file called eric will be created in INFORMIXDIR if they are connected to a remote database.

In an ANSI compliant database, what value of SQLCODE indicates a successful query that returned no rows?

• A.-201
• B.-330
• C.100
• D.-1

When an cursor is created with the FOR UPDATE syntax, which type of lock is the result?

• A.implicit lock
• B.shared lock
• C.exclusive lock
• D.promotable lock