SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Attended an Interview


Attended an Interview

Author
Message
rhythmk
rhythmk
SSC Eights!
SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)SSC Eights! (922 reputation)

Group: General Forum Members
Points: 922 Visits: 1078
Recently I attended an interview for a role of Senior SQL Developer and I wondered the kind of questions panel asked.Here are few of them.

1.How many columns a SQL table can hold.
2.How many string functions are there in SQL.
3.How many non-clustered indexes a SQL table can have.
4.What is the port to be used to connect SQL DB server.

Then they started asking questions on syntax of SQL function.

At last to stop them I just denied to reply the question by saying that why are you hiring me better to have a Google search for that :-)

--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
:-)
Sudhakar Vallamsetty
Sudhakar Vallamsetty
SSC Journeyman
SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)

Group: General Forum Members
Points: 95 Visits: 77
Hahaaa...Google Search Smile

*******Cool
Sudhakar
anthony.green
anthony.green
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10180 Visits: 6378
Maybe they are trying to see if you know the limits and basics of SQL, they are all valid questions.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


Grant Fritchey
Grant Fritchey
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: General Forum Members
Points: 40789 Visits: 32666
anthony.green (9/18/2012)
Maybe they are trying to see if you know the limits and basics of SQL, they are all valid questions.


I don't know that I agree. The first three questions are just trivia that I use Books Online to understand. How many string functions are there? I don't know. Want to know how the optimizer works?

As to question four... it can be anything. The default is 1433, but you can make it what you want within the limits of ports. So that question is actually off (unless they're looking for this answer).

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
GilaMonster
GilaMonster
SSC Guru
SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)SSC Guru (88K reputation)

Group: General Forum Members
Points: 88777 Visits: 45284
And the question of how many columns in a table depends on a couple things, it's not a fixed number. Maybe they were wanting to see if you knew that. :-)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Kingston Dhasian
Kingston Dhasian
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3735 Visits: 5180
1.How many columns a SQL table can hold.
2.How many string functions are there in SQL.
3.How many non-clustered indexes a SQL table can have.
4.What is the port to be used to connect SQL DB server.


Some of these questions seem valid to me as well

From your questions I feel that either
1. The interview panel was not experienced one and they have used "Google" to find "SQL Server Interview Questions" themselves OR
2. This is just an initial round

Anyways, your answers seem a bit rude to me in an interview
You could have politely said, "I don't remember the exact syntax as there is always Google and MSDN to help me out"
I have said this in some interviews and they were OK with it and say that they are only interested in the logic I use to solve the problem.


Kingston Dhasian

How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
anthony.green
anthony.green
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10180 Visits: 6378
GilaMonster (9/18/2012)
And the question of how many columns in a table depends on a couple things, it's not a fixed number. Maybe they were wanting to see if you knew that. :-)


I know of two, Wide and Non-Wide tables, unsure if there are others



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)

Group: General Forum Members
Points: 87814 Visits: 41121
rhythmk (9/18/2012)
Recently I attended an interview for a role of Senior SQL Developer and I wondered the kind of questions panel asked.Here are few of them.

1.How many columns a SQL table can hold.
2.How many string functions are there in SQL.
3.How many non-clustered indexes a SQL table can have.
4.What is the port to be used to connect SQL DB server.

Then they started asking questions on syntax of SQL function.

At last to stop them I just denied to reply the question by saying that why are you hiring me better to have a Google search for that :-)


Did you actually want the job? How did you reply the to questions above?

--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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)

Group: General Forum Members
Points: 87814 Visits: 41121
Kingston Dhasian (9/18/2012)
1.How many columns a SQL table can hold.
2.How many string functions are there in SQL.
3.How many non-clustered indexes a SQL table can have.
4.What is the port to be used to connect SQL DB server.


Some of these questions seem valid to me as well

From your questions I feel that either
1. The interview panel was not experienced one and they have used "Google" to find "SQL Server Interview Questions" themselves OR
2. This is just an initial round

Anyways, your answers seem a bit rude to me in an interview
You could have politely said, "I don't remember the exact syntax as there is always Google and MSDN to help me out"
I have said this in some interviews and they were OK with it and say that they are only interested in the logic I use to solve the problem.


+1

I think the questions were quite appropriate for the position. If someone had told me to "Google" it in an interview, I'd have given them a military escort off the property right then and there.

--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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Abu Dina
Abu Dina
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1257 Visits: 3323
rhythmk (9/18/2012)
Recently I attended an interview for a role of Senior SQL Developer and I wondered the kind of questions panel asked.Here are few of them.

1.How many columns a SQL table can hold.
2.How many string functions are there in SQL.
3.How many non-clustered indexes a SQL table can have.
4.What is the port to be used to connect SQL DB server.

Then they started asking questions on syntax of SQL function.

At last to stop them I just denied to reply the question by saying that why are you hiring me better to have a Google search for that :-)



Forgive me for saying this but I think you miss the point.

You say the position is for a Senior Developer so I think the clue is in the title of the position.
I don't think your interviewers were interested in exact numbers to be honest but perhaps they were looking for answers along the following lines? (I didn't google any of these so please feel free to have a go at me for my lack of knowledge but then again, I never claimed to be a Senior SQL Developer!):

1.How many columns a SQL table can hold.

Answer: Lots! LOL.. no really for an exact answer we can look in BOL but surely it depends on the data stored in the columns and the data types of the columns.

2.How many string functions are there in SQL.

I don't know the exact number but I can sure name a few of them, LEN, SUBSTRING, CHARINDEX, STUFF, REPLICATE etc.. etc...

3.How many non-clustered indexes a SQL table can have.

Again, I don't know the exact number but this also depends on the size of your table and disk space available etc...

4.What is the port to be used to connect SQL DB server.

Anyone who claims to be a Senior Developer should really know this. But knowing the default port number and explaining why this should be changed in the context of security would prove to your interviewers that you know what you're talking about.

My 2 cents/pence ;-)

---------------------------------------------------------


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search