IBM C2090-556 - Informix 11.50 Application Developer Exam
Page: 3 / 23
Total 115 questions
Question #11 (Topic: Topic 1)
A user has opened two sessions, SESSION_1 and SESSION_2, connecting to the same
database containing a table named customer.
The following query is executed first from SESSION_1 and then from SESSION_2 (without
closing SESSION_1):
SELECT * FROM customer INTO TEMP cust_temp
What is the outcome in SESSION_2?
database containing a table named customer.
The following query is executed first from SESSION_1 and then from SESSION_2 (without
closing SESSION_1):
SELECT * FROM customer INTO TEMP cust_temp
What is the outcome in SESSION_2?
A. A locking error.
B. SELECT query will wait till SESSION_1 has ended.
C. Error indicating Temp table (cust_temp) already exists.
D. All rows from customer table will be retrieved into cust_temp table.
Answer: D
Question #12 (Topic: Topic 1)
Which of the following may NOT be done with Informix SPL functions?
A. Execute dynamic SQL inside the function.
B. Declare two functions with the same name.
C. SQL Optimizer directives inside stored procedures.
D. Used as a function in the create index statement.
Answer: D
Question #13 (Topic: Topic 1)
Which two statements will search text data stored in the column brands of the table
products for the string century? (Choose two.)
products for the string century? (Choose two.)
A. SELECT id FROM products WHERE brands = 'century';
B. SELECT id FROM products WHERE brands LIKE '*century*';
C. SELECT id FROM products WHERE brands MATCHES '*century*';
D. SELECT id FROM products WHERE bts_exists(brands, 'century');
E. SELECT id FROM products WHERE bts_contains(brands, 'century');
Answer: C,E
Question #14 (Topic: Topic 1)
Which two values can be used for connection type field from sqlhosts file when using
Distributed Relational Database Architecture (DRDA) protocol? (Choose two.)
Distributed Relational Database Architecture (DRDA) protocol? (Choose two.)
A. ontlitcp
B. onipcshm
C. onsoctcp
D. drtlitcp
E. drsoctcp
Answer: D,E
Question #15 (Topic: Topic 1)
Which of the following data types can be used for values in a sequence?
A. SMALLINT, INTEGER or DECIMAL
B. CLOB and BLOB
C. SERIAL8
D. INTERVAL
Answer: C
