Teradata Interview Questions and Answers

0
2075

This post contains mind boggling Teradata interview questions and answers which have been asked in various interviews. We hope these Teradata interview questions will enhance your database knowledge.

Try out these Teradata Interview Questions

  • Partition primary index is defined during which phase of Modeling Design?
  1. Business Information Modeling
  2. Entity Relationship Modeling
  3. Physical data Modeling
  4. Logical data Modeling

Answer3

  • The Optimizer can estimate cost more accurately and build more aggressive join plans when collect stats are available. What Expression do you look for in an EXPLAIN to suggest that Statistics are absent?
  1. No Confidence
  2. High Confidence
  3. Statistics are needed
  4. A table is duplicated on all AMPS

Answer 1

  • Compression is used on which of the following Column?
  1. Identity
  2. Variable Length
  3. Primary Index
  4. Date

Answer 4

  • Which Join Plan makes use of primary index on each of the two tables with matching partitioned primary index?
  1. Merge
  2. Bitmap
  3. Product
  4. Exclusion Merge

Answer 1

  • Which one is not a Load utility of Teradata?
  1. FastLoad
  2. FullLoad
  3. MultiLoad
  4. TPump

Answer 2

  • Compression of table can be specified in which of the following Column?
  1. Volatile
  2. Multiset
  3. Derived
  4. Global Temporary

Answer – 2

  • Suppose we have a non equality Join condition, then Which Join type will be used?
  1. Merge join
  2. Hash Join
  3. Product Join
  4. Nested Join

Answer 3

  • Suppose Emp_no is the Primary index for both Employee and Employee_Phone table. For Following query which join plan would be seen in EXPLAIN output ?
    Select * From Emploee, Emploee_Phone Where Emploee.Emp_no=Emploee_phone.Emp_no;
  1. Merge Join
  2. Hash Join
  3. Product Join
  4. Nested join

Answer 1

  • What is False about FASTLOAD?
  1. FastLoad loads one table at a time.
  2. FastLoad allow duplicate data to load.
  3. For FastLoad Table should be Empty.
  4. FastLoad loads data in 2 Phase.

Answer 2

  • During FASTLOAD, How many Error tables used?
  1. 1
  2. 2
  3. 3
  4. 4

Answer 2

  • Which of the following Function is used to remove leading and trailing Pad characters?
  1. Truncate
  2. Cut
  3. Suppress
  4. Trim

Answer 4

  • Which Clause is more efficient to use in a query when there are more number of duplicates for a particular column in a table?
  1. Distinct
  2. Group By
  3. Coalesce
  4. Max

Answer 2

  • Which of the following is FALSE about Primary Index?
  1. Contains NULL
  2. Values can be Updated
  3. Always be unique
  4. None of the Above

Answer 3

  • Which is not a Locking type in Teradata?
  1. Write
  2. Read
  3. Update
  4. Access

Answer 3

  • Which option describes the Teradata architecture?
  1. Shared Everything
  2. Shared Nothing
  3. Dual Redundant
  4. All

Answer 2

  • Full form of SMTP?
  1. System Multi Processors
  2. Symmetric Multi Processors
  3. Symmetric Massive Processors
  4. Successive Multi Processors

Answer 2

  • Which Compression method is used by Teradata?
  1. Field Level
  2. Row Level
  3. Block Level
  4. Cylinder Level

Answer 1

We hope above listed Teradata Interview Questions and Answers enlighten you with some good information. If you have any concern with the questions or answers listed over here, then kindly comment below and we will try to resolve them immediately. We will post more Teradata Interview Questions and Answers in our future posts, So enjoy Reading and Sharing information.

VN:F [1.9.22_1171]
Your Feedback hels to Improve
Rating: 8.8/10 (10 votes cast)
VN:F [1.9.22_1171]
Rating: +6 (from 6 votes)
Teradata Interview Questions and Answers, 8.8 out of 10 based on 10 ratings