What is the fastest query method to fetch data from the table?


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

Post New Answer

More Oracle General Interview Questions

i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID

7 Answers   IBM,


I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

2 Answers   IBM,


Explain oracle left join with an example?

0 Answers  


How many types of table in Oracle?

0 Answers   MCN Solutions,


What are the general rules on data consistency?

0 Answers  






Explain table?

0 Answers  


wirte the syntax of update query?

3 Answers   IBM,


How many types of synonyms in Oracle?

0 Answers   MCN Solutions,


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  


Why do we use coalesce function in oracle?

0 Answers  


i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?

7 Answers   HCL, IBM,


what is the difference between authorization and authentication?

4 Answers   MAHINDRA, PUCIT,


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)