[Free] 2017(Nov) EnsurePass Passguide IBM C2090-556 Dumps with VCE and PDF 1-10

EnsurePass
2017 Nov IBM Official New Released C2090-556
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-556.html

Informix 11.50 Application Developer

Question No: 1 – (Topic 1)

When an cursor is created with the FOR UPDATE syntax, which type of lock is the result?

  1. exclusive lock

  2. shared lock

  3. promotable lock

  4. implicit lock

Answer: C

Question No: 2 – (Topic 1)

For what is the DBINFO function below used? DBINFO(#39;sqlca.sqlerrd2#39;)

  1. Returns the last SQL error code.

  2. Returns the last serial number inserted.

  3. Returns the number of rows processed.

  4. Returns the last ISAM error code.

Answer: C

Question No: 3 – (Topic 1)

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

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

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

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

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

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

Answer: C,D

Question No: 4 – (Topic 1)

Which Informix Datablade provides an infrastructure for distributed, asynchronous communication of data in a distributed, heterogeneous environment?

  1. MQ Datablade

  2. Node Datablade

  3. Binary Datablade

  4. Basic Text Search Datablade

Answer: A

Question No: 5 – (Topic 1)

What is the SQL statement cache used for?

  1. To cache static SQL statements.

  2. To cache dynamic SQL statements across sessions.

  3. To cache all SQL statements for tracing purposes.

  4. To provide a history of SQL statements to the application.

Answer: B

Question No: 6 – (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?

  1. CREATE PRIMARY ACCESS_METHOD my_tree

  2. CREATE SECONDARY ACCESS_METHOD my_tree

  3. CREATE VIRTUAL TABLE ACCESS_METHOD my_tree

  4. CREATE VIRTUAL INDEX ACCESS_METHOD my_tree

Answer: B

Question No: 7 – (Topic 1)

What are user created temporary tables used for?

  1. To persistently write temporary data to disk.

  2. To share result sets across multiple sessions.

  3. To access a temporary result set within one session.

  4. To automatically delete data based on a time policy.

Answer: C

Question No: 8 – (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?

  1. OF TYPE

  2. NOT NULL

  3. CHECK (IS NOT NULL)

  4. It is not possible to ensure that a BYTE column is populated.

Answer: C

Question No: 9 – (Topic 1)

Which temporary table statement is NOT true?

  1. The table can use multiple dbspaces.

  2. The table can have fragmented indexes.

  3. Temporary tables are visible to all users.

  4. The table exists until the database is closed.

Answer: C

Question No: 10 – (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

100% Free Download!
Download Free Demo:C2090-556 Demo PDF
100% Pass Guaranteed!
Download 2017 EnsurePass C2090-556 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE

Leave a Reply