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
What is the difference between sql and isql*plus?
What is the most important ddl statements in sql are?
What is the unique index?
What is materialized view. What are different methods of refresh?
Can we insert data into materialized view?
how to load data files into tables with 'mysqlimport'? : Sql dba
how would concatenate strings in mysql? : Sql dba
What are functions in sql?
How do I quit sql?
What is query syntax?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
How can triggers be used for the table auditing?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
What are the different schemas objects that can be created using pl/sql?
Is it possible to read/write files to-and-from PL/SQL?