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 |
What is meant by truncate in sql?
Write a sql query to get the third highest salary of an employee from employee_table?
how to use like conditions? : Sql dba
IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;
What is ON DELETE CASCADE?
what is the difference between where clause and having clause? : Sql dba
How do I access sql anywhere database?
What is the current version of sql?
Why do we use procedures in pl sql?
What are packages in pl sql and also explain its advantages?
what is the command line end user interface - mysql? : Sql dba
What are the types of queries in sql?
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)