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

Absolutly No. One table can not have more than one PK. But
u can have 2 cols as 1 PK called Composite Primary Key.

Is This Answer Correct ?    40 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

654


If a Node is busy what are the steps you can take to avoid ?

1875


What are the various indexes in teradata? How to use them? Why are they preferred?

593


List out teradata data types?

559


What is the difference between global temporary tables and volatile temporary tables?

637






How to load specific no.of records using bteq, or fastload,or multiload

1318


If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

1671


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

590


Describe the between keyword in teradata?

612


How many tables can you join in v2r5?

626


What is the use of teradata system software?

550


Differentiate database data and data warehouse data?

588


What are the various etl tools in the market?

587


Why managing the data is important?

590


What is a clique?

585