General A Short Teradata Quiz for You By Roland Wenzlofsky - October 26, 2015 1 856 Facebook Twitter WhatsApp Linkedin Here is a short Teradata Quiz for you. I hope you like it. Welcome to the Big Teradata Quiz. Each time you take the quiz, a different set of questions will be asked. We are adding new questions on a regular base. At the end of the quiz, we will show you the correct answers, your score and the average score of all people. Enter your name and press "NEXT" to start the quiz Name Email 1. If you cancel an ALTER TABLE statement, will there be a rollback? Yes No2. Before selecting the Primary Index, what do you need to know so that even distribution is ensured? number of rows in the table columns that define uniqueness data demographics of new data from load processes other tables that will be involved in a join3. What is the value of the first presence bit of the first presence byte? 0 14. You execution plan shows high confidence for a retrieve step. What does this mean? The Optimizer will use a more aggressive plan The related statistics are not stale The estimated number of rows will match the selected number of rows5. Which of the following join types are related to PPI tables? Product Join with DPE Rowkey Based Merge Join Hash Join Nested Join Sliding Window Merge Join6. Which of the following is not a TASM request target? Databases name Table name View name Stored Procedure Application UDF Step Row Count7. Which of the following are conditions for changing Partition definitions using an ALTER TABLE statement? Is populated and the ALTER TABLE statements are adding partitions to either the beginning or the end of the table Is defined with a NUPI Is empty and not in use Is populated, but no updates are running8. Would you consider to use block level compression (BLC) in order to reduce CPU usage? Yes No9. Of the following, which are true statements about permanent space? Macros require permanent space Tables and views are defined in permanent space All databases have a defined upper limit of permanent space Permanent space is not physically allocated at object definition time10. Which of the following load method is not considered bulk loading? Fastload Multiload BTEQ Import TPumpBe sure to click "Submit Quiz" to see your results (click only once, the rating process may need a couple of seconds)! Our Reader Score [Total: 16 Average: 3.6/5] A Short Teradata Quiz for You written by Roland Wenzlofsky on October 26, 2015 average rating 3.6/5 - 16 user ratings RELATED ARTICLESMORE FROM AUTHOR Teradata – An Introduction to TPump Teradata Quiz for Android Engaging a Teradata Tuning Specialist is not a Luxury 7 Essential General Teradata Tuning Tips Let’s Solve Teradata Problems Together! 1 COMMENT 1)Which of the following is not stored in a sub table? Answer Provided: Join Index (JI).Row Partitioned Table. Correct Answer: Row Partitioned Table. comment: I am aware only the Secondary indexes in Teradata creates sub-table, but for the above question, why the JI stored in sub table, does this question meant that JI allows creation of SI over the JI or does it meant Join Index (JI) stores its join results in perm space. 2) Which of these technical join types are available on Teradata? Answer Provided: Left Outer Join. Correct Answer: Hash Join.Merge Join.Sliding Window Merge Join.Product Join. Comment : Hash Join, Merge Join, Sliding Window Merge Join and Product Join are the join strategies determined by the optimiser based on the joining tables data distribution, so I have answered Left outer join is the Join Type, a user can decide based on his business need. 3) Are tables without Primary Index (NOPI) always distributed evenly across all AMPs? Answer Provided: Yes Correct Answer: No Comment: Could you explain me why the NOPI tables not always evenly distributed across all AMPs. Kindly advice me how to approach the above questions. Thanks, Reply LEAVE A REPLY Cancel reply Please enter your comment! Please enter your name here You have entered an incorrect email address! Please enter your email address here Save my name, email, and website in this browser for the next time I comment.