Oracle Index

<<Previous  Next>>

What is an Index? Index in oracle helps to trace the information faster just like an index in a book. Index entries keep............ Read answer Test your Oracle skills: Oracle part 1 (40 questions) Oracle DBA (30 questions) Oracle PLSQL (30 questions) Oracle Replication (20 questions) Oracle Architecture (20 questions) Oracle Transaction(20 questions) What are the objects in oracle? Table, Views, Index, Synonym and Sequence are the objects of oracle.............  Read answer What is INDEX_BY_BINARY_INTEGER?    BINARY_INTEGER is a PL/SQL data type defined as a subtype of INTEGER in the STANDARD package and is used for storing signed integers.............. Read answer What is index and explain its purpose. An index is a pointer to a location of data. The purpose of an index is to make SQL queries run faster................ Read answer What are the guidelines to decide which table s to index? On rebuilding an Index, the existing index is dropped and a new one is built. This operation can consume a lot of time and resources................. Read answer What are the guidelines to decide which column to index? Non-key columns can be dropped from a table only after the non-key index is dropped first. Columns can’t be defined in both the key column and the INCLUDE list............... Read answer What is composite index? A composite index contains more than one key column................ Read answer Bitmapped indexes and B-tree index In a Bitmap index, a 2 dimensional array is created. The array represents the index value multiplied by number of rows........... Read answer Oracle nested table and varrays A nested table is an unordered set of data elements. These data elements are all of the same datatype. It has a single column whose type is either built in or an object type. It is a table stored within the structure of another table............. Read answer Oracle Functions, Procedures, packages Explain IN, OUT and INOUT in procedures, What are the rules of writing package?, Explain the rules for writing a package.............. Read answer Oracle error handling What is Exception in Oracle?, What are the predefined oracle exceptions?, Explain user defined exceptions in oracle, How PL/SQL Exceptions Are Raised?............. Read answer Oracle data types Explain the differences between char and varchar2 data types, Explain BLOB, CLOB, NCLOB and BFILE, Explain ROWID in oracle, What is a LOB data type?........... Read answer <<Previous  Next>> Write your comment - Share Knowledge and Experience