IBM C2090-614 - DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam
Page: 2 / 22
Total 108 questions
Question #6 (Topic: Topic 1)
Which statement about data type mappings is true in a federated system?
A. The Oracle DOUBLE data type maps to the DB2 type FLOAT by default.
B. Data types can be mapped in both directions between a remote and local data type.
C. Cast functions can be pushed down to remote servers even if a counterpart function does not exist there.
D. For relational data sources, the degree to which you can override existing data type mappings or create mappings is limited.
Answer: B
Question #7 (Topic: Topic 1)
A table named SALES was created as follows:
[IBM-C2090-614-6.0/IBM-C2090-614-5_2.png]
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?
[IBM-C2090-614-6.0/IBM-C2090-614-5_2.png]
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 #8 (Topic: Topic 1)
What must be done to convert an existing table into an Insert-Time-Clustered (ITC) table?
A. Call the ADMIN_MOVE_TABLE procedure.
B. Call the ADMIN_REVALIDATE_DB_OBJECTS procedure.
C. Issue a REORG TABLE statement with the ORGANIZE BY INSERT TIME option.
D. Issue an ALTER TABLE statement with the ORGANIZE BY INSERT TIME option.
Answer: A
Question #9 (Topic: Topic 1)
An auxiliary HADR standby database must use which HADR sync mode?
A. SYNC
B. ASYNC
C. NEARSYNC
D. SUPERASYNC
Answer: D
Question #10 (Topic: Topic 1)
Consider the following statement:
[IBM-C2090-614-6.0/IBM-C2090-614-6_2.png]
Which indexes should be created for optimal query performance?
[IBM-C2090-614-6.0/IBM-C2090-614-6_2.png]
Which indexes should be created for optimal query performance?
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
