Mention what problem one might face while writing log information to a data-base table in pl/sql?



Mention what problem one might face while writing log information to a data-base table in pl/sql?..

Answer / Ankit Varshney

One potential issue could be performance degradation due to frequent writes, as logging large amounts of data can slow down the execution of other operations. Another problem might be data consistency issues if not properly handled in case of errors or concurrent transactions.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Why use stored procedures?

1 Answers  


What data types does pl/SQL have?

3 Answers  


difference between oracle 8i and oracle 9i

8 Answers  


What is the difference between jpql and sql?

1 Answers  


define sql delete statement ? : Sql dba

1 Answers  


how many no of table can be join in a sql query.

4 Answers  


What is not null in sql?

1 Answers  


What are different joins used in sql?

1 Answers  


how view used for security purposes?

3 Answers   Glam India,


Difference between aggregate function and analytical function?

3 Answers   Metric Stream,


What is sap sql?

1 Answers  


explain normalization concept? : Sql dba

1 Answers  


Categories