Can a table have two primary keys?

Answer Posted / suresh babu

No,The Table should have one primary key.But we can create
single primary key for combination of more columns,which is
called Composite Primary Key.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When is the update_statistics command used?

572


What is the location of pre_defined_functions.

646


Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

558


What is before and after trigger?

518


What is a recursive stored procedure?

617






Can %notfound return null after a fetch?

591


How can you get sql*loader to commit only at the end of the load file? : aql loader

554


What is row_number () in sql?

546


Why do we use subquery?

489


What is primary key and foreign key with example?

496


Is join an inner join?

536


Is sql free?

501


What is pl sql variable?

504


How many types of privileges are available in sql?

739


What is a system versioned table?

538