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

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

1 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)擊查看答案

2 Which of the following database objects is considered executable using SQL?（）

點(diǎn)擊查看答案

3 In which situation is shredding XML data recommended?（）

點(diǎn)擊查看答案

4 Which of the following will DELETE all of the rows from table T03?（）

點(diǎn)擊查看答案

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

點(diǎn)擊查看答案

6 Which of the following statements eliminates all but one of each set of duplicate rows in the DEPT column in the STAFF table?（）

點(diǎn)擊查看答案

7 Given the following stored procedure:CREATE PROCEDURE increase_salary ( IN p_workdept CHAR(6), OUT p_sum DECIMAL(9,2) ) SET p_sum = (SELECT SUM(salary) FROM employee WHERE workdept=p_workdept);How can this stored procedure be called from the Command Line Processor?（）

點(diǎn)擊查看答案

8 Which of the following is true of an index used to support a UNIQUE constraint?（）

點(diǎn)擊查看答案

9 Which of the following best describes how locks are used in DB2?（）

點(diǎn)擊查看答案

10 Which of the following is the main feature of an OLTP application?（）

點(diǎn)擊查看答案

<del id="omwa0"></del>

<strike id="omwa0"></strike>