问题:单选题To which of the following resources can a lock be applied?()A RowB AliasC BitmapD Column
查看答案
问题:单选题Given the following tables: CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West How many rows would be returned using the following statement? SELECT location FROM continents, region()A 2B 7C 9D 14
问题:单选题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 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
问题:单选题A table was created using the following DDL: CREATE TABLE employee (id SMALLINT NOT NULL, name VARCHAR(9), dept SMALLINT CHECK (dept BETWEEN 10 AND 100), job CHAR(10) CHECK (job IN ('Sales','Mgr','Clerk')), hiredate DATE, salary DECIMAL(7,2), comm DECIMAL(7,2), PRIMARY KEY (id), CONSTRAINT yearsal CHECK (YEAR(hiredate) > 2004 OR salary > 80500) ); Which of the following INSERT statements will fail?()A INSERT INTO employee VALUES (2, 'Smith', 80, 'Mgr', '09/03/2006', 80000, NULL)B INSERT INTO employee VALUES (4, 'Smith', 86, 'Mgr', '07/14/2003', 90000, NULL)C INSERT INTO employee VALUES (1, 'Smith', 55, 'Sales', '07/14/2003', NULL, NULL)D INSERT INTO employee VALUES (3, 'Smith', 33, 'Analyst', '11/26/2006', 90000, NULL)
问题:单选题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.
问题:单选题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
问题:单选题A stored procedure object is created into which DB2 object?()A AliasB SchemaC PackageD Routine Space
问题:单选题Given the following DDL and INSERT statements: CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100); How many of these INSERT statements will be successful?()A 0B 1C 2D 3
问题:单选题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
问题:单选题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)
问题:单选题Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?()A UniqueB CheckC ReferentialD Informational
问题:单选题Which of the following supports the XML data type?()A A unique indexB A composite indexC A check constraintD A generated column
问题:单选题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 the objects of a DB2 database and their relationships?()A InstanceB Table spaceC System catalogD Schema repository
问题:单选题Given the following two tables: TAB1 C1 C2 1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY 5 Europe 6 North America 7 South America Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?()A INSERT INTO tab1 SELECT cx, cy FROM tab2B INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)C INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)D INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)
问题:单选题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.
问题:单选题An Alias can be an alternate name for which DB2 object?()A SequenceB TriggerC SchemaD View
问题:单选题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