Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2090-558
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-558.html

Informix 11.70 Fundamentals

Question No: 21 – (Topic 1)

Which two products can be used by client applications to connect to Informix instances? (Choose two.)

  1. IBM Global Connect

  2. IBM Informix Connect

  3. IBM Informix JDBC Driver

  4. IBM Informix Office Manager

  5. IBM Informix Universal Driver Kit

Answer: B,C

Question No: 22 – (Topic 1)

Which authentication functionality allows you to implement different authentication mechanisms for different applications?

  1. Single Sign-On

  2. Secure Socket Layer

  3. Pluggable Authentication Modules

  4. Lightweight Directory Access Protocol

Answer: C

Question No: 23 – (Topic 1)

In what way is Enterprise Replication (ER) replication different from High-Availability

Cluster (HAC) replication?

  1. All data types are replicated.

  2. The data to be replicated is defined at an instance level of granularity.

  3. The data to be replicated can be defined at a column level of granularity.

  4. The data to be replicated can not include simple blobs stored in simple blobspaces.

Answer: C

Question No: 24 – (Topic 1)

Which of the following environment variables allow an application to specify formatting of locale-sensitive data such as of date and currency values?

  1. DB_LOCALE

  2. GLS_LOCALE

  3. CLIENT_LOCALE

  4. SERVER_LOCALE

Answer: C

Question No: 25 – (Topic 1)

When storing string quot;ABCDquot; in a column, which of the following data types will result in a string stored with 2 padded spaces?

  1. VARCHAR (6)

  2. VARCHAR (4,2)

  3. VARCHAR (8,6)

  4. VARCHAR (6,8)

Answer: C

Question No: 26 – (Topic 1)

Which command would you execute to restore to a specific moment-in-time?

  1. onbar -t timestamp

  2. onbar -r -log lognum

  3. onbar -r -t timestamp

  4. onbar -r -l timestamp

Answer: C

Question No: 27 – (Topic 1)

Given the query shown below:

Ensurepass 2018 PDF and VCE

What will happen?

  1. All rows will be retrieved in which item_desc contains the characters #39;pencil#39;.

  2. All rows will be retrieved in which item_desc does not contain the characters #39;pencil#39;.

  3. All rows will be retrieved in which item_desc contains the letters #39;p#39;, #39;e#39;, #39;n#39;, #39;c#39;, #39;i#39; and #39;l#39; in any order.

  4. All rows will be retrieved in which item_desc contains the letters quot;P#39;, #39;E#39;, #39;N, C#39;, I#39; and #39;L#39; in any order.

Answer: A

Question No: 28 – (Topic 1)

Business rules require that every time a row in table A is updated in your OLTP database, a row in table B must also be updated. How can you guarantee this rule will be maintained correctly and consistently when there are multiple applications and developers?

  1. Use a trigger.

  2. Create a foreign key.

  3. Use a nightly batch process.

  4. Define a task in the sysadmin database.

Answer: A

Question No: 29 – (Topic 1)

Which of the following is true about system catalog tables access?

  1. Only user informix can read system catalog tables

  2. Only system administrators can read system catalog tables

  3. Only database administrators can read system catalog tables

  4. Any user that can connect to the database can read system catalog tables

Answer: D

Question No: 30 – (Topic 1)

Click the Exhibit button.

Ensurepass 2018 PDF and VCE

The query.sql file contains the information shown in the exhibit. The following command is run: dbaccess ?query.sql How many rows will be returned by the select query?

  1. 1

  2. 2

  3. 3

  4. 4

Answer: B

100% Ensurepass Free Download!
Download Free Demo:C2090-558 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-558 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.