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
- 15090 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
Explain the term 'foreign key' related to relational database management system?
Write a program to show the parser component used in teradata?
How do you set the session mode parameters in bteq?
Explain the parallel data extension in teradata?
How to eliminate product joins in a teradata sql query?
How to find duplicates in a table?
what is sysdba and sysdbc ? which has high priority ?
What are the scenarios in which full table scans occurs?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What happens when a node suffers a downfall?
What are the uses of bynets in multi-node systems?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
how can we analyze the locks ?
if collect stats but it show low confidence why?
If RDBMS is halted what will you do ?
