最新DB2 A2090-730考試題庫，IBM A2090-730課程的擬真試題下載

問題1
Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?

A. Stored Procedure Builder Security

B. Developer Workbench

C. Control Center

D. Development Center

正確答案: B

問題2
Which of the following is a feature of a unit of work?

A. It begins when the application connects to the data server.

B. It applies to a single data server.

C. It is a recoverable sequence of operations.

D. Its value can be queried from the system catalog tables.

正確答案: C

問題3
Which of the following is NOT a characteristic of a unique index?

A. A unique index can only be created for a non-nullable column

B. Each column in a base table can only participate in one uniqueindex, regardless of how the columns are grouped (the same column cannot be used in multiple unique indexes)

C. In order for an index to be used to support a unique constraint, it must have been defined with the UNIQUE attribute

D. A unique index cannot be created for a populated table if the key column specified contains more than one NULL value

正確答案: A

問題4
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 id,firstname, lastname FROM TABLE(EMPLIST()) AS t

B. SELECTTABLE(EMPLIST()) AS t FROM EMPLOYEE

C. SELECTTABLE(EMPLIST()) FROM EMPLOYEE

D. SELECTEMPLIST(id, firstname, lastname) FROM EMPLOYEE

正確答案: A

問題5
Given the following tables:
YEAR_2006
EMPID NAME
1 Jagger, Mick 2 Richards, Keith 3 Wood, Ronnie 4 Watts, Charlie 5 Jones, Darryl 6 Leavell, Chuck
YEAR_1962
EMPID NAME
1 Jagger, Mick 2 Richards, Keith 3 Jones, Brian 4 Wyman, Bill 5 Watts, Charlie 6 Stewart, Ian
If the following SQL statement is executed, how many rows will be returned?
SELECT name FROM year_2007 UNION ALL SELECT name FROM year_1962

A. 12

B. 9

C. 10

D. 6

正確答案: A

問題6
Which of the following is an accurate statement about packages?

A. Packages contain control structures that are considered the bound form for SQL statements

B. Packages provide a logical grouping of database objects.

C. Packages may be used during query optimization to improve the performance for a subset of SELECT queries

D. Packages describe the objects in a DB2 database and their relationship to each other

正確答案: A

問題7
How should the following UDF be invoked in order to convert US currency values stored in the EXPENSES table into Canadian currency?
CREATE FUNCTION getratews11 ( country1 VARCHAR(100), country2 VARCHAR(100) ) RETURNS DOUBLE LANGUAGE SQL CONTAINS SQL EXTERNAL ACTION NOT DETERMINISTIC BEGIN ... END

A. CALLgetratews11('USA','CANADA')

B. CALLexpenses.getratews11('USA','CANADA')

C. SELECT * FROMTABLE(getratews11('USA','CANADA')) AS convert_currency

D. SELECTgetratews11('USA','CANADA') FROM expenses

正確答案: D

問題8
Which of the following is a typical data warehouse query?

A. What is this customer's 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?

正確答案: D

問題9
Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?

A. When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.

B. When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement.

C. DB2 will no longer allow updating the value of IDCOL1 in TABLE1.

D. When inserting a row in TABLE2, DB2 will only allow foreign values forIDCOL2, that is values which do not exist in IDCOL1.

正確答案: A

問題10
If the following SQL statements are executed in the order shown:
CREATE TABLE orders (order_num INTEGER NOT NULL, buyer_name VARCHAR(35), amount NUMERIC(5,2));
CREATE UNIQUE INDEX idx_orderno ON orders (order_num);
Which of the following describes the resulting behavior?

A. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows should be displayed in order of increasing ORDER_NUM values

B. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows will be displayed in no particular order

C. Every ORDER_NUM value entered must be unique; no other index can be created for the ORDERS table that reference the ORDER_NUM column

D. Duplicate ORDER_NUM values are allowed; no other index can be created for the ORDERS table that reference the ORDER_NUM column

正確答案: A

問題11
The following SQL statement:
DELETE FROM tab1 WHERE CURRENT OF csr1 WITH RR Is used to perform which type of delete operation?

A. Positioned

B. Searched

C. Dynamic

D. Embedded

正確答案: A

問題12
If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?

A. Decrease the lock timeout value for both applications, thereby causing a lock timeout situation.

B. Rollback the transaction in one of the two applications.

C. Rollback the transaction in both applications.

D. Send a message to let the administrator know of the situation and decide which application or applications should be terminated.

正確答案: B

先試後買

購買之前，你可以先嘗試下載一個試用版本。目前我們只提供PDF版本的試用DEMO，軟件版本只提供截圖。

專業認證

品質保證

輕松通過

Try Before Buy

最新的真實試題

相關鏈接

聯繫我們