-
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
-
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?
-
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
-
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!
-
Constraints are used to enforce relationships
-
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 06:24 AM.
-
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.
-
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
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|