站内搜索
IBM(000-730) 问题列表
问题
单选题The EMPLOYEE table contains the following information: EMPNO NAME WORKDEPT 101 SAM A11 102 JOHN C12 103 JANE -104 PAT Remote 105 ANNE -106 BOB A11 The MANAGER table contains the following information: MGRID NAME DEPTNO EMPCOUNT 1 WU B01 - 2 JONES A11 - 3 CHEN - - 4 SMITH - -5 THOMAS C12 - After this statement is executed: UPDATE manager m SET empcount = (SELECT COUNT(workdept) FROM employee e WHERE workdept=m.deptno) What is the result of the following query?() SELECT mgrid, empcount FROM MANAGER WHERE empcount IS NOT NULL ORDER BY mgridA
MGRID EMPCOUNT ----- -------- 1 0 2 2 5 1B
MGRID EMPCOUNT ----- -------- 1 0 2 2 3 0 4 0 5 1C
MGRID EMPCOUNT ----- -------- 1 3 2 3 3 3 4 3 5 3D
MGRID EMPCOUNT ----- -------- 1 0 2 2 3 2 4 2 5 1
问题
单选题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
问题
单选题Which of the following is the lowest cost DB2 product that can be legally installed on a Linux server that has 6 CPUs?()A
DB2 Express EditionB
DB2 Personal EditionC
DB2 Workgroup Server EditionD
DB2 Enterprise Server Edition
问题
单选题A "trusted" client needs to communicate with a server that has been configured to use CLIENT authentication. Which of the following will be used to verify passwords?()A
User ID/password fileB
Communications layerC
Client applicationsD
Operating system
问题
单选题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 READ ACCESS ON TABLE org.tab1 FROM user2
问题
单选题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 table T1 has column I1 containing the following data: I1 1 2 3 4 If the following sequence of SQL statements is applied within a single unit of work: UPDATE t1 SET i1 = 3 WHERE i1 = 2; S AVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE t1 SET i1 = 5 WHERE i1 = 3; SAVEPOINT s2 ON ROLLBACK RETAIN CURSORS;INSERT INTO t1 (i1) VALUES (6); ROLLBACK TO SAVEPOINT s1; UPDATE t1 SET i1 = 2 WHERE i1 = 4; COMMIT; What is the expected sequence of values returned from?() SELECT i1 FROM t1 ORDER BY i1A
1, 2, 3, 3B
1, 2, 2, 4C
1, 2, 3, 3, 6D
1, 2, 2, 5, 6
问题
单选题Which of the following best describes how locks are used in DB2?()A
To maintain control of updated rows for commit processingB
To ensure only committed changes are altered by another applicationC
To allow two applications to update the same row of data simultaneouslyD
To prevent multiple applications from accessing the same data simultaneously
问题
单选题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
问题
单选题Which of the following strings can be inserted into an XML column using XMLPARSE?()A
employee/B
?xml version='1.0' encoding='UTF-8' ?C
!DOCTYPE hello SYSTEM 'hello_world.dtd'D
x xmlns:ibmcert='http://www.ibm.com/certify'
问题
单选题The following triggers were defined for table TAB1 in the order shown:CREATE TRIGGER trig_a AFTER UPDATE ON tab1 FOR EACH ROW UPDATE sale_tab SET sale_date = CURRENT DATE; CREATE TRIGGER trig_b AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE invoice_tab SET invoice_date = CURRENT DATE; CREATE TRIGGER trig_c AFTER UPDATE ON tab1 FOR EACH ROW UPDATE shipping_tab SET ship_date = CURRENT DATE; CREATE TRIGGER trig_d AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE billing_tab SETbilling_date = CURRENT DATE;If an event occurs that causes all of them to activate, which trigger will be activated first?()A
TRIG_AB
TRIG_BC
TRIG_CD
TRIG_D
问题
单选题The opening of cursor CSR01 produces the following result set: STUDENT LASTNM FIRSTNM CLASSNO 123 Brown John T100 213 Bailey James T100 312 Carter Arlene T210 465 Chas Devon T305 546 Davis Steven T405 If this Fetch statement is executed: FETCH csr01 INTO :studnum, :firstname, :lastname, :class Which of the following DELETE statements will cause this row to be deleted?()A
DELETE ALL FROM tab01 FOR CURRENT OF csr01B
DELETE FROM tab01 FOR CURRENT csr01 WITH RSC
DELETE * FROM tab01 WHERE CURRENT csr01 WITH CSD
DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR
问题
单选题For which of the following is a data warehouse optimized?()A
Backup and recoveryB
TransactionsC
SecurityD
Queries
问题
单选题Which of the following commands is used to retrieve database names from the local catalog for DRDA host databases on System i and System z?()A
LIST DB DIRECTORYB
LIST DCS DIRECTORYC
LIST NODE DIRECTORYD
LIST ACTIVE DATABASES
问题
单选题Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?()A
REVOKE ALL PRIVILEGES FROM USER tomB
REVOKE ALL ON EMPLOYEE FROM USER tomC
REVOKE EXECUTE ON EMPLOYEE FROM USER tomD
REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom