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
Printable View
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."
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
hi...Quote:
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."
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.
Constraints are used to enforce relationships
None of those are constraintsQuote:
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
"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?
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
You're reading the words in the question in the wrong order ...Quote:
Originally posted by Alchemy
Are you not constrained when you provide an invalid username and password?
"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.
Quote:
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
I realize that "providing an invalid username and password" is not an "Oracle" constraint, but I was taught that "providing an invalid username and password" does act, in the same manner as, a constraint. It is a field that forces correct data. As for the second and third question, I did not respond due to my lack of understanding.
Rick
I also understand that the question was about "how many" constraints are created. My response was further referencing the person who first mentioned login.
Rick
By that standard, there's about a thousand constraints though ... having SQL*Net correctly configured, have the instance started, spelling the table name correctly etc..Quote:
Originally posted by Alchemy
I realize that "providing an invalid username and password" is not an "Oracle" constraint, but I was taught that "providing an invalid username and password" does act, in the same manner as, a constraint. It is a field that forces correct data. As for the second and third question, I did not respond due to my lack of understanding.
Rick
Good lord you people must be utterly bored.
Dave aren't you suppose to be out flying somewhere?
that´s why I said, read the question againQuote:
Originally posted by Alchemy
I realize that "providing an invalid username and password" is not an "Oracle" constraint, but I was taught that "providing an invalid username and password" does act, in the same manner as, a constraint. It is a field that forces correct data. As for the second and third question, I did not respond due to my lack of understanding.
Rick
I mean, if someone ask you
"How many constaints are automatically created when you create an index."
Are you gonna say: many, for example username and password is a constraint?
To assist an individual with answers that would help for exam purposes, no, I wouldn't. Again, my responses were referencing the individual who posed the idea that an invalid username and password does act as a constraint. Thats all.
:)Quote:
Originally posted by OracleDoc
Dave aren't you suppose to be out flying somewhere?