C2090-619 Exam Questions

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...

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

Which table attribute defines the percentage of changes (insert/update/delete) threshold to consider the statistics as stale?

The total number of locks allocated equals the value specified by the LOCKS configuration parameter. What is the behavior of the database server when more locks are now requested?

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

Which statement accurately describes the mapped user functionality in Informix?

Which statement about DataBlade modules is true?

memory by the database server. Which two kernel parameters may need to be configured? (Choose two.)

When the server is in administration mode, which users are NOT allowed to connect?

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

Which storage manager allows specification of a larger size than others for

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

What kinds of Table Level Restores can be done by the archecker utility?

Which Informix utility can be used to display contents of logical-log files, either from disk or from backup?

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

Which statement is true about log salvaging?

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

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

Which operation can benefit from PDQ?

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

Which statement is valid about Data consolidation using send-only replicates?