Ensurepass.com : Ensure you pass the IT Exams
2018 Jan 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: 41 – (Topic 1)

Which Committed Read isolation level statement is correct?

  1. It locks all rows examined.

  2. It does not check for locks.

  3. It checks for locks after returning a row.

  4. It checks for locks before returning a row.

Answer: D

Question No: 42 – (Topic 1)

What Informix onconfig parameter is used to enable specific user level SQL tracing?

  1. SQLIDEBUG

  2. SQLTRACE

  3. SQL_XTRACE

  4. TRACE_SQL

Answer: B

Question No: 43 – (Topic 1)

How can you prevent concurrency problems when other users are modifying a nonlogging or raw table?

  1. Lock the table in exclusive mode for the whole transaction OR use repeatable read isolation level for the whole transaction.

  2. Lock the table in exclusive mode for the whole transaction OR use committed read isolation level for the whole transaction.

  3. Lock the table in shared mode for the whole transaction OR use repeatable read isolation level for the whole transaction.

  4. Lock the table in shared mode for the whole transaction OR use committed read isolation level for the whole transaction.

Answer: A

Question No: 44 – (Topic 1)

Which URL syntax is NOT used for DRDA communications?

  1. jdbc:ids

  2. jdbc:db2

  3. jdbc:informix

  4. jdbc:db2j:net

Answer: C

Question No: 45 – (Topic 1)

When using IBM Data Server Driver for JDBC to connect to Informix Server, which URL should be used when making a connection using Distributed Relational Database Architecture protocol?

  1. quot;jdbc:ids://hostname1:5021/storesdb:user=XXX;password=YYYquot;

  2. quot;jdbc:drda://hostname1:5021/storesdb:user=XXX;password=YYYquot;

  3. quot;jdbc:db2j:net://hostname1:5021/storesdb:user=XXX;password=YYYquot;

  4. quot;jdbc:informix- sqli://hostname1:5021/storesdb:INFORMIXSERVER=myserver;user=XXX;password=YYYquot;

Answer: A

Question No: 46 – (Topic 1)

The definition of the table quot;tab1quot; is:

create table tab1 (colA boolean, colB boolean); Which INSERT statement for the table is correct?

  1. insert into tab1 (colA, colB) values (1,0);

  2. insert into tab1 (colA, colB) values (#39;t#39;, NULL);

  3. insert into tab1 (colA, colB) values (#39;F#39;,#39;0#39;);

  4. insert into tab1 (colA, colB) values (t,f);

Answer: B

Question No: 47 – (Topic 1)

Which built-in function is supported by Informix Server?

  1. TOCHAR()

  2. FORMAT_UNITS()

  3. IFNULL()

  4. LASTDAY()

Answer: B

Question No: 48 – (Topic 1)

Given the following table structure and triggers:

Ensurepass 2018 PDF and VCE

In what order will the triggers fire if you execute the following statement? UPDATE item SET (itemno, stockcode) = (99, 9999999);

  1. You cannot predict the firing order.

  2. The triggers will fire simultaneously.

  3. Trigger itm_trg1 will fire first, as it includes the first column in the table.

  4. Trigger itm_trg2 will fire first, as it includes the first column out of those touched.

Answer: C

Question No: 49 – (Topic 1)

Which of the following data types is not based on built-in data types?

  1. Row types

  2. Opaque types

  3. Distinct types

  4. Named row types

Answer: B

Question No: 50 – (Topic 1)

Casts can be created for which two of the following? (Choose two.)

  1. Named row types

  2. Unnamed row types

  3. BLOB data types

  4. TEXT data types

  5. DISTINCT data types

Answer: A,E

100% Ensurepass Free Download!
Download Free Demo:C2090-556 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-556 Dumps

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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.