Can a table have two primary keys?

Answer Posted / vaibhavi_dixit

A table can have only one primary key constraint but it can
consist one or multiple columns.If a primary key is made up
of more than one columns then it is know as composite
primary key.

VD

Is This Answer Correct ?    15 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between join and natural join?

465


How many types of literals are available in pl sql?

505


Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

590


Is a table valued function object?

568


What do you mean by rowid?

530






what is the difference between cluster and non cluster index? : Sql dba

546


How many columns should be in an index?

510


Explain what is a field in a database and record in a database?

598


What is a temporal table?

483


What is basic structure of pl sql?

490


How do you copy a table in sql?

551


Why do we need cursors in pl sql?

512


Difference between global and parameter variables?

1447


What are the commands used in sql?

519


How to start the command-line sql*plus?

557