A. CREATE INDEX emp_idx ON employee (workdept);
CREATE INDEX dept_idx ON department (deptno);
B. CREATE INDEX emp_idx ON employee (workdept) CLUSTER;
CREATE INDEX dept_idx ON department (deptname, deptno);
C. CREATE INDEX emp_idx ON employee (workdept, lastname, job);
CREATE INDEX dept_idx ON department (deptname, deptno);
D. CREATE INDEX emp_idx ON employee (lastname, job, workdept) CLUSTER;
CREATE INDEX dept_idx ON department (deptname);
Answer: C
A table named SALES was created as follows:
Assuming all table spaces required already exist, which statement(s) must be executed to
add a new partition that already contains data for the first quarter of 2013 to the SALES
table and leave the table accessible?
A. ALTER TABLE sales ADD PARTITION part_2013q1
STARTING ('01/01/2013') ENDING ('03/31/2013') IN ts5;
B. ALTER TABLE sales ATTACH PARTITION part_2013q1
STARTING ('01/01/2013') ENDING ('03/31/2013')
FROM TABLE q12013_sales;
C. ALTER TABLE sales ADD PARTITION part_2013q1
STARTING ('01/01/2013') ENDING ('03/31/2013') IN ts5;
SET INTEGRITY FOR sales IMMEDIATE CHECKED;
D. ALTER TABLE sales ATTACH PARTITION part_2013q1
STARTING ('01/01/2013') ENDING ('03/31/2013')
FROM TABLE q12013_sales;
SET INTEGRITY FOR sales IMMEDIATE CHECKED;
Answer: D
Question No : 4 - (Topic 1)
Question No : 5 - (Topic 1)
IBM C2090-614 : Practice Test
4
http://www.maitiku.com QQ:860424807
评论0