SUN certification cert down

Exam Number/Code: nr0-012
Exam Name: Teradata Physical Implementation v2r5 Exam
Questions and Answers: 112 Q&As
Price: $125.00
Update Time: 2009-7-1
NCR Teradata NR0-012 exam
Title    :  Teradata Physical Implementation v2r5 Exam
Version :  Demo
1. What happens to a submitted query when a deadlock occurs?
A.Oldest query is aborted.
B.Youngest query is aborted.
C.Query waits for deadlock to resolve.
D.Dispatcher identifies which query to hold and waits for completion of deadlocking query.
Answer: B
2. Which statement is true of join indexes?
A.They can be processed using MultiLoad.
B.They can be used to define Full Outer Joins.
C.They can be assigned a different primary index from the base table.
D.They can be used on a table with triggers and Referential Integrity constraints.
Answer: C
3. Which three join methods require spool files? (Choose three.)
A.Merge Join
B.Nested Join
C.Product Join
D.Exclusion Merge Join
Answer: ACD
4. Which two statements about parallel steps are true? (Choose two.)
A.They are steps whose output may be used in a later statement.
B.They are sequentially numbered steps that may execute simultaneously.
C.They represent combined identical steps for two or more SQL statements within the request parcel.
D.They are seen in the creation of a spool file, which is subsequently used in more than one processing step.
Answer: AB
5. Which two definitions are required on the referenced columns when implementing Referential Integrity? (Choose two.)
A.Unique
B.Nullable
C.Indexed
D.Not Null
Answer: AD
6. During which phase of modeling design would a Partitioned Primary Index be defined?
A.Logical Data Modeling
B.Physical Data Modeling
C.Entity-Relationship Modeling
D.Business Information Modeling
Answer: B
7. Which three are data demographic elements? (Choose three.)
A.number of nulls
B.number of constraints
C.number of distinct values
D.number of rows per value
Answer: ACD
Download NR0-012 demo ,it is a free exam in testinside.