TE0-123 Teradata Physical Design Implement Practice Exam

Sample Questions

Q) A table has been partitioned using the RANGE_N function and includes the NO GAMMA and unknown walls. There are gaps in the ranges and the designer needs to add new partitions to fill the gaps. The data in no band partitions should be checked against the new partitions. What procedure should be used?

a) Create another table with the new definition of partition, then send INSERT SELECT statement to populate the new table.

b) Create another table with the new definition of partition, then extract the data from the NO RANGE and unknown partitions and import the data into the new table.

c) Send an ALTER TABLE statement to add new partitions, extract data from NO RANGE and unknown partitions, and import the data into the existing table.

d) Send an ALTER TABLE statement to add new partitions, then the data of NO RANGE and unknown partitions will be automatically checked against added partitions.

Q) Which two statements are true about Upis? (Pick one.)

a) They must be defined as NOT NULL.

b) The database can perform a partial value of research on them.

c) They may be a reference column in a referential integrity constraint

d) The optimizer can derive demographic information even without statistics collected.

Q) What action will help to conserve disk space?

a) Set permanent space limits for each table that is created.

b) Specify a spool space limit for users in their profile.

c) Use a lower number to the cylinders saved forPERM setting.

d) Table of theDBQL.LogSQL uses in place of DBQL.LogSummary table.

Q) An application is brought on Teradata that stores and calculates metrics using a variety of large integers. Both integers 128 bits and 256 bits are needed to capture the results of complex calculations. What kind of Teradata data should be used for these large integers?

a) UDT

b) BIGINT

c) VARBYTE

d) WHOLE NUMBER

Q) The following repositories must be created on a system - a repository that contains the retail sales data - a file containing the inventory data - views repository participation for each - a repository share stored procedure (includes some dynamic SQL procedures) What They must be implemented as a user with the allocated space?

a) views

b) the retail sales data

c) inventory data

d) procedure storage