TE0-123 Teradata Physical Design Implement Practice Exam

Sample Questions

Q) Table divided via RANGE_N function and includes NO RANGE and unknown partitions. There are gaps in the range and the designer must add new sections to fill in the gaps. The information contained in NO RANGE sections should be checked against the new sections. What procedure should be used?

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

b) Create another table with a new definition of the partition, and then extract data from non-range and unknown partitions and import data into the new table.

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

d) Send the statement ALTER TABLE, to add new sections, when the data from the NO RANGE and unknown partitions automatically checked against additional partitions.

e) None

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

a) They must be defined as NOT NULL.

b) The database can search for part of the cost to them.

c) They may be a reference to the column in the referential integrity constraints

d) The optimizer may receive demographic data even without statistical data collected.

Q) What measures will help save disk space?

a) Install permanent restrictions for each table space is created.

b) Set a limit for the space coils for users in their profiles.

c) Use a low number of cylinders stored forPERM settings.

d) Use theDBQL.LogSQL DBQL.LogSummary table instead of the table.

e) None

Q) Formentera app ported that store and calculate statistics using different large integers. And 128-bit and 256-bit integer necessary to capture the results of complex calculations. Tera What data should be used for such large numbers?

a) UDT

b) BIGINT

c) VARBYTE

d) INTEGER

e) None