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."

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

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."

---

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.

Constraints are used to enforce relationships

Quote:

---

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

"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

Quote:

---

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.

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