本文发表在 rolia.net 枫下论坛1) EMPLOYEE
emp_num emp_name dept
1 Adams 1
2 Jones 1
3 Smith 2
4 Williams 1


DEPT
dept_id dept_name
1 Planning
1 Support

and the statement:

ALTER TABLE employee
ADD FOREIGN KEY (dept) REFERENCES (dept_id)
ON DELETE CASCADE

How many units of work will be needed to process this statement:

DELETE FROM dept WHERE dept_id=1

a) 0

b) 1

c) 2

d) 3

e) 4

f) 6

2)How many indexes will be created by the following statement?
Create table mytab
(
Col1 int not null primary key,
Col2 char(64),
Col3 char(32),
Col4 int not null,
constraint c4 unique (Col4,Col1)
)

a) 0

b) 1

c) 2

d) 3

e) 4

3)
Which of the following CANNOT have an autocommit setting?
a) Embedded SQL

b) The Command Center

c) The Command Line Processor

d) The DB2 Call Level Interface

4) Which of the following processes is NOT performed by DB2 Warehouse Manager?

a) Query

b) Loading

c) Extraction

d) Transformation

5) If, for a given table, the Control Center does not show the choice Generate DDL, which of the following describes the reason?
a) The table is a system object.

b) The table is a summary table.

c) The table is in LOAD PENDING.

d) The table is a replicated table.

e) The table was created by a different user.更多精彩文章及讨论，请光临枫下论坛 rolia.net