Top 20 plsql interview questions and answers pdf ebook free downloadExplicit cursors — Explicit cursors are used for queries that return more than one row. It is a programmer-defined cursor for gaining more control over context area. In order to use explicit cursors, the following steps are used-. Implicit cursors- These cursors are created when any SQL statements are executed. Using blocks you can develop a function, a procedure or probably a package. Generally, these blocks can be classified into two broad categories:.
Oracle Pl SQL Interview Questions and Answers.docx
Explian rowid, rownum? In a Distributed Database System Can we execute two queries simultaneously? How to avoid using cursors? What to use instead of cursor and in what cases to do so? State the difference between implict and explict cursors? How to know the last executed procedure? How can a function retun more than one value in oracle with proper example?
These questions will be updated and new questions will be added on regular basis, so stay tuned and subscribe to RSS Feed. Explain three different rules that apply to NULLs when doing comparisons? NULL is never equal or not equal to another value 3. A function has a return type in its specification and must return a value specified in that type. A procedure does not have a return type in its specification and should not return any value, but it can have a return statement that simply stops its execution and returns to the caller.
Read Top 20+ PL/SQL Interview Questions and Answers
What is Oracle and what are its different editions? Answer: Oracle is one of the popular database provided by Oracle Corporation, which works on relational management concepts and hence it is referred to as Oracle RDBMS as well. It is widely used for online transaction processing, data warehousing, and enterprise grid computing. What is a Data Dictionary and how can it be created? Answer : Whenever a new database is created, a database-specific data dictionary gets created by the system. This dictionary maintains all the metadata related to the database and owned by the SYS user.