Is a secondary key the same as a foreign key?



Is a secondary key the same as a foreign key?..

Answer / Shweta Paedey

No, they are not the same. A secondary key is any alternate key defined in a table to speed up search operations. A foreign key is a field or set of fields in one table that refers to the primary key of another table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is pl sql quora?

1 Answers  


what are the advantages of mysql in comparison to oracle? : Sql dba

1 Answers  


What is cursor in pl sql?

1 Answers  


The select into statement is most often used to create backup copies of tables or for archiving records?

1 Answers  


Is mariadb nosql?

1 Answers  


how to do backup entire database? : Transact sql

1 Answers  


what is the forward decleration in packages?

1 Answers  


Can two tables have same primary key?

1 Answers  


What are inner and outer joins examples of both?

1 Answers  


When sql appeared?

1 Answers  


Explain commit, rollback and savepoint.

1 Answers  


What are the parts of a basic sql query?

1 Answers  


Categories