Interested to Buy Any Domain ? << Click Here >> for more details...
How many different types of indexes we have in oracle?
- 24 Answers
- 192496 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / sudev kuma rmishra
two types
A.implicit B.explicit
A.implicit index
automatically created when we mention primary key or unique key
B.explicit index
these are created by user
and examples are
1.simple/normal index
2.composite index
3.unique index
4.bitmap index
5.partition index
6.function index
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is a sub query? What are its various types?
WHAT IS ecc 6.0
What is define in oracle?
What is difference between sid and service name in oracle?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
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.
Explain the difference between replace() and translate() functions in oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
Explain the difference between a procedure and a function?
Explain a data segment?
How do you find current date and time in oracle?
Explain the use of parfile option in exp command.
Define oracle database
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
Explain what are the characteristics of data files?
