TE0-122 12 Teradata SQL Certified Practice Exam

Description

Sample Questions

Q) Companies want a consistent ranking of all the employee’s salary. They do not want employees with the same salary data the same rank number. In the ordered analytic function should be used?

a) RANK

b) quantize

c) ROW_NUMBER

d) PERCENT_RANK

e) None

Q) What are the three types of user-defined functions makes support Tera? (Choose three.)

a) Diagram

b) Local

c) scalar

d) Global

e) aggregate

Q) The company wants to extract statistical information on wages from the total sample of employees. He wants to create 10 sections of wages, with $ 0 as the lower limit and $ 1 million as the upper limit. In the ordered analytic function should be used?

a) RANK

b) quantize

c) SAMPLE_ID

d) WIDTH_BUCKET

e) None

Which attributes the function returns information about how named expression shown?

a) A TYPE

b) FORMAT

c) SHOW

d) STANDARD

e) None