최신 DB2 C2090-730 무료샘플문제:

1. 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 (15, 'Smith', 5, '01/22/2004', 92500.00)
B) INSERT INTO employee VALUES (20, 'Smith', 5, NULL, 65000.00)
C) INSERT INTO employee VALUES (DEFAULT, 'Smith', 10, '11/18/2004', 60250.00)
D) INSERT INTO employee VALUES (DEFAULT, 'Smith', 2, '10/07/2002', 80250.00)

2. Which of the following actions will NOT cause a trigger to be fired?

A) INSERT
B) ALTER
C) UPDATE
D) DELETE

3. Given the following statements:
CREATE TABLE tab1 (c1 INTEGER, c2 CHAR(5));
CREATE VIEW view1 AS SELECT c1, c2 FROM tab1 WHERE c1 < 100;
CREATE VIEW view2 AS SELECT c1, c2 FROM view1
WITH CASCADED CHECK OPTION;
Which of the following INSERT statements will fail to execute?

A) INSERT INTO view2VALUES(150, 'abc')
B) INSERT INTO view2VALUES(50, 'abc')
C) INSERT INTO view1VALUES(100, 'abc')
D) INSERT INTO view1 VALUES (100, 'abc')

4. Given the following two tables:
NAMES
NAME NUMBER
Wayne Gretzky 99 Jaromir Jagr 68 Bobby Orr 4 Bobby Hull 23 Brett Hull 16 Mario Lemieux 66 Mark Messier 11
POINTS
NAME POINTS
Wayne Gretzky 244 Jaromir Jagr 168 Bobby Orr 129 Brett Hull 121 Mario Lemieux 189 Joe Sakic 94
Which of the following statements will display the player name, number, and points for all players that have scored points?

A) SELECT p.name,n.number, p.points FROM names n RIGHT OUTER JOIN points p ON n.name = p.name
B) SELECT p.name,n.number, p.points FROM names n FULL OUTER JOIN points p ON n.name = p.name
C) SELECT p.name,n.number, p.points FROM names n LEFT OUTER JOIN points p ON n.name = p.name
D) SELECT p.name,n.number, p.points FROM names n INNER JOIN points p ON n.name = p.name

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 (15, 'Smith', 5, '01/22/2004', 92500.00)
B) INSERT INTO employee VALUES (20, 'Smith', 5, NULL, 65000.00)
C) INSERT INTO employee VALUES (DEFAULT, 'Smith', 10, '11/18/2004', 60250.00)
D) INSERT INTO employee VALUES (DEFAULT, 'Smith', 2, '10/07/2002', 80250.00)

질문과 대답: