1.

What MySQL property is used to create a surrogate key in MySQL?(a) UNIQUE(b) SEQUENCE(c) AUTO_INCREMENT(d) None of the mentionedThe question was posed to me in an internship interview.The doubt is from Servlets and JSP topic in section Database Programming Techniques of Database Management

Answer» RIGHT ANSWER is (c) AUTO_INCREMENT

Easiest EXPLANATION - A surrogate key in a database is a unique identifier for either an ENTITY in the modeled world or an object in the database.


Discussion

No Comment Found

Related InterviewSolutions