[Free] 2018(Jan) Dumps4cert Braindumps IBM C2090-919 Dumps with VCE and PDF Download 51-60

Dumps4cert.com : Latest Dumps with PDF and VCE Files 2018 Jan IBM Official New Released C2090-919
100% Free Download! 100% Pass Guaranteed!
http://www.Dumps4cert.com/C2090-919.html

Informix 11.70 System Administrator

Question No: 51 – (Topic 1)

Given the following:

Dumps4Cert 2018 PDF and VCE

  1. Update three rows.

  2. Update one row and insert two rows.

  3. Update two rows and insert one row.

  4. Return a 26095 error – Cannot update or delete a row twice in a MERGE statement.

Answer: C

Question No: 52 – (Topic 1)

Which connection type can be used for network connections?

  1. Sockets

  2. Named Pipes

  3. Stream Pipes

  4. Shared memory

Answer: A

Question No: 53 – (Topic 1)

Assuming you have a table with a replicate defined. A Flexible Grid procedure is executed changing data in that table. What statement about replication of the changes is true?

  1. The changes cannot be replicated.

  2. The changes are replicated by default.

  3. You have to call ifx_set_erstate( ) to replicate changes.

  4. Only changes to primary key columns can be replicated.

Answer: C

Question No: 54 – (Topic 1)

Which list fragmentation statement is true?

  1. It cannot be used for indexes.

  2. It allows overlapping fragments.

  3. It can only be used for numeric columns.

  4. It allows a fragment to be defined as a remainder.

Answer: D

Question No: 55 – (Topic 1)

Which Windows utility is used to configure the SQLHOSTS registry key?

  1. ilogin

  2. instmgr

  3. setnet32

  4. oncmsm

Answer: C

Question No: 56 – (Topic 1)

Which sbspaces statement is FALSE?

  1. Sbspaces may be recoverable.

  2. Sbspaces can be of varying page size.

  3. Sbspaces may be part of round robin fragmentation.

  4. Sbspaces have read, write and seek properties similar to UNIX functions.

Answer: B

Question No: 57 – (Topic 1)

Which role can create, alter, or delete trusted context objects?

  1. DBA

  2. DBSA

  3. DBSSO

  4. DBSECADM

Answer: D

Question No: 58 – (Topic 1)

Why do automatic checkpoints cause the database server to trigger more frequent checkpoints?

  1. To avoid LRU flushes.

  2. To ensure the buffer pool is always available.

  3. To ensure the onstat -g ckp report is accurate.

  4. To avoid transaction blocking during checkpoints.

Answer: D

Question No: 59 – (Topic 1)

Which statement about mapped user functionality is true?

  1. Mapped users cannot execute distributed operations.

  2. Mapped users are allowed to run with multiple names.

  3. The DBSA can control the access to tables at a row level using security labels.

  4. The DBSA can grant database server access to externally authenticated users with no local account.

Answer: D

Question No: 60 – (Topic 1)

For a given procedure name, what is the objective of the SQL query shown below?

Dumps4Cert 2018 PDF and VCE

  1. The query returns the ordered text form of the specified procedure body.

  2. The query returns the ordered compiled form of the specified procedure body.

  3. The query returns both ordered text and ordered compiled form of the specified procedure body.

  4. The query returns neither the ordered text nor the ordered compiled form of the specified procedure body.

Answer: A

100% Dumps4cert Free Download!
Download Free Demo:C2090-919 Demo PDF
100% Dumps4cert Free Guaranteed!
C2090-919 Dumps

Dumps4cert 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