Want a Free Job Posting?

Buy a job posting today and the second one is on us. For a limited time only. Act Now.

Interview Question

Interview(Student Candidate) Sunnyvale, CA

You are given a database table that keeps track of student

  data. The fields contain id, name, major, current year. How would you improve this table to be more efficient?

Interview Answer

3 Answers


The actual question was more general in how you would you improve this table. It was pretty open ended and seemed to be testing on database concepts. The answer that my interview was looking for was to change the field current year to the date that the student started at the college. This makes it more efficient since current year has to be updated every year whereas the start date is more persistent.

Interview Candidate on Mar 31, 2013

Split name into first and last name -- would be useful for schools since they could order by last name, Also make major its own table -- students can have multiple majors.

TheDude on Apr 24, 2013

create an index on name, next time, searching for student would be faster

wc on Jan 5, 2014

Add Answers or Comments

To comment on this, Sign In or Sign Up.