最新的高品質 C2090-610 考試練習題庫

IBM C2090-610 考試概覽:

IBM C2090-610 考試大綱主題:

最新的 IBM Certified Application Developer C2090-610 免費考試真題：

問題 #1

User USER1 wants to define a required relationship between two tables named TAB1 and TAB2 in such a way that whenever a record is deleted from table TAB1, any related records are deleted from table TAB2. What must user USER1 do to accomplish this?

A. 1) Create a primary key on table TAB1;
2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres
to the ON DELETE RESTRICT rule.
B. 1) Create a primary key on table TAB2;
2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres
to the ON DELETE RESTRICT rule.
C. 1) Create a primary key on table TAB2;
2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres
to the ON DELETE CASCADE rule.
D. 1) Create a primary key on table TAB1;
2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres
to the ON DELETE CASCADE rule.

問題 #2

Which DB2 product is a database cluster solution for non-mainframe platforms and is best suited for Online Transaction Processing (OLTP) workloads?

A. Workload Manager
B. High Availability Disaster Recovery
C. DB2 Connect
D. DB2 pureScale

問題 #3

When is an INTENT EXCLUSIVE (IX) lock required?

A. When a transaction intends to read or change data.
B. When a transaction intends to change the system catalog.
C. When a transaction intends to read but not change data.
D. When a transaction intends to change but not read data.

問題 #4

User USER1 wants to store part numbers and part descriptions in a table named PARTS; user USER1 also wants to ensure that any comparisons of part descriptions that are made will be done so in binary, regardless of the database collating sequence used. Which statement should user USER1 execute to create the desired table?

A. CREATE TABLE parts
(part_no INTEGER,
desc CLOB))
B. CREATE TABLE parts
(part_no INTEGER,
desc VARCHAR(200) FOR BIT DATA)
C. CREATE TABLE parts
(part_no INTEGER,
desc VARCHAR(200))
D. CREATE TABLE parts
(part_no INTEGER,
desc CLOB FOR BIT DATA))

問題 #5

What are two valid objects that can be created in DB2? (Choose two.)

A. Trigger
B. Node
C. Contexts
D. Tree
E. Sequence

問題與答案：