Im attending interviews for the past month or so.. I had to face a couple of bookish dumb asses as interviewers(really i mean it), lets see why i mean so. It was a telephonic interview. lets see some of those
1. explain me the architecture of sql server,indexes, blah blah?
guys how do u want me to explain a product architecture over the phone...btw i have one doubt am im going to rewrite or code the SQL 2010, why the heck shd i know the architecture? have some sense guys.
2. what is ACID properties, codds rules, boyds rule, normalization rules, how many of these rules does sql server abide blah blah..?
come on guys have some limit to your bookish questions, tell me the names of any one data architect who designs the database using normalization rules, i challenge if some one in the world can say that okey this model is in the 2nd normal form or blah blah.. come on guys business rules are much more important than these..
i dont give a damn if sql server follows or abides 12 of codds rules.. its not my business or i cant do anything to make it abide all the rules you cant either.
3. how do you establish a one to one relation?
what they heck do you mean by how do you establish a one to one relation? is it like u try to ask me what is one to one and what is one to many? be clear.. when i asked back what do you mean by this.. he skipped to next questions..
4. what is a clustered index, non clustered index, how many of them you can have in a table, max columns, max tables, max indexes etc etc..?
thank god they didnt ask what is a table, column,row etc..(im MCITP with almost 7 yrs of exp in sql server.
so wt am i going to know the max tables, max indexes, max columns? i know sql server support decent enough to keep your business up and running. so wt r u going to by knowing all these things.. design a table with 1024 columns or try to run ur business critical database with max dbs, max tables, max columns, max indexes.. ask questions that make sense dont be a question thief from websites like this.. http://www.techinterviews.com/?p=42
5. how do i read the tlog using sql server native tools etc etc..?
oh so r u trying to test my confidence levels.. hmm i pity on you...
i can recollect jst the above ones.. the below are the examples to show cause their real time efficiency.
1. Im supporting the sql server of nasdaq something has happened and the traffic to the db has increased 10times. what will you do with out restarting and no spl hardware available?
I said u have to pre plan u cant do any thing dynamically.. then he told no do something.. i blabbed something like disabling unwanted jobs, if possible take other non critical dbs in that servers offline, make sure ur SAN subsystem doesnt get traffic from some other system blah blah.. I asked him back what would you do...
He told I would add an Microsoft Queue or will try to add a SQUID.. I asked so your are going to add a Queue to a highly volatile system like NASDAQ.. you are THE MAN, THE MACHINE, THE DBA.. and I give you a Hi5 * 100 for this wonderful reply.I pity on your client if you have designed any solutions to them.
2. one fine day you find out that one table is having performance issue in the production, what will you do.. i said index, locks blah blah..
he was not satisfied and he keep asking me wt else wt else.. at one point i gave up and asked what will you do.. i said the table design is wrong need to redesign the data model.. i was like whatttttttttttttt.. so u mean to say ull scrap ur data model and redesign.. WOW... you are THE SUPER MAN, THE SUPER MACHINE, THE SUPER COMPUTER, THE SUPEREST DBA and THE CLEAR WINNER.. may god bless you, your system, your client..
probabl you guys would have faced similar dumbest questions... comment if any such..
