Types of indexes. What is the default key created when a
primary key is created in a table ?
Answers were Sorted based on User's Feedback
Answer / mahesh
Major indexes are B-tree and Bitmap indexes
When ever we create a primary key, B-tree index will be
created
Is This Answer Correct ? | 15 Yes | 3 No |
Answer / sdp
A unique index is created when a primary key is created in
a table.
Is This Answer Correct ? | 10 Yes | 3 No |
Answer / suren
while creating primary by default a unique index is created
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / manish_patil
There are main two types of indexes,
B-tree index
Bitmap index.
While creating Primary key by default cluster index get
crated.
Is This Answer Correct ? | 7 Yes | 5 No |
Tell me what a package consists of.
How to call shell script from pl sql procedure?
Which is the best place to learn hadoop?
What is bulk compiling in pl/sql.?
give the syntax of grant and revoke commands? : Sql dba
What is sqlexception in java?
How do u count no of rows in a table?
What is delimiter in pl sql?
If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?
Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?
What are the uses of sysdate and user keywords?
How does a trigger work?