Question
Need for surrogate key not primary key
Answers
If a column is made a primary key and later there needs a change in the data type or the length for that column then all the foreign keys that are dependent on that primary key should be changed making the database Unstable . Surrogate Keys make the database more stable because it insulates the Primary and foreign key relationships from changes in the data types and length.   Your Comment




  • Contributors: *,


Search
Can you Answer!!
  • Q class Test { public static void main(String[] args) { String s1 = "Hello World"; String s2 = "Hello World"; if (s1 == s2) System.out.println("The strings are the same"); else System.out.println("The strings are different"); } }
  • Q Biology teaching inculcates nationalism. Give any two situations
  • Q Explain Action Servlet?
  • Q What is modular framework?
  • Q How many justices are on the Supreme Court?
  • Q Which computerized payroll systems are you familiar with?
  • Q Pollution of water bodies by which element causes Minamata disease?
  • Q Explain poaching/ raiding.?
  • Q Which cowboys middle names were Berry Stapp
  • Q What is a plane figure with nine straight sides and nine angles?
  • Q Under MSY programme, the rural woman of ______ years of above age can open their savings, account in the rural post office?