站内搜索
IBM(000-730) 问题列表
问题
单选题Which of the following is a typical data warehouse query?（）A
What is this customers address?B
Does this customer have any unpaid bills?C
What is the balance in this customers account?D
What 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?（）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.
问题
单选题If a unique constraint is defined on column COL1 of table TAB1, what are the characteristics of COL1?（）A
COL1 will accept NULL values and can be referenced in another table's foreign key specification.B
COL1 will not accept NULL values and cannot be referenced in another tables foreign key specification.C
COL1 will not accept NULL values and can be referenced in another tables foreign key specification.D
COL1 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?（）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.
问题
单选题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?（）A
UPDATE stock SET (status = NULL; quantity, price = 0) WHERE item LIKE S%B
UPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE item LIKE S%C
UPDATE stock SET status = NULL, SET quantity = 0, SET price = 0 WHERE item LIKE 'S%'D
UPDATE stock SET (status = NULL), (quantity = 0), (price = 0) WHERE item LIKE S%
问题
单选题Which of the following is the main feature of an OLTP application?（）A
Summarized queriesB
Granular transactionsC
Voluminous historical dataD
Heterogeneous data sources
问题
单选题Which of the following are types of routine objects?（）A
Package and functionB
Function and userexitC
Procedure and packageD
Function 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?（）A
SequenceB
Table FunctionC
Identity ColumnD
INSTEAD 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?（）A
SELECT * FROM tab1 INNER JOIN tab2 ON c1=cxB
SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cxC
SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cxD
SELECT * 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?（）A
GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrpB
GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1C
GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrpD
GRANT 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?（）A
ViewB
AliasC
TableD
Package
问题
单选题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
问题
单选题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?（）A
REVOKE DROP ON t1 FROM PUBLICB
REVOKE UPDATE ON t1 FROM PUBLICC
REVOKE DELETE ON t1 FROM PUBLICD
REVOKE CONTROL ON t1 FROM PUBLIC
问题
单选题Which of the following resources can be referenced in the LOCK statement?（）A
RowB
TableC
ColumnD
Table 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?（）A
Any row inserted or updated through view V1 must meet the condition that col4 1000.B
From 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.C
At 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.D
Any 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.