1.

What are different types of keys in Database?

Answer»

There are SEVEN types of database keys:-

  • Super Key:- This key recognizes the row in the table.
  • Primary Key:-This key is a column in the table which recognizes each row in the same table uniquely.
  • Candidate Key:-This key does not have any repeated attribute.
  • Alternate Key:- the -The key which is not primary is CALLED Alternate Key.
  • Foreign Key:-This key a column in the table to create a relationship with ANOTHER table.
  • Compound Key:-This key has various fields which allow the USER to identify a particular record uniquely.
  • Composite Key:-This multiple key attributes to identify the rows uniquely.
  • Surrogate Key:-This is an artificial key finds each of the records uniquely.


Discussion

No Comment Found