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

单项选择题
Given the following DDL for the PARTS table:CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?（）
A.CREATE UNIQUE INDEX idx_partno ON parts(part_no)
B.CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)
C.CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)
D.CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)
单项选择题
Which of the following tools can be used to schedule a backup operation that is to be run every Sunday evening?（）
A.Journal
B.Task Center
C.Activity Monitor
D.Command Line Processor
单项选择题
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 statements is used to prevent user TOM from adding and deleting data in table TAB1?（）
A.REVOKE ADD, DELETE FROM USER tom ON TABLE tab1
B.REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom
C.REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1
D.REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom
单项选择题
What is the maximum size that can be specified when creating an XML column in a DB2 table?（）
A.No size is specified
B.The buffer pool size
C.The page size for the table space
D.The extent size for the table space
单项选择题
A UDT is a data type which:（）
A.must contain unique values.
B.cannot be CAST to other data types.
C.is created using the CREATE DISTINCT command.
D.contains a value that was automatically calculated from values in other columns.
单项选择题
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?（）
A.Read Stability (RS)
B.Repeatable Read (RR)
C.Uncommitted Read (UR)
D.Cursor Stability (CS)
单项选择题
Given that tables T1 and T2 contain the following rows: Table T1:C1 C25 4 5 2 5 5Table T2: C1 C2 5 1 5 2 5 3Which of the following queries will return only those rows that exist in T1 and not in T2?（）
A.SELECT * FROM T1 MINUS SELECT * FROM T2
B.SELECT * FROM T1 EXCEPT SELECT * FROM T2
C.SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1
D.SELECT * FROM T1 NOT EXISTS SELECT * FROM T2
单项选择题
Which of the following strings can be inserted into an XML column using XMLPARSE?（）
A."<employee/>"
B."<?xml version='1.0' encoding='UTF-8' ?>"
C."<!DOCTYPE hello SYSTEM 'hello_world.dtd'>"
D."<x xmlns:ibmcert='http://www.ibm.com/certify'>"
单项选择题
A DRDA host database resides on a z/OS or an i5/OS system and listens on port 446. The TCP/IP address for this system is 192.168.10.1 and the TCP/IP host name is myhost. Which of the following commands is required to update the local node directory so that a DB2 client can access this DRDA database?（）
A.CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 446
B.CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 446
C.CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 192.168.10.1
D.CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 192.168.10.1