1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

If a procedure within a package is invalidated whether the
entire package will be invalid and has to be recompiled
again?

Question Posted / guest

Answers were Sorted based on User's Feedback



If a procedure within a package is invalidated whether the entire package will be invalid and has ..

Answer / guest

Yes, the total package body will become invalid and has to
be recompiled again

Is This Answer Correct ?    24 Yes 2 No

If a procedure within a package is invalidated whether the entire package will be invalid and has ..

Answer / rajini

It will be complained when it is referenced.

Is This Answer Correct ?    3 Yes 4 No

Post New Answer

More SQL PLSQL Interview Questions

What is minus?

0 Answers  

What are schema-level triggers?

0 Answers  

Does sql require a server?

0 Answers  

What is sql character function?

0 Answers  

What are different clauses used in sql?

0 Answers  




I need to write a simple query,which one is better select statement or stored procedure?and why?

2 Answers   iGate,

What is the least restrictive isolation level? : Transact sql

0 Answers  

How do you identify a primary key?

0 Answers  

What will you get by the cursor attribute sql%found?

0 Answers  

what is self join and why is it required? : Sql dba

1 Answers  

What is input buffer in sql*plus?

0 Answers  

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

For more SQL PLSQL Interview Questions Click Here
Categories