types of indexes and the rationale behind choosing a
particular index for a situation.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Oracle General Interview Questions

Can you tell me how to add new column in existing views?how?How is possible?

0 Answers   FIS,


What is a system tablespace and when it is created?

0 Answers  


write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.

11 Answers   Wipro,


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  


What are internal user account in oracle?

0 Answers  






How to Identify the previously inserted/updated records in already populated table.

0 Answers  


What are advantages of dateset in datastage?

0 Answers   iGate,


What does ROLLBACK do ?

1 Answers  


how to get the index id?

1 Answers   Cognizant, TCS,


What is bulk copy or bcp in oracle?

0 Answers  


How to define an anonymous procedure with variables?

0 Answers  


how to unbreak sequence numbers during intereptions

1 Answers   Ion Exchange,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)