Note 1

Take Note:

Take a note while surfing.





Note With Ink

Give your Note a Colorful Tag.




Easy to Access

Stay on same information and in Sync wherever you are.

Note 2

Take Note:

Organize your information,It may take Shape.





Think With Ink

Differ your Content by Color.




Easy to Access

Easy to pull up your content from anywhere anytime.

Note 3

Take Note:

Don't Let information to miss,Because it take shape





Note With Ink

Simple an Easy Way to take a note.




Easy to Access

Get the same in next visit.


Please wait...

Technical Interview Questions and Answers :: Oracle PLSQL

    Question :: 1
    What is bulk sql?
    Answer:

    bulk insert or bulk delete or bulk fetch of data is called bulk sql

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 2
    What is bulk collect clause?
    Answer:

    Oracle bulk collect, the SQL engine retrieves all the rows and loads them into the collection and switches back to the PL/SQL engine. When rows are retrieved using Oracle bulk collect, they are retrieved with only two context switches.

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 3
    How many types of Exception Handling are there ?
    Answer:

    There are mainly two types of exceptions: checked and unchecked where error is considered as unchecked exception. 

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 4
    What is ref cursor?
    Answer:

    Ref cursor is a varible, type of cursor. It points to or references a cursor result. One of the advantages ref cursor has over a plain cursor is that it can be passed to other procedures as a variable.

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 5
    What Exception Propagation?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 6
    What is Instead of Trigger?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 7
    What is Cursor and How many types of Cursor you have used?
    Answer:

    Cursors help us to do an operation on a set of data that we retrieve by commands such as Select columns from a table. For example : If we have duplicate records in a table we can remove it by declaring a cursor which would check the records during retrieval.

    There are mainly 2 types of cursors .
    1) Implicit Cursor.
    2) Explicit Cursor.

    Implicit Cursor: Oracle will implicitly creates an area for the DML operations. Programmer will not have control on implicit cursors. The only useful attribute on this implicit cursor is SQL%ROWCOUNT , it will give the number of rows affected by the recent DML operation.

    Explicit Cursor: created by the programmer and programmer have control on it Programmer can
    1) Open 2) Close 3) Fetch
    one by one and remove rows which have duplicate values.

    Explicit Cursors are classified into
    1) Normal cursor
    2) Parameterized cursor
    3) Cursor For Loops and
    4) REF cursors

    Please Login First :
    Question :: 8
    What is a Stored Procedure? State its advantage.
    Answer:

    A stored procedure is a set of per-compiled SQL commands (query statements), which are stored in the server. It is faster then the loose SQL statements processed on client, as it is per-compiled. It can execute more then one SQL commands once as they are bundled in a single entity. We can use control statements within the stored procedure, which will allow us to repeat some SQL command. It can send return values depending upon the result. Stored procedures are used to reduce network traffic.

    Please Login First :

    Tags:Virtusa

    Question :: 9
    What is a Trigger?
    Answer:

    Triggers are a special type of stored procedure, which gets invoked upon a certain event. They can be performed upon an INSERT, UPDATE and DELETE.

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 10
    What is a cursor? How do you replace a Cursor?
    Answer:

    : An entity that maps over a result set and establishes a position on a single row within the result set. After the cursor is positioned on a row, operations can be performed on that row, or on a block of rows starting at that position. The most common operation is to fetch (retrieve) the current row or block of rows.

    Please Login First :