Killtest 分享NR0-012 题库.pdf

KillTest The safer , easier way to help you pass any IT exams. Exam : NR0-012 Title : Teradata Physical Implementation v2r5 Exam Version : DEMO 1 / 5 The safer , easier way to help you pass any IT exams. 1.Which join plan could make use of a primary index on each of two tables with matching Partitioned Primary Indexes? A.Merge B.Bitmap C.Product D.Exclusion Merge Correct:A 2.What are three functions performed by the Index Wizard? (Choose three.) A.automatically drops existing indexes based on the workload B.recommends adding indexes based on specified workloads C.recommends dropping the indexes that may not be necessary D.automatically creates DDL statements for recommended indexes E.recommends Partitioned Primary Indexes based on specified workloads Correct:B C D 3.Which three statements are true concerning join plans? (Choose three.) A.A Nested Join is only used when the user specifies a constant value in a WHERE clause. B.A Hash Join requires that the data from both tables be sorted before performing the join operation. C.A Merge Join requires that the data from the tables be sorted before performing the join operation. D.A Merge Join retrieves rows from two tables and requires them to be on the same AMP based on the row hash of the columns involved in the join. Correct:A C D 4.What defines whether parallel steps have been generated in an EXPLAIN output? A.the phrase we execute parallel steps on eac