CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. TeraData
  5. TE0-122

Free TE0-122 Exam Braindumps (page: 4)

Page 3 of 38
PDF with 140 Questions

Which three types of user-defined functions does Teradata support? (Choose three.)

  1. Table
  2. Local
  3. Scalar
  4. Global
  5. Aggregate

Answer(s): B,D,E



A SELECT query uses the RANK() OVER (ORDER BY batting_avg DESC) syntax to produce a ranking of baseball players. The top ten baseball players are being ranked based on their batting averages. In the resulting output of the query there will be ten rows. There is a two-way tie for the second position and a three-way tie for the last three positions.
What will be the ranking number of the player in the final row?

  1. 7
  2. 8
  3. 9
  4. 10

Answer(s): D



A requirement exists to perform upsert processing against a partitioned table. You choose to execute a MERGE INTO instead of a UPDATE ELSE INSERT statement.
Which three restrictions on the UPDATE ELSE INSERT statement make the MERGE INTO statement a better choice? (Choose three.)

  1. The target table may be defined with multilevel partitioning.
  2. UPDATE portion may not modify any of the partitioning columns.
  3. All partitioning columns need to be in the UPDATE's WHERE clause.
  4. INSERT portion must specify the same partition as the UPDATE portion.

Answer(s): A,B,C



What is a restriction on a macro?

  1. A DDL statement in a macro must be the first statement in the macro.
  2. A DDL statement in a macro must be the only statement in the macro.
  3. A DDL statement in a Multi-statement macro must be the last statement in the macro.
  4. A DDL statement in a macro must be followed by an END TRANSACTION or COMMIT statement.

Answer(s): C






Post your Comments and Discuss TeraData TE0-122 exam with other Community members:

TE0-122 Discussions & Posts