A2090-919試験無料問題集（123題）「IBM Assessment: System Administrator for Informix Server 11.70 認定」

出題：1

Which object can be defragmented?

A. system catalog table

B. temporary table

C. external table

D. index

正解：D 解答を投票する

出題：2

How does the Deployment Assistant enable you to reduce the size of the installation to be deployed?

A. By removing specific databases.

B. By limiting the size of dbspaces.

C. By removing specific product features.

D. By removing all free space at the end of a chunk.

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

When creating an index, which type of fragmentation is NOT allowed?

A. Expression fragmentation.

B. List fragmentation.

C. Round-robin fragmentation.

D. Interval fragmentation.

正解：C 解答を投票する

出題：4

When executing the SQL Admin API "defragment table" and "table repack" commands on the customer table, what will happen to the table? (Choose two.)
execute function sysadmin:task("defragment table","customer"); execute function sysadmin:task("table repack", "customer");

A. Given sufficient resources the number of extents in the table will be reduced.

B. Fragments of a table will be combined.

C. Free space at the end of the table will be released to the dbspace for other tables to use.

D. The table will be locked preventing inserts from happening for the duration of the commands.

E. Rows will be moved to the beginning of table.

正解：A,E 解答を投票する

出題：5

Which onstat command will allow the gathering of statistics about the Informix Database Scheduler tasks that are currently running or scheduled to be run?

A. onstat -g sch

B. onstat -g tsk

C. onstat -g dbc

D. onstat -g adm

正解：C 解答を投票する

出題：6

What statement about users accessing a Flexible Grid is true?

A. Commands can only be executed from the node on which the Flexible Grid was created.

B. Every user can execute commands on the Flexible Grid.

C. Only user informix can execute commands on a Flexible Grid.

D. Users have to be authorized to execute Flexible Grid commands.

正解：D 解答を投票する

出題：7

When a SELECT statement is executed which statement is true?

A. If COMMITTED READ isolation is in place then the SELECT will never encounter any locking errors.

B. Within a transaction the database server will place row or page locks on a nonlogging table.

C. If the SELECT is part of an UPDATE cursor then the database server will place an exclusive lock on the entire dataset.

D. The number and duration of the locks is dependent on the ISOLATION LEVEL.

正解：D 解答を投票する

A2090-919試験無料問題集「IBM Assessment: System Administrator for Informix Server 11.70 認定」