Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17825 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
Describe the set operators in teradata.
In general, how do you optimze any sql in teradata?
What is meant by a Clique?
Is multi insert ansi standard?
How can you track login parameters of users in teradata?
Discuss the advantages of using partitioned primary index in a query?
What is the syntax for case when statement?
How many codd's rules are satisfied by teradata database?
Steps to create a data model?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What are default access rights in teradata? What explicit right can be given to a user?
Describe the between keyword in teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
How to load specific no.of records using bteq, or fastload,or multiload
What is the purpose of using case expression in teradata?
