Types of indexes. What is the default key created when a
primary key is created in a table ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how many ways we can we find the current date using mysql? : Sql dba

810


Which data dictionary views have the information on the triggers that are available in the database?

939


What is using in sql?

794


How exception is different from error?

762


How do you rename a table in sql?

735






Is sql developer case sensitive?

723


what is self join and what is the requirement of self join? : Sql dba

857


What is difference between hql and sql?

701


What is trigger point?

732


What is error ora-01000: maximum open cursors exceeded

783


What is where clause in sql?

734


Do stored procedures prevent sql injection?

725


How to run sql statements through the web interface?

730


What is Materialized View? In What Scenario we Use Materialized View?

8938


Why truncate is faster than delete?

788