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

Question 1

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

A. 4

B. 3

C. 6

D. 2

Correct Answer: A

Question 2

Which two statements are correct about privileges? (Choose two.)

A. RESOURCE privilege has all the capabilities of a CONNECT privilege.

B. A user would need RESOURCE privilege to run SET SESSION AUTHORIZATION statement.

C. A user with DBA privilege can alter, drop, or rename any database object.

D. Owner of a table can transfer ownership to another user.

E. User Informix can grant DBA privilege to a role.

Correct Answer: A,C

Question 3

Given the following program code: What is the minimum privilege required to successfully execute the program?

A. RESOURCE

B. DBA

C. CREATE

D. CONNECT

Correct Answer: A

Question 4

Which URL syntax is NOT used for DRDA communications?

A. jdbc:db2

B. jdbc:db2j:net

C. jdbc:informix

D. jdbc:ids

Correct Answer: C

Question 5

Which statement about static SQL is true?

A. It is prepared at compile time.

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

C. It is prepared at runtime.

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

Correct Answer: A

Question 6

Consider the following code:

What action is undertaken if Error -210 is encountered when executing the logic above?

A. Action A

B. Action C followed by Action A

C. Action B

D. Action C

E. Action A followed by Action C

Correct Answer: D

Welcome to TestSimulate