What are the advantages and disadvantages, compared to the
standard SQL and SQL*plus ?

Answers were Sorted based on User's Feedback



What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?..

Answer / chandrika

•Applications that involve extensive business logic and
processing could place an excessive load on the server if
the logic was implemented entirely in stored procedures.
Examples of this type of processing include data transfers,
data traversals, data transformations and intensive
computational operations. You should move this type of
processing to business process or data access logic
components, which are a more scalable resource than your
database server.
•Do not put all of your business logic into stored
procedures. Maintenance and the agility of your application
becomes an issue when you must modify business logic in T-
SQL. For example, ISV applications that support multiple
RDBMS should not need to maintain separate stored
procedures for each system.
•Writing and maintaining stored procedures is most often a
specialized skill set that not all developers possess. This
situation may introduce bottlenecks in the project
development schedule.

Is This Answer Correct ?    3 Yes 1 No

What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?..

Answer / shaik

Hi,

1.sql is structured quiery language 1.sql plus is an
interfacing tool or medium through

sql statements will be passed to the oracle server.
2.Sql keywords cannot be abbreviated 2.sql plus cannot be
abbreviated.

thanks
Shaik

Is This Answer Correct ?    5 Yes 7 No

Post New Answer

More SQL PLSQL Interview Questions

How do I remove sql plus from windows 10?

0 Answers  


Can function return multiple values in sql?

0 Answers  


how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

0 Answers  


What are the benefits of using PL/SQL packages?

3 Answers  


What is Primary Key?

4 Answers   Ramco,


i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6

8 Answers   Satyam,


How can I get the number of records affected by a stored procedure?

0 Answers  


Can we create view in stored procedure?

0 Answers  


Delete duplicate records in the emp table.

6 Answers   Oracle,


what is the stuff function and how does it differ from the replace function? : Sql dba

0 Answers  


What is a left inner join?

0 Answers  


Is truncate ddl or dml?

0 Answers  


Categories