質問 1：
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. dbexport
B. onbar -E
C. onsmsync
D. ontape -exp
正解：C
質問 2：
You need to create a new role for users on stores database. Which system catalog table can be checked to ensure the uniqueness of the new role name?
A. sysmaster:sysroles
B. sysmaster:sysusers
C. sysuser:sysroleauth
D. stores:sysusers
正解：D
質問 3：
What data migration tool(s) should be used to load data from a non-Informix data source?
A. onload and dbload
B. dbimport
C. dbload and High Performance Loader
D. onload and High Performance Loader
正解：C
質問 4：
To potentially reduce table extent interleaving, an Informix administrator would execute which storage optimization operation?
A. Compress
B. Shrink
C. Defragment
D. Repack
正解：C
質問 5：
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 database server is first initialized.
C. All built-in extensions are automatically registered when the extension is first accessed.
D. All built-in extensions are automatically registered each time the database sever is started.
正解：C
質問 6：
Which HDR configuration parameter provides three synchronization modes to control when transaction commits are returned to client applications?
A. HDR_TXN_SCOPE
B. DELAY_APPLY
C. LOG_INDEX_BUILDS
D. FAILOVER_TX_TIMEOUT
正解：A
質問 7：
How can you ensure to hold the an update lock until the end of a transaction when fetching rows from a cursor?
A. Use the 'Cursor Stability' isolation level along the WITH HOLD clause.
B. Use the SET TRANSACTION command to with SERIALIZABLE clause.
C. Use the RETAIN UPDATE LOCKS clause with isolation level.
D. Use the 'Committed Read' isolation level.
正解：C
質問 8：
What command unlocks the storage catalogs when using the Primary Storage Manager?
A. onpsm -C unlock
B. onmode -C unlock
C. onbar -d unlock
D. onsmsync -c unlock
正解：A
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. dbexport
B. onbar -E
C. onsmsync
D. ontape -exp
正解：C
質問 2：
You need to create a new role for users on stores database. Which system catalog table can be checked to ensure the uniqueness of the new role name?
A. sysmaster:sysroles
B. sysmaster:sysusers
C. sysuser:sysroleauth
D. stores:sysusers
正解：D
質問 3：
What data migration tool(s) should be used to load data from a non-Informix data source?
A. onload and dbload
B. dbimport
C. dbload and High Performance Loader
D. onload and High Performance Loader
正解：C
質問 4：
To potentially reduce table extent interleaving, an Informix administrator would execute which storage optimization operation?
A. Compress
B. Shrink
C. Defragment
D. Repack
正解：C
質問 5：
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 database server is first initialized.
C. All built-in extensions are automatically registered when the extension is first accessed.
D. All built-in extensions are automatically registered each time the database sever is started.
正解：C
質問 6：
Which HDR configuration parameter provides three synchronization modes to control when transaction commits are returned to client applications?
A. HDR_TXN_SCOPE
B. DELAY_APPLY
C. LOG_INDEX_BUILDS
D. FAILOVER_TX_TIMEOUT
正解：A
質問 7：
How can you ensure to hold the an update lock until the end of a transaction when fetching rows from a cursor?
A. Use the 'Cursor Stability' isolation level along the WITH HOLD clause.
B. Use the SET TRANSACTION command to with SERIALIZABLE clause.
C. Use the RETAIN UPDATE LOCKS clause with isolation level.
D. Use the 'Committed Read' isolation level.
正解：C
質問 8：
What command unlocks the storage catalogs when using the Primary Storage Manager?
A. onpsm -C unlock
B. onmode -C unlock
C. onbar -d unlock
D. onsmsync -c unlock
正解：A
0 お客様のコメント