IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A
SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
- 10 Answers
- 15067 Views
- I also Faced
- E-Mail Answers
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
Highlight the differences between Primary Key and Primary Index.
Why managing the data is important?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is multi insert?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What are the available primary index types?
Why do you get spool space errors? How do trouble-shoot them?
Explain the parallel data extension in teradata?
What does Amp contain and what are all the operations that it performs?
Why are oltp database designs not generally a good idea for a data warehouse?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What do you mean by parsing?
What is smp and mpp platforms?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Write a program to show the parser component used in teradata?
