1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Any common SQL questions you've been asked in an interview?

Discussion in 'Servers and Enterprise Solutions' started by m4cc45, 11 Mar 2010.

  1. m4cc45

    Soldato

    Joined: 10 Mar 2003

    Posts: 6,608

    As topic really. I'm not a DBA nor do I pretend to be though I know enough about SQL to get by. The job is going to be part SQL with full training provided though I wondered if there were any common questions people have been asked and to prepare for.


    M.
     
  2. bigredshark

    Man of Honour

    Joined: 30 Jun 2005

    Posts: 9,516

    Location: London Town!

    I'd imagine they'll ask you to write a few fairly basic queries to prove you have some clue, I'm not a DB expert myself though...
     
  3. unclepablo

    Gangster

    Joined: 9 Jul 2006

    Posts: 130

    Assuming we're talking about Microsoft SQL Server - I'd brush up on the concepts so when they ask about things like Stored Procedures, Triggers etc. you have a understanding of what they "are" even if you don't know how to create them.

    As BRS says, displaying a basic understanding of how to construct a simple SELECT statement (with a basic INNER join) would be a good start :)

    If they are giving full training it will at least show you're interested in the product.
     
  4. m4cc45

    Soldato

    Joined: 10 Mar 2003

    Posts: 6,608

    Cheers! I'll look into it further.



    M.
     
  5. ecksmen

    Wise Guy

    Joined: 25 Jun 2004

    Posts: 1,228

    Location: Cardiff

    So far its all be based on the functionside - what about things like replication, sql log shipping, clustering and maintenance plans etc...
     
  6. m4cc45

    Soldato

    Joined: 10 Mar 2003

    Posts: 6,608

    I'm probably stronger on that side than anything else.. :)
     
  7. PAz

    Soldato

    Joined: 18 Oct 2002

    Posts: 6,518

    Location: Bucks

    Troubleshooting performance issues would be worth thinking about
     
  8. m4cc45

    Soldato

    Joined: 10 Mar 2003

    Posts: 6,608

    Good call!
     
  9. RimBlock

    Wise Guy

    Joined: 10 Nov 2004

    Posts: 2,237

    Location: Expat in Singapore

    Depends heavily on the position you are going for and the underlying server tech (Sybase, Oracle, DB2 etc).

    App support then it could be basic concepts;
    1. Basic select statement
    2. Getting table, stored proc, trigger info
    3. Checking server status
    4. Using basic sql tools (isql etc).
    5. Test on sql statments (i.e. what is the result)

    Developer;
    1. Tuning concepts for sql
    2. Efficency of different constructs.
    3. Nested transaction order.
    4. Results from sql statements......

    I mention the underlying tech as Oracle and Sybase for example have different methods for doing the same things......

    Finding a tables' fields for example.
    Sybase;
    sp_help [tablename]
    select * from [tablename] where 1=2

    Oracle;
    desc [tablename]

    Note: I take it the Oracle is still valid as I have been on Sybase for the last 6 years :D.

    Cheers
    RB
     
  10. m4cc45

    Soldato

    Joined: 10 Mar 2003

    Posts: 6,608

    Thanks again - very useful info.

    I should have pointed out it was for MS SQL - but the information has been stored away in my head should I need it.. :)



    M.
     
  11. Pho

    Sgarrista

    Joined: 18 Oct 2002

    Posts: 9,208

    Location: Derbyshire

  12. m4cc45

    Soldato

    Joined: 10 Mar 2003

    Posts: 6,608

    Cheers Pho that's superb! Bookmarked for now and the future!
     
  13. Pho

    Sgarrista

    Joined: 18 Oct 2002

    Posts: 9,208

    Location: Derbyshire

    It's definitely worth reading over the rest of his site too, some very useful stuff on there :).
     
  14. m4cc45

    Soldato

    Joined: 10 Mar 2003

    Posts: 6,608

    Yeah over the forthcoming months I'm going to have to learn a lot more about SQL - at least I now have a few 'reference' sites! Very useful info on there I must admit!


    M.
     
  15. s0ck

    Soldato

    Joined: 18 Oct 2002

    Posts: 5,299

    Just stroll in and keep calling it SEEEKWAAL.