Results 1 to 8 of 8

Thread: SQL Interview question

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Dec 2007
    Answers
    4

    SQL Interview question

    Hello,

    It is Interview Quetion,I am joing 5 tables,if query is too long,what i have to do,what are the other option?


  2. #2
    Junior Member
    Join Date
    Feb 2008
    Answers
    17

    Re: Interview question

    we can use subquerys...insted of using more joins....


  3. #3
    Junior Member
    Join Date
    Feb 2008
    Answers
    17

    Re: Interview question

    Quote Originally Posted by nithya R View Post
    Hello,

    It is Interview Quetion,I am joing 5 tables,if query is too long,what i have to do,what are the other option?
    u can use subquerys .insted of joins....for better performance...


  4. #4
    Junior Member
    Join Date
    Feb 2008
    Answers
    2

    Re: Interview question

    Is this question in reference to LINQ or SQL Server?


  5. #5
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: SQL Interview question

    Try creating indexes.


  6. #6
    Junior Member
    Join Date
    Feb 2008
    Answers
    15

    Re: SQL Interview question

    Hi,
    If you know the structures of all tables You will be having more chances of doing this type of quires in different ways.
    for ex: If ur having related columns in each and every table use natural join( or self) (this will go better when the records were few, if the entities are huge it will take time to execute) ,
    or
    Group the entities according to their related columns and join them,
    if you are feeling tough doing all this you are having the only way that is using sub quires
    or
    creating Indexes to improve performance that will help you to use joins.
    bye sudheer


  7. #7
    Junior Member
    Join Date
    Feb 2008
    Answers
    1

    Re: SQL Interview question

    How to how many cursors are opened when we are running an oracle function or procedure?


  8. #8
    Junior Member
    Join Date
    Feb 2008
    Answers
    3

    Re: SQL Interview question

    How to write a function or procedure that verify the correct email id entered by the user??



    Last edited by admin; 03-07-2008 at 07:28 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact