IBM(000-730)章節(jié)練習(xí)(2018.11.30)

來源：考試資料網(wǎng)

1 What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column?（）

點(diǎn)擊查看答案

2 If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?（）

點(diǎn)擊查看答案

3 The following triggers were defined for table TAB1 in the order shown:CREATE TRIGGER trig_a AFTER UPDATE ON tab1 FOR EACH ROW UPDATE sale_tab SET sale_date = CURRENT DATE; CREATE TRIGGER trig_b AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE invoice_tab SET invoice_date = CURRENT DATE; CREATE TRIGGER trig_c AFTER UPDATE ON tab1 FOR EACH ROW UPDATE shipping_tab SET ship_date = CURRENT DATE; CREATE TRIGGER trig_d AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE billing_tab SETbilling_date = CURRENT DATE;If an event occurs that causes all of them to activate, which trigger will be activated first?（）

點(diǎn)擊查看答案

4 Which of the following tools is used to view historical information about tasks, database changes, messages, and notifications?（）

點(diǎn)擊查看答案

5 Which of the following resources can be explicitly locked?（）

點(diǎn)擊查看答案

6 Given that tables T1 and T2 contain the following rows:
Table T1: C1 C2 1 4 1 3 1 2
Table T2: C1 C2 1 1 1 2 1 3
Which of the following queries will return only those rows that exist in both T1 and T2?（）

點(diǎn)擊查看答案

7 Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?（）

點(diǎn)擊查看答案

8 If an application issues the same query more than once in the same Unit of Work, which isolation level will not permit this application to see additional rows inserted by other applications?（）

點(diǎn)擊查看答案

9 A stored procedure object is created into which DB2 object?（）

點(diǎn)擊查看答案

10 Which of the following DB2 products are required on an iSeries or System i server to enable an application running on that server to retrieve data from a DB2 database on a Linux server?（）

點(diǎn)擊查看答案

广告位招租联系QQ:5245112（WX同号）