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


Please Help Members By Posting Answers For Below Questions

What do high confidence, low confidence and no confidence mean in explain plan?

566


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

628


In Teradata, what is the significance of UPSERT command?

563


What is spool space?

576


List the logical and conditional operators that are used with teradata along with their meanings?

527






What are the newly developed features of Teradata?

551


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

1929


In Teradata, how do we Generate Sequence?

575


What exactly do you know about catching in teradata?

607


Explain fastload in teradata?

571


Explain the term 'database' related to relational database management system?

547


What are the different softwares used with their functions in teradata?

549


What is the use of virtual processor connectivity in teradata?

537


Explain the meaning of Amp?

561


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?

611