IBM C2090-619 Braindump 2021

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

• A. OPTOFC
• B. OPTMSG
• C. OPT_GOAL
• D. OPTCOMPIND

Answer: C

NEW QUESTION 2
Which statement is FALSE about dbspace configurable page sizes?

• A. Dbspace page size can only be set for non-critical dbspaces.
• B. Possible page sizes are multiples of the default page size up to 16 kb.
• C. Configure page sizes as close to the backup / restore and network buffer size as possible for efficient data transfer across the wire.
• D. Dbspace page size should be configured to accommodate the greatest number of average row sizes with a minimum of remainder pages being used.

Answer: C

NEW QUESTION 3
Which feature can be enabled in Informix?

• A. Automatic addition of a CPU VP.
• B. Automatic addition of an ADM VP.
• C. Automatic extension of storage spaces.
• D. Automatic addition of message log files.

Answer: C

NEW QUESTION 4
When executing the following command: execute function sysadmin task("table compress", "customer") what will happen to the customer table?

• A. Only newly added rows will be compressed.
• B. Only existing data will be compressed, new data will remain uncompressed.
• C. Row data and partition blobs will be compressed and any free table space will be released.
• D. Row data and partition blobs will be compressed and the space allocated to the table will remain.

Answer: C

NEW QUESTION 5
When you take a level 2 backup, what data is backed up?

• A. All new data since the last level 1 backup.
• B. All new data since the last level 2 backup.
• C. All logical logs which have not previously been backed up.
• D. All new data since the last level 0, level 1 or level 2 backup.

Answer: A

NEW QUESTION 6
When configuring Informix server for DRDA connection, which statement is true?

• A. The connection protocol must be drsoctcp.
• B. The database server name for DRDA connection must correspond to the DBSERVERNAME onconfig parameter.
• C. The database server name for DRDA connection must correspond to the DBSERVERALIASES onconfig parameter.
• D. The database server name should correspond to either the DBSERVERNAME or the DBSERVERALIASES onconfig parameter.

Answer: C

NEW QUESTION 7
Which is NOT a component of the IBM Mobile Database offering?

• A. IBM DB2
• B. IBM Informix
• C. IBM solidDB
• D. IBM InfoSphere Warehouse

Answer: D

NEW QUESTION 8
Which statement accurately describes the selective row-level auditing feature in Informix?

• A. Auditing can be configured so that row-level events of only selected views are recorded in the audit trail.
• B. Auditing can be configured so that row-level events of only selected tables are recorded in the audit trail.
• C. Auditing can be configured so that events of only selected rows within a table are recorded in the audit trail.
• D. Auditing can be configured so that row-level events of only selected partitions are recorded in the audit trail.

Answer: B

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

• A. The command defines a template to be realized on servers serv4 and serv5.
• B. The command defines a template to exclude database testdb from replication.
• C. The command defines a template to replicate the entire database testdb by defining replicates for each of the user defined tables in testdb.
• D. 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

NEW QUESTION 10
Which two parameters must be set to a valid value before starting a Shared Disk (SD) Secondary server? (Choose two.)

• A. SDS_PAGING
• B. SDS_TIMEOUT
• C. SDS_TEMPDBS
• D. SDS_LOGCHECK
• E. SDS_ALTERNATE

Answer: AC

NEW QUESTION 11
Which statement is FALSE regarding SBSPACES?

• A. They are recoverable.
• B. They do not obey transaction isolation modes.
• C. They have read, write, and seek properties similar to a standard UNIX file.
• D. Smart large objects within table rows are not required to be retrieved in one statement.

Answer: B

NEW QUESTION 12
What is the purpose of the ifx_getMartStat() function?

• A. To display status information about the data mart.
• B. To display update statistics information about the data mart and its tables.
• C. To display statistics about the workers and coordinators defined for the accelerator.
• D. To display status information about the Informix Warehouse Accelerator and all the data marts.

Answer: A

NEW QUESTION 13
An Enterprise Replication server is a primary server for shared-disk secondary servers. The DBA wants to reduce the replication latency by reducing the number of transactions that are applied before the logs are flushed to disk. What configuration parameter should the DBA modify?

• A. CDR_MAX_TXNS
• B. CDR_TSINSTANCEID
• C. CDR_MAX_FLUSH_SIZE
• D. CDR_LOG_LAG_ACTION

Answer: C

NEW QUESTION 14
Which threshold setting applies when configuring automatic memory management?

• A. SHMTOTAL
• B. BUFFERPOOL
• C. SHMVIRTSIZE
• D. DS_TOTAL_MEMORY

Answer: A

NEW QUESTION 15
Which statement is FALSE?

• A. A new index can be created compressed.
• B. Attached indexes cannot be compressed.
• C. A compressed index can be uncompressed.
• D. A compressed index cannot be uncompressed.

Answer: C

NEW QUESTION 16
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?

• A. Mapped users
• B. Role based users
• C. Table level access for users
• D. Label based access for users

Answer: A

NEW QUESTION 17
Which Informix utility is used to print information about runtime statistics for all threads in the server?

• A. onstat -g sta
• B. onstat -g act
• C. onstat -g rea
• D. onstat -g cpu

Answer: D

NEW QUESTION 18
When using the deployment assistant, which two statements are true? (Choose two.)

• A. A java environment must be configured.
• B. The Informix user account must be used.
• C. Chunks can be raw devices or buffered files.
• D. The user must have connect permission to all databases.
• E. The user must have connect privilege to sysadmin database.

Answer: AE

NEW QUESTION 19
Which Informix utility can be used to customize the onconfig file?

• A. ifxdeploy
• B. genoncfg
• C. dbaccess
• D. onparams

Answer: B

NEW QUESTION 20
Which objects can be compressed?

• A. CLOBs
• B. smart BLOBs
• C. partition BLOBs
• D. blobspace BLOBs

Answer: C

NEW QUESTION 21
The 'onstat -k' output is showing '56 lock table overflows'. Which catalog table can be used to display the relevant lock statistics?

• A. syslocks
• B. systables
• C. sysprofile
• D. sysoverflow

Answer: C

NEW QUESTION 22
......