- All Exams Instant Download
When configuring Informix server for DRDA connection, which statement is true?
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?
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?
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?
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?
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
What action should be taken to prevent this problem in the future?
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 ....
Which two kernel parameters may need to be configured?
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.)
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?
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?
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
