C2090-619

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

Which Informix utility can be used to display contents of logical-log files, either from disk or from backup?A . onlogB . oncleanC . ondblogD . onspacesView AnswerAnswer: A

What security role is required for you to create trusted-context objects?A . AAOB . DBSAC . DBSSOD . DBSECADMView AnswerAnswer: D

Which Informix utility is used to print information about runtime statistics for all threads in the server?A . onstat -g staB . onstat -g actC . onstat -g reaD . onstat -g cpuView AnswerAnswer: D

Which SQL statement is valid to monitor database server sessions?A . EXECUTE FUNCTION task ("onstat","-g ses");B . EXECUTE FUNCTION task ("view sessions","all");C . EXECUTE FUNCTION task ("check sessions","all");D . EXECUTE FUNCTION task ("check server","sessions");View AnswerAnswer: A

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

Several operating-system kernel configuration parameters can affect the use of shared memory by the database server. Which two kernel parameters may need to be configured? (Choose two.)A . Memory page size.B . Total number of available semaphores.C . Lower-boundary address for shared memory.D . Total memory presented to the operating...

Which two actions can you perform with ontape? (Choose two.)A . Backup to cloudB . Restartable restoreC . Backup specific storage spacesD . Restore specific storage spacesE . Parallel backup of storage spacesView AnswerAnswer: A,D

Which command would you use to export and import backup object metadata from one database server to another in conjunction with Primary Storage Manager?A . onbar -EB . dbexportC . onsmsyncD . ontape -expView AnswerAnswer: C

Which is NOT a feature of onbar backups?A . The ability to parallelize backups.B . The ability to do a point-in-time restore.C . The ability to backup without a storage manager.D . The ability to do an external backup using a Storage Area Network.View AnswerAnswer: C