问题:单选题Which of the following is the main feature of an OLTP application?()A Summarized queriesB Granular transactionsC Voluminous historical dataD Heterogeneous data sources
查看答案
问题:单选题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 How can this function be used in an SQL statement?A SELECT TABLE(EMPLIST()) FROM EMPLOYEEB SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEEC SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEED SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t
问题:单选题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 * FROM t1 UNION DISTINCT SELECT * FROM t2C SELECT * FROM t1 INTERSECT SELECT * FROM t2D SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
问题:单选题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 the following query: SELECT e.id, d.deptname FROM employee e, department d WHERE e.deptid = d.id AND e.id > 4 Which of the following queries will produce the same result set as the query above?()A SELECT e.id, d.deptname FROM employee e, department d WHERE e.id > 4B SELECT e.id, d.deptname FROM employee e INNER JOIN department d ON e.deptid = d.id WHERE e.id > 4C SELECT e.id, d.deptname FROM employee e FULL OUTER JOIN department d ON e.id = d.id WHERE e.id > 4D SELECT e.id, d.deptname FROM employee e LEFT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4 UNION ALL SELECT e.id, d.deptname FROM employee e RIGHT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4
问题:单选题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
问题:单选题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
问题:单选题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 MAINID as a FOREIGN KEYD Define an UPDATE trigger on table TABLEX
问题:单选题Which kind of non-sourced UDF can be created so that it only returns a single value?()A RowB TableC ScalarD Column
问题:单选题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 SELECT * FROM T1 EXCEPT SELECT * FROM T2C SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1D SELECT * FROM T1 NOT EXISTS SELECT * FROM T2
问题:单选题Which of the following supports the XML data type?()A A unique indexB A composite indexC A check constraintD A generated column
问题:单选题A number of applications issue the following SQL statement:SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno = e.deptnoA database administrator wishes to store this query within the database. Which of the following database objects can be used to accomplish this?()A AliasB ViewC SchemaD Trigger
问题:单选题When defining a referential constraint between the parent table T2 and the dependent table T1, which of the following is true?()A The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.B The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.C The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.D The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.
问题:单选题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 FROM staff
问题:单选题To which of the following resources can a lock be applied?()A RowB AliasC BitmapD Column
问题:单选题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
问题:单选题Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?()A The cursor is only protected from updates and deletes by concurrent applications.B The row is only protected from positioned updates and deletes that reference another cursor of the same application.C The cursor is protected from positioned updates and deletes that reference another cursor of a different application.D The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application.
问题:单选题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?()A Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.B Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).C Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.D 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.