IBM C2090-556 - Informix 11.50 Application Developer Exam
Page: 2 / 23
Total 115 questions
Question #6 (Topic: Topic 1)
To register a new user-defined access method called my_tree for a virtual index, which of
the following SQL statements must be used?
the following SQL statements must be used?
A. CREATE PRIMARY ACCESS_METHOD my_tree
B. CREATE SECONDARY ACCESS_METHOD my_tree
C. CREATE VIRTUAL TABLE ACCESS_METHOD my_tree
D. CREATE VIRTUAL INDEX ACCESS_METHOD my_tree
Answer: B
Question #7 (Topic: Topic 1)
What are user created temporary tables used for?
A. To persistently write temporary data to disk.
B. To share result sets across multiple sessions.
C. To access a temporary result set within one session.
D. To automatically delete data based on a time policy.
Answer: C
Question #8 (Topic: Topic 1)
William needs to create a table with a BYTE column which must be populated. Which of the
following CREATE TABLE clauses can be used to ensure that the BYTE column contains a
value?
following CREATE TABLE clauses can be used to ensure that the BYTE column contains a
value?
A. OF TYPE
B. NOT NULL
C. CHECK (IS NOT NULL)
D. It is not possible to ensure that a BYTE column is populated.
Answer: C
Question #9 (Topic: Topic 1)
Which temporary table statement is NOT true?
A. The table can use multiple dbspaces.
B. The table can have fragmented indexes.
C. Temporary tables are visible to all users.
D. The table exists until the database is closed.
Answer: C
Question #10 (Topic: Topic 1)
Given the attached exhibit, what value does Mary see for their savings account?
A. 0
B. 100
C. 200
D. -100
Answer: B
