IBM C2090-619 Free Practice Questions

NEW QUESTION 1
Which objects can be compressed?

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

Answer: C

NEW QUESTION 2
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 3
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 4
The sector option for cdr utility is used to perform what operation?

• A. Dynamically convert ER cluster instances in order to perform rolling upgrades.
• B. Dynamically convert H/A cluster instances in order to perform rolling upgrades.
• C. Dynamically reconfigure Connection Manager SLAs for ER clusters in order to perform rolling upgrades.
• D. Dynamically reconfigure Connection Manager SLAs for H/A clusters in order to perform rolling upgrades.

Answer: B

NEW QUESTION 5
Which statement is true regarding default roles?

• A. The DBSA can define a default role to assign only to the PUBLIC group for a particular database.
• B. The privileges associated with a default role takes precedence over the privileges granted to an individual user.
• C. The DBSA can define a default role to assign to individual users or to the PUBLIC group for a particular database.
• D. When a user connects to a database, it is necessary to use the SET ROLE DEFAULT statement in order to gain the default role privileges.

Answer: C

NEW QUESTION 6
In addition to examining the Connection Manager log file, what are two ways to monitor the Connection Manager status? (Choose two.)

• A. onstat
• B. onmode
• C. oncmsm
• D. onmonitor
• E. OpenAdmin Tool

Answer: AE

NEW QUESTION 7
In which table can you find a history of all SQL Administration API functions executed in the last 30 days?

• A. sysadmin:admin_history
• B. sysmaster:admin_history
• C. sysadmin:command_history
• D. sysmaster:command_history

Answer: C

NEW QUESTION 8
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 9
The DBA has defined the following configuration parameters in the onconfig file:

What are the actual values for LMM START THRESHOLD and LMM STOP THRESHOLD computed internally by the database server?

• A. LMM START THRESHOLD = 2MB and LMM STOP THRESHOLD = 3MB
• B. LMM START THRESHOLD = 20MB and LMM STOP THRESHOLD = 30MB
• C. LMM START THRESHOLD = 500MB and LMM STOP THRESHOLD = 333MB
• D. LMM START THRESHOLD = 2% and LMM STOP THRESHOLD = 3% of physicalmemory in the system

Answer: B

NEW QUESTION 10
The DBA updated the uto_crsd?Scheduler task in the SYSADMIN database with the following SQL commands:The DBA updated the ?uto_crsd?Scheduler task in the SYSADMIN database with the following SQL commands: UPDATE ph_task SET tk_enable
= ?WHERE tk_name = uto_crsd?UPDATE ph_task SET tk_enable = ??WHERE tk_name =
?uto_crsd? UPDATE ph_threshold SET value = ?WHERE name = UTODEFRAG_ENABLED?UPDATE ph_threshold SET value = ??WHERE name =
?UTODEFRAG_ENABLED? UPDATE ph_threshold SET value = ?000?WHERE name = UTOCOMPRESS_ROWS?UPDATE ph_threshold SET value = ?000?WHERE name =
?UTOCOMPRESS_ROWS? What will be the effect of auto_crsd database scheduler task on the tables?

• A. Compress all tables with less than 5000 rows.
• B. Compress and defragment tables with more than 5000 uncompressed rows.
• C. Compress, repack and shrink tables with more than 5000 uncompressed rows.
• D. Do not compress, repack, shrink and defragment any table with more than 5000 rows.

Answer: C

NEW QUESTION 11
Which statement is FALSE about Informix Automatic checkpoint Feature?

• A. Automatic checkpoints cause less logical log activity.
• B. Automatic checkpoints try to avoid transaction blocking.
• C. Automatic checkpoints cause the database server to trigger more frequent checkpoints.
• D. Automatic checkpoints can be dynamically enabled or disabled by using onmode -wm or onmode -wf.

Answer: A

NEW QUESTION 12
Which configuration parameter can toggle the automatic expansion of storage spaces?

• A. SP_AUTOGROW
• B. SP_AUTO_SPACE
• C. SP_AUTOEXPAND
• D. SP_EXPAND_ENABLE

Answer: C

NEW QUESTION 13
Which option provides the greatest performance benefit in an Informix warehouse environment?

• A. Setting lower value of PDQPRIORITY.
• B. Increasing the number of B-Tree cleaners.
• C. Setting higher value of DS_TOTAL_MEMORY.
• D. Setting value of OPT_GOAL configuration variable to 0.

Answer: C

NEW QUESTION 14
Which two DataBlade extensions can be automatically registered? (Choose two.)

• A. Web DataBlade
• B. Spatial DataBlade
• C. TimeSeries DataBlade
• D. Excalibur Text DataBlade
• E. High Performance Loader DataBlade

Answer: BC

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

• A. sarah
• B. karin and dave
• C. karin and sarah
• D. karin, dave and sarah

Answer: A

NEW QUESTION 16
The IBM Mobile Database is a mobile-optimized version of which IBM product?

• A. IBM DB2
• B. IBM Informix
• C. IBM solidDB
• D. IBM Cloudscape

Answer: C

NEW QUESTION 17
Which is NOT a valid index fragmentation strategy?

• A. Fragment by Range
• B. Partition by Expression
• C. Fragment by Expression
• D. Fragment by Round Robin

Answer: D

NEW QUESTION 18
Which step must be performed to enable Secure Socket Layer (SSL) connections to Informix?

• A. Configure encrypt virtual processors in the ONCONFIG file.
• B. Configure poll threads for SSL connections in the ONCONFIG file.
• C. Specify the SSL connection protocol in the sqlhosts file or registry entry.
• D. Specify the name of the label of the server digital certificate in the ONCONFIG file.

Answer: C

NEW QUESTION 19
What security role is required for you to create trusted-context objects?

• A. AAO
• B. DBSA
• C. DBSSO
• D. DBSECADM

Answer: D

NEW QUESTION 20
Which of configuration parameter can be increased to improve the performance of flushing dirty buffer pages during checkpoints?

• A. CKPTINTVL
• B. RA_PAGES
• C. CLEANERS
• D. SHMVIRTSIZE

Answer: C

NEW QUESTION 21
Which two actions can you perform with ontape? (Choose two.)

• A. Backup to cloud
• B. Restartable restore
• C. Backup specific storage spaces
• D. Restore specific storage spaces
• E. Parallel backup of storage spaces

Answer: AD

NEW QUESTION 22
Which value of DRINTERVAL should be used for HDR_TXN_SCOPE configuration parameter to take effect?

• A. -1
• B. 1
• C. 30

Answer: B

NEW QUESTION 23
The following message is received: Lock table overflow - user id user32, session id 54. What action should be taken to prevent this problem in the future?

• A. Run onclean utility to clear the lock table.
• B. Increase the LOCKS configuration parameter.
• C. Turn on the AUTO_TUNE configuration parameter.
• D. Change the DEF_TABLE_LOCKMODE configuration parameter from page to row.

Answer: B

NEW QUESTION 24
......