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

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: 11 – (Topic 1)

A user has opened two sessions, SESSION_1 and SESSION_2, connecting to the same database containing a table named customer.

The following query is executed first from SESSION_1 and then from SESSION_2 (without closing SESSION_1):

SELECT * FROM customer INTO TEMP cust_temp What is the outcome in SESSION_2?

  1. A locking error.

  2. SELECT query will wait till SESSION_1 has ended.

  3. Error indicating Temp table (cust_temp) already exists.

  4. All rows from customer table will be retrieved into cust_temp table.

Answer: D

Question No: 12 – (Topic 1)

Which of the following may NOT be done with Informix SPL functions?

  1. Execute dynamic SQL inside the function.

  2. Declare two functions with the same name.

  3. SQL Optimizer directives inside stored procedures.

  4. Used as a function in the create index statement.

Answer: D

Question No: 13 – (Topic 1)

Which two statements will search text data stored in the column brands of the table products for the string century? (Choose two.)

  1. SELECT id FROM products WHERE brands = #39;century#39;;

  2. SELECT id FROM products WHERE brands LIKE #39;*century*#39;;

  3. SELECT id FROM products WHERE brands MATCHES #39;*century*#39;;

  4. SELECT id FROM products WHERE bts_exists(brands, #39;century#39;);

  5. SELECT id FROM products WHERE bts_contains(brands, #39;century#39;);

Answer: C,E

Question No: 14 – (Topic 1)

Which two values can be used for connection type field from sqlhosts file when using Distributed Relational Database Architecture (DRDA) protocol? (Choose two.)

  1. ontlitcp

  2. onipcshm

  3. onsoctcp

  4. drtlitcp

  5. drsoctcp

Answer: D,E

Question No: 15 – (Topic 1)

Which of the following data types can be used for values in a sequence?

  1. SMALLINT, INTEGER or DECIMAL

  2. CLOB and BLOB

  3. SERIAL8

  4. INTERVAL

Answer: C

Question No: 16 – (Topic 1)

Which statement describes the distributed query capabilities of Informix?

  1. Queries can span a maximum of six (6) Informix databases on multiple host servers.

  2. Queries can span an unlimited number of Informix databases on multiple host servers.

  3. Queries can span a maximum of six (6) Informix databases on a single host server only.

  4. Queries can span an unlimited number of Informix databases on a single host server.

Answer: B

Question No: 17 – (Topic 1)

Consider the following code:

Ensurepass 2017 PDF and VCE

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

  1. Action A

  2. Action B

  3. Action C

  4. Action C followed by Action A

  5. Action A followed by Action C

Answer: C

Question No: 18 – (Topic 1)

When user quot;ABCquot; attempts to use a view, the database server tests for which of the

following privileges?

  1. The privileges granted to quot;ABCquot; for the view and the underlying tables.

  2. The privileges granted to quot;ABCquot; for the view and not the underlying tables.

  3. The privileges granted to quot;ABCquot; to access the underlying tables and not the view.

  4. The privileges not granted to quot;ABCquot; for the view and the underlying tables.

Answer: B

Question No: 19 – (Topic 1)

Which of the following statements about indexes is NOT true?

  1. It is possible to create an index based on the output of a VARIANT function.

  2. It is possible to create an index with a different ordering than the default one.

  3. It is possible to create an index with a different access method than the default one.

  4. It is possible to create an index with a different fragmentation strategy than the table it is based upon.

Answer: A

Question No: 20 – (Topic 1)

Given the SQL statement below:

Ensurepass 2017 PDF and VCE

Which option defines ABS?

  1. SPL Routine

  2. User Defined Type

  3. Trigger

  4. Built-in function

Answer: D

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