0 Get prepared for the Certifications with the Teradata Quiz Welcome to the 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. Which of the following statements concerning PEs are accurate? The Dispatcher receives steps from the Parser and transmits them to the AMPs Session Control is responsible for load balancing across the BYNET The Optimizer develops the least expensive plan to return the response set The Parser checks statements for proper syntax and evaluates them semantically2. After an UPDATE statement is running for more than 1 hour you cancel it. As a result a rollback begins. Can it be stopped? Yes No3. Given a NUSI on columns {A,B} and the following SQL statement: SELECT * FROM WHERE A=1 AND B=1 AND C=1. Can the Optimizer use the NUSI (given strong selectivity)? Yes No4. 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. What kind of Optimizer is used in Teradata? Cost Based Rule Based6. Is "SELECT DATE;" and "SELECT DATE FROM (SELECT NULL AS x) t01;" delivering the same result? Yes No7. Which of the following statements are true concerning Partitioned Primary indexes? To store rows using PPI you specify partitioning in the CREATE TABLE statement They can reduce the number of rows processed by using partition elimination PPI is beneficial in queries specifying range constraints PPI is used to enhance performance against small tables8. To determine space requirements for NUSIs, what are factors that is utilized? Fallback Number of NULL values Number of nodes in the system Cardinality Index value size9. How many presence bits of the first presence byte can be used to store information about NULL values? 8 7 010. Do NOPI tables have a ROWID? Yes NoBe sure to click "Submit Quiz" to see your results (click only once, the rating process may need a couple of seconds)!