Interested to Buy Any Domain ? << Click Here >> for more details...
what is referential constraints?how do you implement RI in
teradata?
- 2 Answers
- 7161 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / tdguy
Referential Integrity is based upon how Primary and Foreign
keys are defined. Because of this rule, a referenced column
must be a Primary Key or must be Unique and Not Null. Using
create or alter statement, FK can be created.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
What is teradata? Also, list out some of the primary characteristics of teradata.
Which Teradata concept allows more than one model generation?
Explain the term 'row' related to relational database management system?
what are the file sizes in your project?
I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.
How do you see a ddl for an existing table?
what is sysdba and sysdbc ? which has high priority ?
What are some primary characteristics of teradata?
How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????
What is the difference between global temporary tables and volatile temporary tables?
What is the purpose of joins in teradata and what are the available join types?
What are the different softwares used with their functions in teradata?
Teradata 
