C2090-619 exam

What data migration tool(s) should be used to load data from a non-Informix data source?A . dbimportB . onload and dbloadC . dbload and High Performance LoaderD . onload and High Performance LoaderView AnswerAnswer: C

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

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

Which configuration parameter locks the resident and virtual segments of shared memory in operating-system physical memory?A . SHMSEGB . SHMBASEC . RESIDENTD . INFORMIXSHMLCKView AnswerAnswer: C

Which statement is true for starting Connection Manager?A . Only user root and informix.B . Any user of the DBSA group.C . Any user who is granted privileges to connect to the sysadmin database.D . Only a user of the DBSA group with privilege to connect to the sysadmin database.View...

Which value of DRINTERVAL should be used for HDR_TXN_SCOPE configuration parameter to take effect?A . -1B . 0C . 1D . 30View AnswerAnswer: B

Which statement is true about restartable restore?A . ontape can perform restartable restores if a backup is taken to disk.B . Restartable restore is the ability to restart a failed restore using onbar.C . Restartable restore is the ability to restart a failed restore using ontape.D . Restartable restore is...

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

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 OfficerB . AAO: Auditing Analysis OfficerC . DBASO: DB Audit and Security OfficerD . DBAMO: DB Audit...

Which two parameters are mandatory when running "ifxclone"? (Choose two.)A . Target server instance size.B . Target server instance name.C . Source server instance sqlhosts.D . Target server configuration parameters.E . Source server instance TCP/IP address.View AnswerAnswer: B,E