976 お客様のコメント
クリック」
質問 1：
Which of the following statements about triggers are TRUE? (Choose two.)
A. There is a limit of 8 for the maximum number of cascading trigger activations
B. Constraints associated with a subject table are applied between execution of BEFORE and AFTER triggers
C. Triggers can be activated as a result of changes due to referential constraint enforcement
D. The activation of the triggers for a particular table, event and activation time are conducted in descending order of trigger creation time
E. Multiple INSTEAD OF triggers are allowed for each kind of operation on a given subject view
正解：B,C
質問 2：
Shadow tables are a special kind of Materialized Query Table, but what makes them different? (Choose two.)
A. Shadow tables do not store their data on disk
B. Shadow tables must be organized by column
C. Shadow tables cannot be queried directly
D. You cannot join shadow tables to other kinds of tables
E. Shadow tables must be maintained by replication
正解：B,E
質問 3：
Which of the following is TRUE about indexes on column organized tables?
A. An index is only allowed on the synopsis table supporting a column organized table
B. Indexes are automatically created to enforce unique constraints
C. Indexes are only allowed on numeric columns
D. No indexes are allowed
正解：D
質問 4：
Which isolation level will allow application A to immediately read the committed value of a row that is exclusively locked by application B?
A. Repeatable Read
B. Cursor Stability
C. Read Stability
D. Cursor Stability with WAIT FOR OUTCOME clause
正解：C
解説: (Pass4Test メンバーにのみ表示されます)
質問 5：
Which of the following authorities is sufficient for connecting to a database?
A. DATAACESS
B. ACCESSCTRL
C. SQLADM
D. CONNECT
正解：B
質問 6：
Which of the following editions of DB2 include support for Federation with Oracle database?
A. DB2 Developer Edition
B. DB2 Express-C
C. DB2 Enterprise Server Edition
D. DB2 Workgroup Server Edition
正解：C
Which of the following statements about triggers are TRUE? (Choose two.)
A. There is a limit of 8 for the maximum number of cascading trigger activations
B. Constraints associated with a subject table are applied between execution of BEFORE and AFTER triggers
C. Triggers can be activated as a result of changes due to referential constraint enforcement
D. The activation of the triggers for a particular table, event and activation time are conducted in descending order of trigger creation time
E. Multiple INSTEAD OF triggers are allowed for each kind of operation on a given subject view
正解：B,C
質問 2：
Shadow tables are a special kind of Materialized Query Table, but what makes them different? (Choose two.)
A. Shadow tables do not store their data on disk
B. Shadow tables must be organized by column
C. Shadow tables cannot be queried directly
D. You cannot join shadow tables to other kinds of tables
E. Shadow tables must be maintained by replication
正解：B,E
質問 3：
Which of the following is TRUE about indexes on column organized tables?
A. An index is only allowed on the synopsis table supporting a column organized table
B. Indexes are automatically created to enforce unique constraints
C. Indexes are only allowed on numeric columns
D. No indexes are allowed
正解：D
質問 4：
Which isolation level will allow application A to immediately read the committed value of a row that is exclusively locked by application B?
A. Repeatable Read
B. Cursor Stability
C. Read Stability
D. Cursor Stability with WAIT FOR OUTCOME clause
正解：C
解説: (Pass4Test メンバーにのみ表示されます)
質問 5：
Which of the following authorities is sufficient for connecting to a database?
A. DATAACESS
B. ACCESSCTRL
C. SQLADM
D. CONNECT
正解：B
質問 6：
Which of the following editions of DB2 include support for Federation with Oracle database?
A. DB2 Developer Edition
B. DB2 Express-C
C. DB2 Enterprise Server Edition
D. DB2 Workgroup Server Edition
正解：C
Ninomiya -
試験に合格しました。C2090-616試験問題集は本当にわかりやすいです！最後まで頑張りました。合格できるのは何よりです。