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

IBM Informix 12.10 System Administrator

Question No: 41

Which configuration parameter can be set to quickly return rows to a user while a query continues processing?

  1. OPTOFC

  2. OPTMSG

  3. OPT_GOAL

  4. OPTCOMPIND

Answer: C

Question No: 42

After executing the following commands: onmode -j -U karin,dave onmode -j -U karin,sarah onmode -j -U sarah which user(s) have access to the instance?

  1. sarah

  2. karin and dave

  3. karin and sarah

  4. karin, dave and sarah

Answer: A

Question No: 43

Which statement is NOT true about a Storage Pool?

  1. You can create multiple storage pools per database server.

  2. You can add, modify, delete, and purge storage pool entries.

  3. Priorities can be used to determine space allocation order.

  4. It consists of any combination of a raw device, a cooked file, or a directory.

Answer: A

Question No: 44

Which command line utility does NOT have the equivalent functionality using the SQL Administration API?

  1. oninit

  2. onmode

  3. onspaces

  4. onparams

Answer: A

Question No: 45

The sector option for cdr utility is used to perform what operation?

  1. Dynamically convert ER cluster instances in order to perform rolling upgrades.

  2. Dynamically convert H/A cluster instances in order to perform rolling upgrades.

  3. Dynamically reconfigure Connection Manager SLAs for ER clusters in order to perform

    rolling upgrades.

  4. Dynamically reconfigure Connection Manager SLAs for H/A clusters in order to perform rolling upgrades.

Answer: B

Question No: 46

You are running an UPDATE statement on a table using dbaccess. What kind of lock type is expected?

  1. Byte

  2. Update

  3. Shared

  4. Exclusive

Answer: D

Question No: 47

What data migration tool(s) should be used to load data from a non-Informix data source?

  1. dbimport

  2. onload and dbload

  3. dbload and High Performance Loader

  4. onload and High Performance Loader

Answer: C

Question No: 48

What are two requirements for the quot;ifxclonequot; utility? (Choose two.)

  1. All databases must use logging.

  2. The source server must be a secondary server.

  3. Only one server clone process can occur at a time.

  4. Both the source and target servers must be part of a trusted network environment.

  5. Both the source and target servers must use the same type of disk space (raw or cooked).

Answer: C,D

Question No: 49

Consider the following Enterprise Replication command: cdr define template temp1 -c g_serv1 -C ignore -a -d testdb. Which statement is TRUE?

  1. The command defines a template to be realized on servers serv4 and serv5.

  2. The command defines a template to exclude database testdb from replication.

  3. The command defines a template to replicate the entire database testdb by defining replicates for each of the user defined tables in testdb.

  4. The command defines a template to replicate the entire database testdb by defining replicates for each of the views and system tables in

testdb.

Answer: C

Question No: 50

In an organization, all employees are authenticated via domain wide Kerberos single sign- on. The DBSA wants to provide access to the database server for an employee without requesting the Operating System (OS) administrator to create a OS level user account.

Which Informix feature does the DBSA need to leverage?

  1. Mapped users

  2. Role based users

  3. Table level access for users

  4. Label based access for users

Answer: A

100% Ensurepass Free Download!
Download Free Demo:C2090-619 V13 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass C2090-619 V13 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

2017 EnsurePass IT Certification PDF and VCE