Thursday 2 February 2012

PL/SQL Interview Questions


            1. What is Exception? Types of Exceptions? Exception Propagations?
            2. What is RAISE_APPLICATION_ERROR?and what is PRAGMA INIT_EXCEPTION?
            3. What are the Predefined exceptions we have?
            4. When we is SELECT statement in the Execution block what are the Predefined exceptions we have to use in the Exception Block?
            5. What is the diff between NO_DATA_FOUND and %NOT FOUND
            6. What is CURSOR? What are the Cursor types? what are cursor declaration steps?
            7. What is the diff between Implicit and Explicit and Ref Cursor?
            8. In which program u has used the Cursor? One example for implicit cursor?
            9. What are the Cursor attributes we have?
            10. Can we issue the commit inside of the Cursor for Loop?
            11. What is For Update OF Clause in the Cursors?
            12. What is Procedure and what is Function?
            13. What is the RND and WND?
            14. What is the diff between Procedure and Function?
            15. When we will create Procedure and when we will create function?
            16. What is the diff between Package procedure and Standalone procedure?
            17. If we drop the table which we have used in the procedure do we need to recompile the procedure then how?
            18. How to get the Procedure Source code from database?
            19. What is the Advantage of Package?
            20. What are the other objects we can group inside of Package?
            21. How to Recompile the Package?
            22. When we will go for creation of Package? Can we create Package body without creation of Package Specification?
            23. Can we declare Procedure directly in the package body without declaring in the package specification?
            24. What is Trigger
            25. Can we commit inside of trigger? How to delete the Trigger? How many triggers we can use maximum?
            26. What are The DML Triggers? What is diff between Row and Statement level trigger?
            27. How to Debug PL/SQL Code?
            28. What are the Trigger Predicates we have?
            29. What is diff between Trigger and Procedure?
            30. What is Package Variable what is advantage?
            31. What are the Collections?
            32. What is PL/SQl Table what is the advantage of that when we will use PL/SQL Table?
            33. What is Global temporary table what diff between PL/SQL table and Temporary table?
            34. What is %ROWTYPE?
            35. What is Instead of Trigger? How can u use that?
            36. What is mutating trigger how can you handle this?
            37. What are PL/SQL table attributes?
Posted by at

4 comments:

  1. Unknown21 April 2018 at 04:21

    Hi There,


    Nice to be visiting your blog again, it has been months for me. Well this article that i’ve been waited for so long.



    I am calling an SSIS package inside a SQL Server Agent job step. Almost half the time, the package fails with the following error and it works fine other times. The column that it complains about is a nvarchar(max) column and the maximum data length for the records we have in that column is around 3600.

    Message
    Executed as user: abcdef. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:30:00 PM Error: 2010-03-03 16:30:02.84 Code: 0xC0047070 Source: Data Flow Task 1 Description: End Error Error: 2010-03-03 16:30:02.84 Code: 0x80004005 Source: Data Flow Task 1 Description: End Error Error: 2010-03-03 16:30:02.84 Code: 0xC0208266 Source: Data Flow Task 1 Description: End Error Error: 2010-03-03 16:30:02.84 Code: 0xC0208265 Source: Data Flow Task 1 Source - Query [1] Description: Failed to retrieve long data for column "Response". End Error Error: 2010-03-03 16:30:02.84 Code: 0xC020901C Source: Data Flow Task 1 Source - Query [1] Description: There was an error with output "OLE DB Source Output" (11) on component "Source - Query" (1). The column status returned was: "DBSTATUS_UNAVAILABLE". End Error Error: 2010-03-03 16:30:02.84 Code: 0xC0209029 Source: Data Flow Task 1 Source - Query [1] Description: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "output "OLE DB Source Output" (11)" failed because error code 0xC0209071 occurred, and the error row disposition on "component "Source - Query" (1)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. End Error Error: 2010-03-03 16:30:02.84 Code: 0xC0047038 Source: Data Flow Task 1 SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source - Query" (1) returned error code 0xC0209029. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:30:00 PM Finished: 4:30:02 PM Elapsed: 2.012 seconds. The package execution failed. The step failed.



    Thank you very much and will look for more postings from you.


    Thanks,
    Irene Hynes

    ReplyDelete
  2. Unknown3 May 2018 at 00:27

    Hello There,


    In total awe…. So much respect and gratitude to you folks for pulling off such amazing blogs without missing any points on the Oracle Apps Technical. Kudos!

    I would like to load the image from the web browser and save the image on Oracle table!
    I have Oracle XE database on Linux server
    When I run this script, I received an error: Internal Server Error!

    I cannot find what's wrong!

    The script run o.k. if I use only FORM class!!!
    With enctype="multipart/form-data the error is Internal Server Error!

    Super likes !!! for this amazing post. I thinks everyone should bookmark this.


    Thank you,
    Varun

    ReplyDelete
  3. Unknown18 June 2018 at 02:43

    Marhaba,,


    Fully agree on #topic. We’re seeing a lot of projects tackle big complex problems but few seem to have taken into consideration and in particular reasons to adopt.


    I want to execute the different files at the run time in the SQL PLUS

    Ex: I have two different files like ABC.SQL, XYZ.SQL,

    I had declared one bind variable to hold file_name .

    var file_name VARCHAR2(200);
    DECLARE
    sr VARCHAR2(20) :='ABC';
    BEGIN
    IF sr ='ABC' THEN
    :file_name :='ABC.SQL';
    ELSE
    :file_name :='XYZ.SQL';
    END IF;
    END;
    /
    PRINT file_name


    Now i want to execute the file which is there in :file_name bind variable

    SQL>@:file_name



    It was cool to see your article pop up in my google search for the process yesterday. Great Guide.
    Keep up the good work!
    morgan

    ReplyDelete
  4. Unknown18 June 2018 at 22:05

    Hello There,

    11/10!! Your blog is such a complete read. I like your approach with PL/SQL Interview Questions . Clearly, you wrote it to make learning a cake walk for me.

    how to find first nonspace character from end of the string

    ex: 'abc def g '

    I should get 4 in this case. (the first nonspace character from backwards in the above example is g and the position is 4 from backwards.

    Could you help me in getting this?

    I am so grateful for your blog. Really looking forward to read more.

    Best Regards,
    Preethi.

    ReplyDelete

Subscribe to: Post Comments (Atom)