Free Teradata Random Questions and Answers — Questions and Answers
Question 1: What part is in charge of input conversion?
- CLI
- AMP
- PE (Correct answer)
- BYNET
Correct answer: PE
The Parsing Engine (PE) is responsible for input conversion—it receives SQL requests, parses them, and handles data type conversion before dispatching work. The AMP manages data storage and retrieval, BYNET handles inter-component communication, and CLI is the client interface, so none of those performs input conversion.
Question 2: What Operating System is capable of running Teradata?
- All of the above (Correct answer)
- Windows
- Linux
- Z
Correct answer: All of the above
Explanation: <br> Teradata is a database management system that can run on various operating systems. It supports multiple platforms including Windows, Linux, and z/OS (IBM mainframe operating system). Therefore, the correct answer is "All of the above." <br> <br> Teradata provides a consistent database experience across all these platforms, allowing customers to choose the operating system that best suits their needs. The choice of operating system may depend on factors such as performance, scalability, reliability, security, and cost. Teradata also provides client software for Windows and Linux that allows users to connect to the Teradata database.
Question 3: Which will only ever return one Row?
- None
- UPI
- USI
- Both (Correct answer)
Correct answer: Both
Explanation: <br> Both UPI (Unique Primary Index) and USI (Unique Secondary Index) can return at most one row for a given value.
Question 4: Because of _____, a uniqueness value is necessary to provide a unique Row ID.
- None of the above
- Duplicates values in NUPI
- Hash synonym
- Both Answers (Correct answer)
Correct answer: Both Answers
A uniqueness value is needed for the Row ID in both cases: duplicate values in a NUPI (Non-Unique Primary Index) and hash synonyms (different values that hash to the same value) can produce identical hash results, so Teradata adds a uniqueness value to distinguish the rows. Since both scenarios require it, 'Both Answers' is correct.
Question 5: A secondary index operation that is not unique is always a ____________.
- Three AMPs operation
- One AMP operation
- ALL AMPs operation (Correct answer)
- Five AMPs operation
Correct answer: ALL AMPs operation
Explanation: <br> A non-unique secondary index (NUSI) operation in Teradata is always an ALL AMPs operation.
Question 6: Which of the following features of a partitioned table over a nonpartitioned table is a benefit? <br> I) There are fast deletes of all the rows in a partition <br> II) Fewer AMPs are involved when accessing data <br> III) Range queries can be executed without a secondary index <br> IV) There is faster access of a single row via a primary index access
- II & IV
- I & III
- I & III
- I, II & III (Correct answer)
Correct answer: I, II & III
Explanation: <br> The correct answer is (I), (II), and (III). <br> <br> Partitioning is a technique used in Teradata to horizontally divide a large table into smaller, more manageable pieces called partitions. Each partition contains a subset of the rows in the table and is stored on one or more AMPs (Access Module Processors) in the system.
Question 7: Which of these statements regarding databases is true?
- Is an Active repository
- Require password
- None (Correct answer)
- Not empty even though objects are not created
Correct answer: None
None of the statements is true: a database is not inherently an 'active repository,' does not itself require a password, and is genuinely empty when no objects have been created. Because each option reflects a misconception about basic database behavior, 'None' is the correct answer.
Free Teradata Random Questions and Answers
What part is in charge of input conversion?