TE0-123 TE0-123 TE0-123 www.cert24.com www.cert24.com
Exam Number/Code : TE0-123
Exam Name : Teradata 12 Physical Design and Implementation exam
Version : Demo
Q1
Given the following information:
A company often reports last month’s total sales by channel code and also runs a call center with
high concurrency and quick response time requirements for looking up order history by order
number. Which indexing strategy addresses performance requirements for both access paths?
A. UPI onOrder.Order_Nbr and NUPI on Line.Order_Nbr
B. UPI onOrder.Order_Key and UPI on Line.Order_Key, Line.Line_Nbr
C. NUPI onOrder.Order_Key partitioned by Order.Order_Dt and NUPI on Line.Order_Key
D. NUPI onOrder.Order_Nbr partitioned by Order.Order_Dt, NUSI on Order.Order_Nbr, and NUPI
on Line.Order_Nbr
Answer: B
TE0-123 TE0-123 TE0-123
Q2
A table has been partitioned using the RANGE_N function and includes the NO RANGE and
UNKNOWN partitions. There are gaps in the ranges and the designer needs to add new
partitions to fill the gaps. The data in the NO RANGE partitions must be checked against the new
partitions.
Which procedure should be used?
A. Create another table with the new partition definition, then submit an INSERT SELECT
statement to populate the new table.
B. Create another table with the new partition definition, thenextract the data from the NO
RANGE and UNKNOWN partitions and import the data into the new table.
C. Submit an ALTER TABLE statement to add the new partitions, extract the data from the NO
RANGE and UNKNOWN partitions, and import the data into the existing table.
D. Submit an ALTER TABLE statement to add the new partitions, then data from the NO RANGE
and UNKNOWN partitions will automatically be checked against the added partitions.
Answer: C
TE0-123 TE0-123 TE0-123
Q3
Given the following table1 containing 10 million rows:
Which issues occur after this statement is run and how can it be fixed?
A. No issues, table2 contains the same rows as table1.
B. table2 is skewed. Specifying an index on column_2 will fix it.
C. table2 is skewed. Specifying a primary index on column_1 will fix it.
D. table2 is skewed. Specifying a primary index on column_2 will fix it.
Answer: C
TE0-123 TE0-123 TE0-123
Q4
Which two statements are true about UPIs? (Choose two.)
A. They must be defined as NOT NULL.
B. The database can perform partial-value searches on them.
C. They may be a referenced column in a Referential Integrity constraint.
D. The Optimizer can derive demographical information even without collected statistics.
Answer: B,D
Q5
Given the following table definition:
Which two statements are true about inserts into this table? (Choose two.)
A. All duplicate rows from an INSERT SELECT are written to an error table.
B. All duplicate rows from an INSERT SELECT are discarded and the transaction does not fail.
C. For a clone of this table, the same row inserted into each table will share the samedatablock.
D. The second of these two inserts will fail:
INSERT T1 (1, 2);
Answer: A,B
Q6
Which action will help conserve disk space?
A. Set permanent space limits for each table that is created.
B. Specify a limit on spool space for users in their profile.
C. Use a low number for the Cylinders saved forPERM setting.
D. Use theDBQL.LogSQL table instead of the DBQL.LogSummary table.
Answer: C
TE0-123 TE0-123 TE0-123
