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

IBM A2090-730 試験概要:

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

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

1. Which of the following actions may cause a trigger to be fired?

A) ROLLBACK
B) DELETE
C) DROP
D) ALTER

2. Which of the following tools can be used to schedule a backup operation that is to be run every Sunday evening?

A) Command Line Processor
B) Activity Monitor
C) Task Center
D) Journal

3. An index named EMPID_X exists for a table named EMPLOYEE. Which of the following will allow user USER1 to drop the EMPID_X index?

A) GRANT DELETE ON INDEXempid_x TO user1
B) GRANT CONTROL ON INDEXempid_x TO user1
C) GRANT INDEX ON TABLE employee TO user1
D) GRANT DROP ON INDEXempid_x TO user1

4. Which of the following DB2 data types can be used to store 1000 MB of single-byte character data?

A) BLOB
B) CLOB
C) GRAPHIC
D) DBCLOB

5. If the following statement is executed:
CREATE TABLE employee
(empid INT NOT NULL GENERATED BY DEFAULT
AS IDENTITY (START WITH 1, INCREMENT BY 5),
name VARCHAR(20),
dept INT CHECK (dept BETWEEN 1 AND 20),
hiredate DATE WITH DEFAULT CURRENT DATE,
salary DECIMAL(7,2),
PRIMARY KEY(empid),
CONSTRAINT cst1 CHECK (YEAR(hiredate) > 2006 OR
Salary > 60500));
Which of the following INSERT statements will fail?

A) INSERT INTO employee VALUES (DEFAULT, 'Smith', 10, '11/18/2004', 60250.00)
B) INSERT INTO employee VALUES (DEFAULT, 'Smith', 2, '10/07/2002', 80250.00)
C) INSERT INTO employee VALUES (20, 'Smith', 5, NULL, 65000.00)
D) INSERT INTO employee VALUES (15, 'Smith', 5, '01/22/2004', 92500.00)

質問と回答：