IBM(000-730) 题目列表
单选题Which of the following is a typical data warehouse query?（）AWhat is this customers address?BDoes this customer have any unpaid bills?CWhat is the balance in this customers account?DWhat are the total sales for each of the last 6 months?
单选题Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?（）AThe cursor is only protected from updates and deletes by concurrent applications.BThe row is only protected from positioned updates and deletes that reference another cursor of the same application.CThe cursor is protected from positioned updates and deletes that reference another cursor of a different application.DThe 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.
单选题If a unique constraint is defined on column COL1 of table TAB1, what are the characteristics of COL1?（）ACOL1 will accept NULL values and can be referenced in another table's foreign key specification.BCOL1 will not accept NULL values and cannot be referenced in another tables foreign key specification.CCOL1 will not accept NULL values and can be referenced in another tables foreign key specification.DCOL1 will accept NULL values and cannot be referenced in another tables foreign key specification.
单选题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?（）AApplication B will read the row.BApplications A and B will cause a deadlock situation.CApplication B will wait until application A releases the Update lock.DApplication A will be terminated so that application B can read the row.
单选题Given the following table definition: STOCK: item VARCHAR(30) status CHAR(1) quantity INT price DEC(7,2) If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero, which of the following statements would be used to update the STOCK table to indicate that all the items whose description begins with the letter "S" are out of stock?（）AUPDATE stock SET (status = NULL; quantity, price = 0) WHERE item LIKE S%BUPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE item LIKE S%CUPDATE stock SET status = NULL, SET quantity = 0, SET price = 0 WHERE item LIKE 'S%'DUPDATE stock SET (status = NULL), (quantity = 0), (price = 0) WHERE item LIKE S%
单选题Which of the following is the main feature of an OLTP application?（）ASummarized queriesBGranular transactionsCVoluminous historical dataDHeterogeneous data sources
单选题Which of the following are types of routine objects?（）APackage and functionBFunction and userexitCProcedure and packageDFunction and procedure
单选题A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet thisrequirement?（）ASequenceBTable FunctionCIdentity ColumnDINSTEAD OF Trigger
单选题Given the following two tables: TAB1 C1 C2 A 11 B 12 C 13 TAB2 CX CY A 21 C 22 D 23 The following results are desired: C1 C2 CX CY A 11 A 21 C 13 C 22 -- --D 23 Which of the following queries will yield the desired results?（）ASELECT * FROM tab1 INNER JOIN tab2 ON c1=cxBSELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cxCSELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cxDSELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx
单选题Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?（）AGRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrpBGRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1CGRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrpDGRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom
单选题Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?（）AViewBAliasCTableDPackage
单选题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（）A2B7C9D14
单选题Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?（）AREVOKE DROP ON t1 FROM PUBLICBREVOKE UPDATE ON t1 FROM PUBLICCREVOKE DELETE ON t1 FROM PUBLICDREVOKE CONTROL ON t1 FROM PUBLIC
单选题Which of the following resources can be referenced in the LOCK statement?（）ARowBTableCColumnDTable space
单选题A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3, col4 FROM t1 WHERE col4 1000 WITH CHECK OPTIONWhat is the effect of the CHECK OPTION clause?（）AAny row inserted or updated through view V1 must meet the condition that col4 1000.BFrom now on, any row inserted or updated in table T1 must meet the condition that col4 1000, but existing rows in the table are not checked.CAt view creation, DB2 will check the data in table T1, and if in any row doesn't meet the condition col4 1000, the view creation will be rejected.DAny row inserted or updated through view V1 must meet the condition that col4 1000 and no row in table T1 can be updated such that col4 = 1000, but new rows in the table can be inserted with col4 = 1000.