Why do you use stored procedures and state some of its disadvantages?


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

Post New Answer

More Oracle General Interview Questions

Does oracle partitioning improve performance?

0 Answers  


Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.

1 Answers  


Which database is better for os platform dependency?

1 Answers  


What are the different types of database objects?

0 Answers  


How to use group functions in the select clause using oracle?

0 Answers  






What are the components of Physical database structure of Oracle Database?

4 Answers  


How many types of tables supported by oracle?

0 Answers  


How to write a query with a right outer join in oracle?

0 Answers  


How to convert character types to numeric types?

0 Answers  


Explain the use of record option in exp command.

0 Answers  


1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

2 Answers   Accenture,


I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.

3 Answers   Microsoft,


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)