单选题
Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?（）
CLOB
BLOB
Hierarchically
Rows and columns
单选题
Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?（）
The database manager will rollback the transaction in both applications.
The database manager will rollback the transaction in one of the two applications.
Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.
Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.
单选题
Which of the following supports the XML data type?（）
A unique index
A composite index
A check constraint
A generated column
单选题
The opening of cursor CSR01 produces the following result set: STUDENT LASTNM FIRSTNM CLASSNO 123 Brown John T100 213 Bailey James T100 312 Carter Arlene T210 465 Chas Devon T305 546 Davis Steven T405 If this Fetch statement is executed: FETCH csr01 INTO :studnum, :firstname, :lastname, :class Which of the following DELETE statements will cause this row to be deleted?（）
DELETE ALL FROM tab01 FOR CURRENT OF csr01
DELETE FROM tab01 FOR CURRENT csr01 WITH RS
DELETE * FROM tab01 WHERE CURRENT csr01 WITH CS
DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR
单选题
Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 5 4 5 2 5 5 Table T2: C1 C2 5 1 5 2 5 3 Which of the following queries will return only those rows that exist in T1 and not in T2?（）
SELECT * FROM T1 MINUS SELECT * FROM T2
SELECT * FROM T1 EXCEPT SELECT * FROM T2
SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1
SELECT * FROM T1 NOT EXISTS SELECT * FROM T2
单选题
To which of the following resources can a lock be applied?（）
Row
Alias
Bitmap
Column
单选题
Which of the following statements eliminates all but one of each set of duplicate rows in the DEPT column in the STAFF table?（）
SELECT UNIQUE dept FROM staff
SELECT DISTINCT dept FROM staff
SELECT (dept) UNIQUE FROM staff
SELECT (dept) DISTINCT FROM staff
单选题
Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?（）
Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.
Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).
Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.
Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.
单选题
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?（）
Read Stability (RS)
Repeatable Read (RR)
Uncommitted Read (UR)
Cursor Stability (CS)
单选题
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?（）
CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 446
CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 446
CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 192.168.10.1
CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 192.168.10.1
推荐考题
-
下列属于直线行驶的是（）
-
某通信机房设置七氟丙烷预制灭火系统，该系统应有( )种启动方式。
-
唐后期书院产生的一个原因是受到（）的影响。
-
压力损失是指（）
-
干旱区造林，整地的主要目的是（）
-
治癫证痰气郁结证，治以（）
-
小学低、中年级的儿童____识记发展最为迅速。
-
（ ）是北京市制定的第一个全面保护历史文化名城的法规。
-
安全带的正确使用：使用前作外观检查，若破损应（）使用。
-
Your network consists of a single Active Directory domain. The domain contains more than 300 group objects. The group objects are divided between several regional organizational units (OUs). You need to create a list of all groups that have names that begin with the word Sales. Which command should you use? （）