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
What is a cognitive schema?
Differentiate between post-database commit and post-form commit?
How to convert numbers to characters in oracle?
Can you create a synonym without having a table?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How can we find out the duplicate values in an oracle table?
What is a package in oracle?
What is the scope of a local variable?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What are a cluster and non-cluster index?
Can we store pictures in the database and if so, how it can be done?
How to login to the server without an instance?
How to export several tables together?
Can we store images in oracle database?
How to define a data field as not null?