Interested to Buy Any Domain ? << Click Here >> for more details...
what is referential constraints?how do you implement RI in
teradata?
- 2 Answers
- 7018 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
Referential constraints define a relationship between two or
more attributes between two tables. RI can be implemented
between two tables using FOREIGN KEY option in create table.
FOREIGN KEY (b) REFERENCES WITH NO CHECK OPTION tb1(a));
CHECK or NO CHECK option can be used.
CHECK option - batch RI constraint.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What exactly do you know about catching in teradata?
What is database exceptions in teradata?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is oltp?
Explain Teradata performance tuning and optimization?
Explain BYNET.
What is the use of stored procedures in teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What are the components provided on node?
What is the maximum number of dml can be coded in a multiload script?
What is basic teradata query language?
Explain the term 'columns' related to relational database management system?
