interview question on index
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: interview question on index

  1. #1
    Join Date
    Dec 2002
    Posts
    110

    interview question on index

    Hi all

    Interview question : How many constaints are automatically created when you create an index.

    Answer : Primary key i.e unique + not null

    interviewwr : there is 1 more

    If there is (i dont think so) can some let me know

    Rgrds

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    I assume "How many constaints..." should read "How many constraints...".

    If so, the correct answer is: "Abolutely none, zero. There is no constraints created when you create an index. And you should start to read some manuals, Mr. interviewer, as it is very clear that you have confused some basics of how Oracle database works."
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Oct 2003
    Location
    Sydney
    Posts
    29

    constraints

    Some constraints I can think of.......

    1) U should have a valid login
    2) U should have quota on the tablespace u wish 2 create
    3) create index privilege!

    Cheers
    Mano

  4. #4
    Join Date
    Mar 2004
    Location
    Pakistan
    Posts
    5
    I assume "How many constaints..." should read "How many constraints...".

    If so, the correct answer is: "Abolutely none, zero. There is no constraints created when you create an index. And you should start to read some manuals, Mr. interviewer, as it is very clear that you have confused some basics of how Oracle database works."
    hi...
    i just wanted to increase my knowledge about this index thing...
    and will appreciate ur response! ...

    question is that the index is just used for searching..right?
    i also heard from somewhere that 2 constraints r created
    one is primary key unique and not null...
    but i personally feel that it is only used for searching,
    so no constraint must be created....can u clear me on that?
    thanks,
    Take care,
    Bye.
    To repeat what others have said, requires education; to challenge it, requires brains!

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Constraints are used to enforce relationships

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    constraints
    Some constraints I can think of.......

    1) U should have a valid login
    2) U should have quota on the tablespace u wish 2 create
    3) create index privilege!

    Cheers
    Mano
    None of those are constraints
    Last edited by davey23uk; 03-04-2004 at 05:24 AM.

  7. #7
    Join Date
    Aug 2003
    Location
    Virginia
    Posts
    392

    Constraints.....

    "constraints
    Some constraints I can think of.......

    1) U should have a valid login
    2) U should have quota on the tablespace u wish 2 create
    3) create index privilege!

    Cheers
    Mano

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



    None of those are constraints"

    Davey.....
    1) Are you not constrained when you provide an invalid username and password?
    Rick

    Sigh.....those were the days my friend, I thought they'd never end.
    I too remember when this place was coo.


  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    well... define the word constraint in this context

    A constraint in Oracle is used for data integrity - e.g. a check constraint a primary kry, used to enforce referential integrity within your database.

    What were listed I would call priveleges

  9. #9
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253

    Re: Constraints.....

    Originally posted by Alchemy
    Are you not constrained when you provide an invalid username and password?
    You're reading the words in the question in the wrong order ...

    "How many constaints are automatically created when you create an index?"

    Your answer is not consistent with the question.

    The answer of course, is none.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448

    Re: Constraints.....

    Originally posted by Alchemy
    "constraints
    Some constraints I can think of.......

    1) U should have a valid login
    2) U should have quota on the tablespace u wish 2 create
    3) create index privilege!

    Cheers
    Mano

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



    None of those are constraints"

    Davey.....
    1) Are you not constrained when you provide an invalid username and password?

    read the question again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width