Abreast Of The Times C2090-619 Bundle 2021

NEW QUESTION 1
Given the following statement: UPDATE STATISTICS LOW FOR TABLE customer (customer_num); Which catalog table data is NOT updated?

• A. sysdistrib
• B. systables
• C. sysindexes
• D. syscolumns

Answer: A

NEW QUESTION 2
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 3
Which objects can be compressed?

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

Answer: C

NEW QUESTION 4
The DBA wants to define a replicate as follows:

Which condition must be true for the command to execute successfully?

• A. The table table1 should have col1 as its primary key.
• B. The table table1 should have CRCOLS shadow columns.
• C. The table table1 should have a constraint on column col1.
• D. The table table1 should have an unique index on column col2.

Answer: D

NEW QUESTION 5
Which HDR configuration parameter provides three synchronization modes to control when transaction commits are returned to client applications?

• A. DELAY_APPLY
• B. HDR_TXN_SCOPE
• C. LOG_INDEX_BUILDS
• D. FAILOVER_TX_TIMEOUT

Answer: B

NEW QUESTION 6
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 7
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 8
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 9
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 10
Which two statements are true? (Choose two.)

• A. Logical log files must always reside in rootdbs.
• B. Having too little log space does not affect performance.
• C. Having too much log space does not affect performance.
• D. Simple large objects in blobspaces are not logged and they are included in the log backup in which the object was created.
• E. Simple large objects in blobspaces are not logged and they are not included in the log backup in which the object was created.

Answer: CD

NEW QUESTION 11
You need to create a new role for users on stores database. Which system catalog table can be checked to ensure the uniqueness of the new role name?

• A. stores:sysusers
• B. sysmaster:sysroles
• C. sysuser:sysroleauth
• D. sysmaster:sysusers

Answer: A

NEW QUESTION 12
Which OpenAdmin Tool feature is used to analyze the state of the Informix database server and can alert the DBA through email?

• A. SQL Toolbox
• B. Health Advisor
• C. Server Administration
• D. Performance Analysis

Answer: B

NEW QUESTION 13
Given an OLTP environment with a very large table, which configuration parameter can be set to allocate more memory for sorting when building an index on the large table?

• A. DBUPSPACE
• B. DS_POOLSIZE
• C. VP_MEMORY_CACHE_KB
• D. DS_NONPDQ_QUERY_MEM

Answer: D

NEW QUESTION 14
Which two tasks can be performed through an Informix Grid? (Choose two.)

• A. Install Informix products.
• B. Start Informix servers in a grid.
• C. Copy external files to grid servers.
• D. Setup replication automatically in a grid.
• E. Modify replication server attributes for grid servers.

Answer: CD

NEW QUESTION 15
Which operation can benefit from PDQ?

• A. Checkpoints
• B. Data replication
• C. DML Statement
• D. Login Log flushing

Answer: C

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

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

Answer: D

NEW QUESTION 17
Which two logging modes are compatible between two databases participating in a distributed query? (Choose two.)

• A. ANSI and non-ANSI
• B. Buffered and Unbuffered
• C. Buffered and Non-logging
• D. Non-logging and Unbuffered
• E. Non-logging and Non-logging

Answer: BE

NEW QUESTION 18
Which option is available through ifx_grid_connect()?

• A. Rename a replicated database.
• B. Enable use of TimeSeries columns in tables.
• C. Enable automatic creation of templates in a grid.
• D. Defer propagation of DDL statements to other servers in the grid.

Answer: D

NEW QUESTION 19
Which is NOT a valid option to improve service for connection requests under TCP/IP protocol?

• A. Adding sm_listen threads.
• B. Adding listener threads for additional ports.
• C. Dynamically increase the number of listener threads using onmode -P commands.
• D. Adding an additional network-interface card to service Informix connection requests.

Answer: A

NEW QUESTION 20
Which communication protocol needs additional configuration besides onconfig and sqlhosts?

• A. TLITCP
• B. IPCSTR
• C. IPCSHM
• D. SOCSSL

Answer: D

NEW QUESTION 21
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 22
Which configuration parameter should be set to enable asynchronous page requests when the database server detects that a query is waiting on I/O?

• A. DIRECT_IO
• B. DBUPSPACE
• C. AUTO_AIOVPS
• D. AUTO_READAHEAD

Answer: D

NEW QUESTION 23
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 24
......