Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Attended an Interview Expand / Collapse
Author
Message
Posted Tuesday, September 18, 2012 4:41 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 11:45 PM
Points: 562, Visits: 887
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/
Post #1360674
Posted Tuesday, September 18, 2012 5:11 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 3, 2013 12:38 AM
Points: 91, Visits: 77
Hahaaa...Google Search :)

*******
Sudhakar
Post #1360687
Posted Tuesday, September 18, 2012 5:18 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:20 AM
Points: 5,231, Visits: 5,106
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
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

Post #1360691
Posted Tuesday, September 18, 2012 5:50 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 8:10 AM
Points: 15,726, Visits: 28,131
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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1360709
Posted Tuesday, September 18, 2012 6:05 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:19 AM
Points: 43,002, Visits: 36,158
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 2008, MVP
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

Post #1360724
Posted Tuesday, September 18, 2012 6:11 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 12, 2014 4:32 AM
Points: 2,652, Visits: 4,731
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/
Post #1360731
Posted Tuesday, September 18, 2012 6:12 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:20 AM
Points: 5,231, Visits: 5,106
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
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

Post #1360732
Posted Tuesday, September 18, 2012 6:18 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:07 PM
Points: 37,075, Visits: 31,632
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1360738
Posted Tuesday, September 18, 2012 6:19 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:07 PM
Points: 37,075, Visits: 31,632
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1360740
Posted Tuesday, September 18, 2012 6:56 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 3:26 AM
Points: 708, Visits: 3,287
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
Post #1360761
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse