Teradata Interview Questions
- What is BTEQ?
- What is explain in teradata?
- What is Fastload in Teradata?
- What do you mean by skew ness?
- How Indexing works in Teradata?
- What is Database Definition (DBD)?
- What is stored procedure in Teradata?
- What is Group by in Select statement?
- What is basic teradata query language?
- What is explaining and how does it work?
- What the default privileges which get assigned?
- How does indexing improve query performance?
- What are two examples of an OLTP environment?
- Which two statements are true about a foreign key?
- What is the difference between start schma and Fsldm?
- How many codd’s rules are satisfied by teradata database?
- How does Teradata avoid duplicate rows in the SET Tables?
- What is the new feature that came along with teradata V2R6?
- What are the enhanced features in Teradata V2R5 and V2R6?
- Does SDLC changes when you use Teradata instead of Oracle?
- Does Fastload support the use of mustiest and duplicates? Why?
- What is OLTP? How does teradata fit into the database requirements?
- What are the different error tables used during a mload job execution?
- Explain the advantages and disadvantages of a Hierarchical Database?
- What is the difference between Volatile and Global Temporary tables?
- What is the difference between the FSLDM and Star schema in teradata?
- What is a common data source for the central enterprise data warehouse?
- Which two can be implemented as a centrally located logical architecture?
- What is the difference between Multiload & Fastload interms of Performance?
- What is the difference between Global temporary tables and Volatile temporary tables?
- In which stage of Active Data warehousing do you have the assessments over the future data?
- How teradata makes sure that there are no duplicate rows being inserted when it?s a SET table?
- How will you go about optimizing the performance characteristics of the Teradata execution?
- What are the different phases involving in loading of the data when it comes to Fast Load and Multiload?
- In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?
- What is cliques? What is Vdisk and how it will communicate with physical data storage at the time of data retrieval through AMP?