IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A
SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
Answer Posted / ram
Primary key
============
1. A table should have only one primary key
2. More than one column can consist of a primary key – upto
64 columns
3. Can not be NULL values (missing values)
4. Should be unique values (no duplicate value)
Foreign key
============
1. A table may have zero or more than that upto 32 keys
2. More than one column can consist a primary key – upto 64
columns
3. Can have NULL values
4. Can have duplicate values
5. There should be a corresponding primary key in the
parent table to enforce referential integrity for a foreign
key
Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
What do high confidence, low confidence and no confidence mean in explain plan?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
In Teradata, what is the significance of UPSERT command?
What is spool space?
List the logical and conditional operators that are used with teradata along with their meanings?
What are the newly developed features of Teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
In Teradata, how do we Generate Sequence?
What exactly do you know about catching in teradata?
Explain fastload in teradata?
Explain the term 'database' related to relational database management system?
What are the different softwares used with their functions in teradata?
What is the use of virtual processor connectivity in teradata?
Explain the meaning of Amp?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?