站内搜索
IBM(000-730) 问题列表
问题
单选题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
问题
单选题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
问题
单选题Which of the following describes the objects of a DB2 database and their relationships?（）A
InstanceB
Table spaceC
System catalogD
Schema repository
问题
单选题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 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
问题
单选题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 supports the XML data type?（）A
A unique indexB
A composite indexC
A check constraintD
A generated column
问题
单选题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
问题
单选题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
问题
单选题How does DB2 protect the integrity of indexes when data is updated?（）A
Locks are acquired on the data.B
Locks are acquired on index keys.C
Locks are acquired on index pages.D
Locks are acquired on index pointers.
问题
单选题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 the ITEMS table was created with the following SQL statement: CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT) Which of the following SQL statements will provide the table definition that meets the specified requirements?（）A
DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLEB
DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSC
CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSD
CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
问题
单选题Which of the following is a characteristic of a sequence?（）A
A sequence will never generate duplicate valuesB
The MAXVALUE of a sequence can be equal to the MINVALUEC
It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zeroD
When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries
问题
单选题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 EditionD
DB2 for i5/OS SQL Development Kit
问题
单选题Which of the following is a characteristic of a schema?（）A
Foreign key references cannot cross schema boundaries.B
A DB2 user must be created before a schema with the same name can be created.C
If no schema is specified when an object is created, the default schema PUBLIC is used.D
A schema enables the creation of multiple objects in a database without encountering namespace collisions.