最新のA2090-730問題集で試験を準備する

IBM A2090-730 試験概要:

IBM A2090-730 試験シラバストピック:

IBM Assessment: DB2 9 Family Fundamentals 認定 A2090-730 試験問題：

1. Given the following table:
CURRENT_EMPLOYEES
EMPID INTEGER NOT NULL NAME CHAR(20) SALARY DECIMAL(10,2) PAST_EMPLOYEES
EMPID INTEGER NOT NULL
NAME CHAR(20)
SALARY DECIMAL(10,2)
Assuming both tables contain data, which of the following statements will NOT successfully add
data to table CURRENT_EMPLOYEES?

A) INSERT INTOcurrent_employees (empid) VALUES (10)
B) INSERT INTOcurrent_employees (name, salary) VALUES (SELECT name, salary FROM past_employees WHERE empid = 20)
C) INSERT INTOcurrent_employees VALUES (10, 'JAGGER', 85000.00)
D) INSERT INTOcurrent_employees SELECT empid, name, salary FROM past_employees WHERE empid = 20

2. 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) 2
B) 14
C) 7
D) 9

3. Which of the following isolation levels will lock all rows scanned to build a result data set?

A) Cursor Stability
B) Uncommitted Read
C) Read Stability
D) Repeatable Read

4. Which of the following are all valid DB2 data types?

A) NUMERIC, TIMESTAMP, BYTE, FLOAT
B) LONG VARCHAR, SMALLINT, NUMBER, BLOB
C) DECIMAL, DATE, DBCLOB, INTERVAL
D) NUM, TIME, XML, DOUBLE

5. Application A wants to read a subset of rows from table TAB1 multiple times. Which of the following isolation levels should Application A use to prevent other users from making modifications and additions to table TAB1 that will affect the subset of rows read?

A) Cursor Stability
B) Uncommitted Read
C) Read Stability
D) Repeatable Read

質問と回答：