Post reply

Interview Question

  • 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

  • November 18, 2013 at 12:47 pm

    #1667224

    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

  • November 18, 2013 at 5:36 pm

    #1667280

    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)

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

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