Informix 11.50 Application Developer v5.0 (C2090-556)

Page:    1 / 8   
Total 122 questions

What result will be returned for User B in the attached exhibit?

  • A. A "row locked" error.
  • B. An account_balance of 80.
  • C. An account_balance of 90.
  • D. An account_balance of either 80 or 90 depending on when buffers were last flushed to disk.


Answer : A

Which two built-in data types store purely numeric integral values between -(2 63 -1) and 2
63 -1? (Choose two.)

  • A. INT8
  • B. FLOAT
  • C. BIGINT
  • D. LONG
  • E. SMALLINT


Answer : A,C

What statement describes the logging restriction that applies to distributed queries?

  • A. Participating databases must be ANSI-compliant.
  • B. Participating databases must have buffered logging.
  • C. Participating databases must have unbuffered logging.
  • D. Participating database must have identical transaction logging types.


Answer : D

Where are the UNION and UNION ALL operators in subqueries supported?

  • A. In the definition of a view.
  • B. In the event or in the action clause of a trigger.
  • C. In the FOR UPDATE clause or in an Update cursor.
  • D. In SELECT statements within the WHERE clause.


Answer : D

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

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


Answer : C

Which IBM Informix .NET Provider statement is NOT true?

  • A. It works only with Informix.
  • B. It uses the SQLI protocol to communicate with Informix.
  • C. It uses the DRDA protocol to communicate with Informix.
  • D. Its Connection Lifetime attribute specifies how long a connection can remain open.


Answer : C

Which statement is NOT a characteristic of a sequence?

  • A. It specifies a negative value.
  • B. It specifies an initial value.
  • C. Rolling back a generated value is not allowed.
  • D. It has a lower level of concurrency than a serial column.


Answer : D

Which statement about functional indexes is true?

  • A. A functional index uses a special index structure called a R-tree index.
  • B. The return values of a function is pre-computed and used to build an index.
  • C. The ONLINE keyword is only allowed with the CREATE INDEX and DROP INDEX statements.
  • D. The return values of a function cannot be a compressed version of the original columns or some calculation based on them.


Answer : B

Given the following SQL statements:


What is the result of the following query?
SELECT user, current, today FROM mytab;

  • A. josh, 11:30:30, 1/22/2008
  • B. The current user name, the current time and the current date.
  • C. The query will fail because user, current and today are built-in functions.
  • D. The information would be the same as DBINFO(utc_user, utc_current, utc_today).


Answer : B

Which statement about Dirty Read (Read Uncommited) isolation levels is correct?

  • A. It prevents the phantom read phenomenon.
  • B. It does not check whether there is any lock on the required rows.
  • C. It places a shared lock on the row that is being read and releases it when the next row is locked.
  • D. It does not place a lock on the row that it is reading, but does check if any lock is placed on them.


Answer : B

What isolation level allows other users to change rows in your result set, but not the current row you are examining?

  • A. Dirty Read
  • B. Committed Read
  • C. Repeatable Read
  • D. Cursor Stability


Answer : D

When using the MQ Datablade Module, which interface binds tables to Websphere MQ queues, creating transparent access to WMQ objects and enabling users to access the queue as if it were a table?

  • A. SQL Extensions
  • B. External Tables
  • C. Datablade API
  • D. Virtual Tables


Answer : D

Which Stored Procedure Language (SPL) statement is used to write debugging information to a file?

  • A. TRACE
  • B. RAISE EXCEPTION
  • C. DEBUG_FILE
  • D. LOG


Answer : A

Which of the following is NOT a legal value for the BOOLEAN data type?

  • A. 'T' for true, and 'F' for false.
  • B. NULL value.
  • C. 't' for true, and 'f' for false.
  • D. 1 for true, and 0 for false.


Answer : D

Which statement combines the actions of the PREPARE, EXECUTE, and FREE statements into a single operation to process most SQL statements?

  • A. EXECUTE NOW
  • B. EXECUTE IMMEDIATE
  • C. EXECUTE DYNAMIC
  • D. EXEC SQL


Answer : B

Page:    1 / 8   
Total 122 questions