[2026] IBM Informix 11.50 Application Developer

문제1

Table stock with columns stock_num, manu_code and price has following four rows in it

A. 2

B. 6

C. 3

D. 4

정답: D

문제2

Which data type's internal structure is inaccessible to the database server?

A. Opaque

B. SET

C. ROW Unnamed

D. ROW Named

정답: A

문제3

Which statement about casting is correct?

A. In most cases, you can explicitly cast a named row type to built-in data types without creating the cast.

B. When you create a distinct data type, the database server automatically registers explicit casts from the distinct data type to the source data type and from the source data type to the distinct data type.

C. You don't need create casts on distinct types to handle conversions between the new distinct data type and other data types in the database, the server takes care of that automatically.

D. When you create an opaque data type, the server automatically define template casts to handle conversions between the internal and external representations of the opaque data type.

정답: B

문제4

What are all the possible table level privileges granted to user John on table ACCOUNT after the following statement is executed?
GRANT ALL ON ACCOUNT TO JOHN;

A. SELECT, UPDATE, INSERT, DELETE, INDEX, REFERENCES, ALTER, UNDER

B. SELECT, UPDATE, INSERT, DELETE, INDEX, REFERENCES, ALTER, RENAME, DROP

C. SELECT, UPDATE, INSERT, DELETE, INDEX, REFERENCES, ALTER, RENAME

D. SELECT, UPDATE, INSERT, DELETE, INDEX, REFERENCES, ALTER, DROP

정답: A

문제5

Which statement about static SQL is true?

A. It is prepared at compile time.

B. It is typically used in an interactive program that composes SQL based on user inputs.

C. The data types of the columns do not have to be known at compile time.

D. It is prepared at runtime.

정답: A

문제6

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. REPEATABLE READ

B. DIRTY READ

C. COMMITTED READ

D. CURSOR STABILITY

정답: A

문제7

Pamela has decided to fragment a large table containing binary objects to optimize performance. Which of the following statements about data placement is NOT true?

A. Smart large objects can only be placed within a single sbspace.

B. It is possible to fragment a table within a single dbspace.

C. It is possible to fragment a table across multiple dbspaces.

D. Simple binary large objects can reside within the table or can be placed into only a single blobspace.

정답: A

문제8

Given the following SQL statements:

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

A. The query will fail because user, current and today are built-in functions.

B. The information would be the same as DBINFO(utc_user, utc_current, utc_today).

C. josh, 11:30:30, 1/22/2008

D. The current user name, the current time and the current date.

정답: D

IBM Informix 11.50 Application Developer - 000-556무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트