Answer Posted / rad
An index is an oracle object that stores ROWID (pointer)
and columns(s) data on a source table. Two main types are
B-tree and Bitmap. An index is crucial as it can preempt
unnessessary full table scans on the source table if the
queried data is included the indexed column(s). B-tree
primarily useful in OLTP and Bitmap is DSS (generally..)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to speed up webrick?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What is dynamic proxy?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How to use "in" parameter properly?
How to divide query output into groups in oracle?
What is meant by joins? List out the types of joins.
How to use values from other tables in update statements using oracle?
How to list all tables in your schema?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How to use an explicit cursor without open statements?
What to do if dba lost the system password?
Explain cascading triggers.
Can a formula column be obtained through a select statement ?