单项选择题

Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?（）

A.The next value will be 0 and the sequence will never use the values 101 to 105.
B.The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.
C.Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.
D.The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.

<上一题目录下一题>

热门试题

单项选择题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

单项选择题Which object may be used during query optimization to improve the performance for a subset of SELECT queries?（）

A.MQT
B.Trigger
C.Read Only Cursor
D.Stored Procedure

单项选择题To which of the following resources can a lock be applied?（）

A.Row
B.Alias
C.Bitmap
D.Column

单项选择题Application A holds an Update lock on a single row and application B is trying to read that row. If both applications are using isolation level UR, which of the following will occur?（）

A.Application B will read the row.
B.Applications A and B will cause a deadlock situation.
C.Application B will wait until application A releases the Update lock.
D.Application A will be terminated so that application B can read the row.

单项选择题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=A00Application 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?（）

A.The database manager will rollback the transaction in both applications.
B.The database manager will rollback the transaction in one of the two applications.
C.Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.
D.Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.