TOP 100 RealTime Teradata Multiple choice Questions and Answers pdf download

REAL TIME TERADATA Multiple Choice Questions and Answers

1.Teradata Has been called a ---------------- architecture.
A. Shared Nothing
B. Anything  Goes.
c. Shared Nothing.
D.Dual Redundent.
ANS::A

2. What are attributes of the teradata database.
A. The Optimizer is parllel aware
B. only runs on UNIX.
C. Data distrubution is Automatic.
D.Designed around online Transaction Processing.
ANS:: ACD.

3. What does linear Scalability provide?
A.Protection on Investment for application Development.
B.Unconditional,quick response times for data quires.
C. Increase workload without decreased through put.
D. Consistent results with inconsistent data.
ANS:: A,C.

4. Which two Statements are true concerning the benefits of a business modal?
A.  The Data modal is consistent  no mater how much data.
B.  Data is organized by what it represents.
C.  Data never Skewed.
D.  Allows DBA’s to distribute data properly.

5.  Whoose the attributes which best describe OLTP?
A.  Based on transational set theory.
B.  Exceptional for processing ad hoc quires.Small number of rows for transaction.
C.  Small number of rows for transaction.
D. Transaction tipically occur in seconds instead of minutes.
ANS:: C,D.

6. What are the following object required for Teradata Database-Prem space?.
A. Tables & Stored Procedure
B. Tables & Views
C. Macros & Triggers
D. Views & Stored Procedures
Ans: A

7. Global Temporary Tables are stored in the TD are
A. Perm Space
B. Spool Space
C. Temp Space
Ans: C

8. Terabytes represent
A. 10 power 15
B. 10 power 12
C. 10 power 18
D. 10 power 24
Ans: B

9. SMP Stands for
A. Symmetric Multi-processor
B. Symmetric Massive-Processor
C. System Multi-processor
D. Symmetric Multi-Processor
Ans: A

10. Total Number of nodes suppport by BYNET are
A. 510 SMP Nodes
B. 512 SMP Nodes
C. 513 SMP Nodes
D. 514 SMP Nodes
Ans: B

11. The definition of TPump is continuous update of tables; performs insert, update, and delete operations or a combination of those operations on multiple tables using the same source feed.
A. true
B. false
Ans: A

12. Teradata Database facilities for software falut tolerance on
A. Vproc Migration & Fallback tables
B. AMP Clusters & Journaling
C. Backup/Archive/Restore
D. Table Rebuild Utility
E. All of the above
F. None of the above
Ans: E

13. Success/Failure/Error responses from Teradata are received by
A. Request Parcel
B. Data parcel
C. Response Parcel
Ans: C

14. Explain command displays the execution plan of the query chosen by the Teradata Optimizer
A. False
B. True
Ans:B

15. HASHROW funtions is
A. Returns the hash bucket number that corresponds to a specified row hash value.
B. Returns the hexadecimal row hash value for an expression
C. Returns the AMP number of the primary AMP corresponding to the specified hash bucket number.
D. Returns the identification number of the fallback AMP corresponding to the specified hash bucket.
Ans:B

16. Teradata has been called a  ------- architecture.
A. Shared Nothing
B. Anything Goes
C. Shared Everything
D. Dual Redundant
Ans: A

17. "Hello Chris" is a statement that makes Chris feel ________.
A. hello
B. Possible
C. Happy
D. Sad
E. Pleased
Ans: B

18. What type of company is Teradata?
a. Public
b. Privately held
c. Private, LLC.
d. Subsidiary of Vodafone Plc
Ans: A

19. Where is Teradata?
A. United States
B. Illinois
C. Colorado
D. Arkansas
Ans: A

20. Who of the following is a key person at Teradata?
A. Warren East
B. Bob Fair, Executive Vice President, Global Sales and Services
C. Girlie M. Aragon,
D. Ola Forberg
Ans: B