IBM(000-730)章节练习(2019.04.24)

单项选择题
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?（）
A.DB2 for i5/OS
B.DB2 Runtime Client
C.DB2 Connect Enterprise Edition
D.DB2 for i5/OS SQL Development Kit
单项选择题
Which of the following database objects is considered executable using SQL?（）
A.View
B.Table
C.Routine
D.Package
单项选择题
In which situation is shredding XML data recommended?（）
A.When the data is naturally tabular
B.When the number of nodes are volatile
C.When the data by nature has sparse attributes
D.When the data is of low volume and requires a complex star-schema topology
单项选择题
Which of the following will DELETE all of the rows from table T03?（）
A.DELETE * FROM TABLE T03
B.DELETE ALL FROM T03
C.DELETE * FROM T03
D.DELETE FROM T03
单项选择题
Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?（）
A.Unique
B.Check
C.Referential
D.Informational
单项选择题
Which of the following statements eliminates all but one of each set of duplicate rows in the DEPT column in the STAFF table?（）
A.SELECT UNIQUE dept FROM staff
B.SELECT DISTINCT dept FROM staff
C.SELECT (dept) UNIQUE FROM staff
D.SELECT (dept) DISTINCT FROM staff
单项选择题
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?（）
A.CALL increase_salary('A00')
B.VALUES increase_salary('A00')
C.CALL increase_salary('A00', ?)
D.VALUES increase_salary('A00', ?)
单项选择题
Which of the following is true of an index used to support a UNIQUE constraint?（）
A.It must have the UNIQUE attribute.
B.It cannot be created explicitly by the user.
C.It must have the UNIQUE and CLUSTER attributes.
D.It must have the UNIQUE WHERE NOT NULL attribute.
单项选择题
Which of the following best describes how locks are used in DB2?（）
A.To maintain control of updated rows for commit processing
B.To ensure only committed changes are altered by another application
C.To allow two applications to update the same row of data simultaneously
D.To prevent multiple applications from accessing the same data simultaneously
单项选择题
Which of the following is the main feature of an OLTP application?（）
A.Summarized queries
B.Granular transactions
C.Voluminous historical data
D.Heterogeneous data sources