Interested to Buy Any Domain ? << Click Here >> for more details...
What is an Index ?
- 2 Answers
- 6726 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rahul
indexing a table is access stretagy. its a way to sort and
search record in the table. its a faster way of retreving
records.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / orawhiz
An Index is an optional structure associated with a table to
have direct access to rows,which can be created to increase the
performance of data retrieval. Index can be created on one
or more columns of a table.
| Is This Answer Correct ? | 2 Yes | 0 No |
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
What are the differences between primary key and unique key?
Why packages are used in oracle?
types of indexes and the rationale behind choosing a particular index for a situation.
What is a snapshot log?
What is a cluster Key ?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What do you understand by a database object? Can you list a few of them?
What is background process in Oracle?
Explain oracle’s server parameter file.
What are the different types of database objects?
How do I connect to oracle database?
Oracle General 
