C2090-619 | IBM C2090-619 Practice 2021

NEW QUESTION 1
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 2
What command unlocks the storage catalogs when using the Primary Storage Manager?

• A. onbar -d unlock
• B. onpsm -C unlock
• C. onmode -C unlock
• D. onsmsync -c unlock

Answer: B

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
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 5
What kinds of Table Level Restores can be done by the archecker utility?

• A. Only logical restore.
• B. Only physical restore.
• C. Only point in time restore.
• D. Physical, logical, and point in time restores.

Answer: D

NEW QUESTION 6
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 7
Which type of device does Primary Storage Manager support?

• A. File
• B. Tape
• C. Directory
• D. Named pipe

Answer: A

NEW QUESTION 8
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 9
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 10
How can you ensure to hold the an update lock until the end of a transaction when fetching rows from a cursor?

• A. Use the 'Committed Read' isolation level.
• B. Use the RETAIN UPDATE LOCKS clause with isolation level.
• C. Use the 'Cursor Stability' isolation level along the WITH HOLD clause.
• D. Use the SET TRANSACTION command to with SERIALIZABLE clause.

Answer: B

NEW QUESTION 11
Given the following:

How many locks will be used on tab1 to run the query?

• A. 1
• B. 2
• C. Depends on the number of index pages accessed

Answer: A

NEW QUESTION 12
An Informix server is configured with multiple CPU VPs and poll threads and is experiencing NSF lock errors. What action should be taken to reduce the network shared file lock contention?

• A. Increase the value of MAX_INCOMPLETE_CONNECTIONS.
• B. Increase the value of NUMFDSERVERS and add more poll threads.
• C. Increase the value of NUMFDSERVERS and increase the number of MSC VPs.
• D. Increase the network buffer pool using the IFX_NETBUF_PVTPOOL_SIZE environment variable.

Answer: B

NEW QUESTION 13
Which operation can benefit from PDQ?

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

Answer: C

NEW QUESTION 14
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 15
You have started a violations table for a target table with a non default name. (For example: "START VIOLATIONS TABLE FOR customer USING exceptions, reasons;"). How can you determine the relationship between the violations table and the target table later?

• A. Using dbschema utility
• B. Using 'oncheck -pT' command
• C. Querying sysdepends system catalog table
• D. Querying sysviolations system catalog table

Answer: D

NEW QUESTION 16
Role separation provides checks and balances to improve the security of your event- auditing procedures. Which two roles must be associated with group IDs to enable role separation? (Choose two.)

• A. DBSEC: DB Security Officer
• B. AAO: Auditing Analysis Officer
• C. DBASO: DB Audit and Security Officer
• D. DBAMO: DB Audit Management Officer
• E. DBSSO: Database System Security Officer

Answer: BE

NEW QUESTION 17
Which action can be taken if an instance is down?

• A. A point-in-time mixed restore.
• B. Warm restore of non-critical storage spaces.
• C. Cold restore by onbar using storage space backups taken by ontape on tape devices.
• D. A mixed restore using onbar whole system backup and incremental dbspace level backups.

Answer: A

NEW QUESTION 18
Which fragmentation strategy is capable of generating new fragments automatically?

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

Answer: B

NEW QUESTION 19
store1, store2, store3 and store4 are defined as four servers participating in a GRID.

Which statement is true?

• A. The SELECT query is not a GRID query.
• B. The SELECT query will return results from all grid servers.
• C. The SELECT query will return results from store1 and store2.
• D. The SELECT query will return results from store3 and store4.

Answer: D

NEW QUESTION 20
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 21
......