Synonyms is the alias name for table, views, sequences & procedures and are created for reasons of Security and Convenience.
Two levels are Public - created by DBA & accessible to all the users. Private - Accessible to creator only. Advantages are referencing without specifying the owner and Flexibility to customize a more meaningful naming convention.
What is the maximum number of handlers processed before the PL/SQL block is exited when an exception occurs?
What occurs if a procedure or function terminates with failure without being handled?
Read the following code 3?
What is a database link?
Procedure and Functions are explicitly executed. This is different from a database trigger. When is a database trigger executed?
Which line in the following statement will produce an error?
Which three of the following are implicit cursor attributes?
What does preemptive in preemptive multitasking mean?
What does one do when one is rightsizing?
Why is the most of the processing done at the sever?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
