问题:单选题Which of the following privileges permits a user to update the comment on a sequence?()A CONTROLB UPDATEC USAGED ALTER...
查看答案
问题:单选题Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server?()A DB2 Express EditionB DB2 Personal EditionC DB2 Workgroup Server EditionD DB2 Enterprise Server Edition...
问题:单选题Given the following table definitions: EMPLOYEE ID NAME DEPTID 01Smith 10 02Bossy 20 03 20 Peterson 04Goss 30 05Pape 40 06Avery 50 07O'Neal 60 08Carter 50 DEPARTMENT ID DEPTNAME 05 Hardware 10 Kitchen 20 Shoes 30 Toys 40 Electronics 50 Automotive and t...
问题:单选题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....
问题:单选题Which of the following describes the objects of a DB2 database and their relationships?()A InstanceB Table spaceC System catalogD Schema repository...
问题:单选题A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_sequence CACHE 10 ORDER The following statements are successfully executed in sequence through separate database connections: CONNECTION1 - VALUES NEXT VALUE FOR my_sequence I...
问题:单选题Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?()A REVOKE SELECT FROM user2 ON TABLE org.tab1B REVOKE SELECT ON TABLE org.tab1 FROM user2C REVOKE READ ACCESS FROM user2 ON TABLE org.tab1D REVOKE...
问题:单选题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?()A SELECT * FROM T1 MINUS SELECT * FROM T2B SELEC...
问题:单选题Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?()A An application process acquires at least a share lock on the current row of every cursor.B Any row that is read during a unit of work cannot be changed by other applic...
问题:单选题Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?()A CLOBB BLOBC HierarchicallyD Rows and columns...
问题:单选题To which of the following resources can a lock be applied?()A RowB AliasC BitmapD Column...
问题:单选题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 Li...
问题:单选题An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming ...
问题:单选题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 staffB SELECT DISTINCT dept FROM staffC SELECT (dept) UNIQUE FROM staffD SELECT (dept) DISTINCT FRO...
问题:单选题Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?()A Define the column MAINID as NOT UPDATABLEB Define the column MAINID as a PRIMARY KEYC Define the column ...
问题:单选题Given the following function: CREATE FUNCTION emplist ( ) RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END ...
问题:单选题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/OSB DB2 Runtime ClientC DB2 Connect Enterprise Editi...
问题:单选题Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 1 4 1 3 1 2 Table T2: C1 C2 1 1 1 2 1 3 Which of the following queries will return only those rows that exist in both T1 and T2?()A SELECT * FROM t1 UNION SELECT * FROM t2B SELECT ...
问题:单选题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...
问题:单选题Which of the following supports the XML data type?()A A unique indexB A composite indexC A check constraintD A generated column...