Interview Question

Question

Interview Question

Mani-584606

SSChampion

Points: 11788
More actions
November 18, 2013 at 12:31 pm

#280218

Can you please let me know what would be the right answer for the following?
1. What should be strategy to minimize the impact on external system which is using our table's data for processing?
2. Design a database schema for college elections and how will you make sure at database end that one user can vote for one person standing for one post only

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

Usually this questions are to check for a mixture between knowledge and experience. There's not one correct answer, but multiple options depending on many circumstances. Basic answers that might lead you could be:

Mani-584606 (11/18/2013)
1. What should be strategy to minimize the impact on external system which is using our table's data for processing?

Code well & design your database correctly.

Mani-584606 (11/18/2013)
2. Design a database schema for college elections and how will you make sure at database end that one user can vote for one person standing for one post only

Use primary keys or unique constraints.

These won't be acceptable answers on their own and need to be explained.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 2

Mani-584606 (11/18/2013)
Can you please let me know what would be the right answer for the following?
1. What should be strategy to minimize the impact on external system which is using our table's data for processing?
2. Design a database schema for college elections and how will you make sure at database end that one user can vote for one person standing for one post only

I have to ask... what are your answers? 😉 Although being able to post a question is a worthy skill, these are interview questions and you should be doing the legwork to find the correct answers.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)