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 |
which will default fire first statement level trigger or row level trigger
2 Answers Cap Gemini, Data Vision,
Does sql require a server?
What is a parameter query?
How do I truncate a word?
I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?
Can a view be updated/inserted/deleted?If Yes under what conditions?
How do I write a cron which will run a sql query and mail the results to agroup?
Is sql open source?
What is multiple partition?
what is a tablespace? : Sql dba
What is use of term?
how would you get the current date in mysql? : Sql dba
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)