C2090-619

Given the following: How many locks will be used on tab1 to run the query?A . 0B . 1C . 2D . Depends on the number of index pages accessedView AnswerAnswer: A

Which configuration parameter can toggle the automatic expansion of storage spaces?A . SP_AUTOGROWB . SP_AUTO_SPACEC . SP_AUTOEXPANDD . SP_EXPAND_ENABLEView AnswerAnswer: C

Which approach is always valid when migrating data across differing hardware and operating system architectures?A . dbexport source system then dbimport into target.B . ontape backup from source then restore backup onto target.C . onunload the source to tape and onload the tape to the target.D . Set up HDR...

In which table can you find a history of all SQL Administration API functions executed in the last 30 days?A . sysadmin:admin_historyB . sysmaster:admin_historyC . sysadmin:command_historyD . sysmaster:command_historyView AnswerAnswer: C

Which one keyword in this query makes the AVG an OLAP window expression instead of the regular aggregate operator? SELECT AVG (SUM (dollars)) OVER () FROM sales;A . SUMB . OVERC . FROMD . AVG(SUM(dollars))View AnswerAnswer: B

Which statement describes the behavior of an Informix instance when the IFX_EXTEND_ROLE configuration parameter is set to ON.A . All users with the EXTEND role can grant it to other users.B . All users with the default role can register external routines.C . All users can create external routines in...

After executing the following commands: onmode -j -U karin,dave onmode -j -U karin,sarah onmode -j -U sarah which user(s) have access to the instance?A . sarahB . karin and daveC . karin and sarahD . karin, dave and sarahView AnswerAnswer: A

Which statement accurately describes the mapped user functionality in Informix?A . The DBSA can control the access to the database at the table level by creating different security labels for each user.B . The DBSA can create different roles for each user in order to verify whether the user who...

Which statement about DataBlade modules is true?A . All DataBlades located in the $INFORMIXDIR/extend are automatically registered.B . All built-in extensions are automatically registered when the extension is first accessed.C . All built-in extensions are automatically registered each time the database sever is started.D . All built-in extensions are automatically...

Which is NOT a component of the IBM Mobile Database offering?A . IBM DB2B . IBM InformixC . IBM solidDBD . IBM InfoSphere WarehouseView AnswerAnswer: D