Informix 11.50 Application Developer (000-556) Free Practice Test

Question 1

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

A. Select, Insert, Update, Delete and Execute.

B. Select and Execute.

C. No access if NODEFDAC is zero.

D. Select, Insert, Update and Delete.

Correct Answer: D

Question 2

What is an Informix database trigger?

A. An automatically executed set of SQL statements when a specific activation event occurs.

B. A way of rejecting unwanted database connections.

C. An automatic event created by the database scheduling system to notify the DBA about a problem.

D. A security event used by Informix auditing to warn the DBA of unwanted actions.

Correct Answer: A

Question 3

A function written in the Informix SPL may NOT return which of the following?

A. No value.

B. Multiple column values within a single call.

C. A NULL value.

D. A simple large object reference (byte or text column type).

Correct Answer: A

Question 4

A user opens a transaction. In that transaction, a cursor is opened to fetch multiple rows for read access. Another transaction is opened and that connection attempts to modify some rows that the first transaction is examining. Which isolation level will ensure that the rows the first transaction examines remain the same?

A. CURSOR STABILITY

B. REPEATABLE READ

C. COMMITTED READ

D. DIRTY READ

Correct Answer: B

Question 5

What does the UNION operator do?

A. The same as the UNION ALL operator.

B. Combine two regular tables into one.

C. Combine two result sets, eliminating duplicates.

D. Combine two columns into one, eliminating duplicates.

Correct Answer: C

Question 6

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. Datablade API

B. External Tables

C. SQL Extensions

D. Virtual Tables

Correct Answer: D

Question 7

To register a new user-defined access method called my_tree for a virtual index, which of the following SQL statements must be used?

A. CREATE SECONDARY ACCESS_METHOD my_tree

B. CREATE VIRTUAL INDEX ACCESS_METHOD my_tree

C. CREATE VIRTUAL TABLE ACCESS_METHOD my_tree

D. CREATE PRIMARY ACCESS_METHOD my_tree

Correct Answer: A

Question 8

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

A. 100

B. -201

C. -330

D. -1

Correct Answer: A

Question 9

To register a routine in the database, an authorized user wraps the SPL commands in a CREATE FUNCTION or CREATE PROCEDURE statement. The database server stores a registered SPL routine internally. Which two of the following can register a new routine in the database? (Choose two.)

A. Any user with DBA privileges.

B. Any user in the DBA group.

C. The user informix.

D. Any user in the DBSECADM group.

E. All users.

Correct Answer: A,C

Welcome to TestSimulate

IBM Informix 11.50 Application Developer (000-556) Free Practice Test