A.View
B.Table
C.Routine
D.Package
您可能感兴趣的试卷
你可能感兴趣的试题
A.Instance
B.Table space
C.System catalog
D.Schema repository
A.View
B.Alias
C.Table
D.Package
A.Alias
B.View
C.Schema
D.Trigger
A.After a ROLLBACK is issued
B.After the sequence is altered
C.After the sequence is dropped
D.After the current session ends
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.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
A.MQT
B.Trigger
C.Read Only Cursor
D.Stored Procedure
A.Row
B.Alias
C.Bitmap
D.Column
最新试题
Given that tables T1 and T2 contain the following rows:Table T1: C1 C2 1 4 1 3 1 2Table T2: C1 C2 1 1 1 2 1 3Which of the following queries will return only those rows that exist in both T1 and T2?()
Given the following two tables:TAB1 R1A A A B B C C D E TAB2 R2A A B B C C DWhich of the following queries returns the following result set? RETVAL E()
CREATE TABLE customer (cid BIGINT NOT NULL PRIMARY KEY, info XML) How many names will be returned for this XQuery?()
Which of the following DB2 data types has a fixed length?()
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?()
Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?()
A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ; When will DB2 access the data from table T1 for view V1?()
Given the following table definition:STOCK: item VARCHAR(30) status CHAR(1) quantity INT price DEC(7,2)If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero, which of the following statements would be used to update the STOCK table to indicate that all the items whose description begins with the letter "S" are out of stock?()
Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?()
Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?()