Forum Stats

  • 3,854,216 Users
  • 2,264,340 Discussions
  • 7,905,609 Comments

Discussions

pl/sql interview questions

bandarupalli
bandarupalli Member Posts: 4
edited Oct 17, 2013 6:10AM in SQL & PL/SQL

Thanks in advance

1.. what is mutating table error? how can you solve that problem?

i think using instead of triggers we can do that.. is it?

2. can we create a public synonym of our own object without entering sysdba account?

i think no.. is it?

3. suppose i have a procedure which had a bunch of queries, among them say 3 queries are using more resources then how can we track them?

i dont know how to do that without writing explain_plan individually... please tell me

4. will the snapshot of data will be stored in the RAM , where will it be stored exactly.

yes it will be stored on RAM upto 10000 rows, after that it will fetches next set of rows.

5. how to delete 100 tables or 100000 tables' data from the schema without writing delete statement for no.of times. write an sql statement to do that job.

sql> delete from (select table_name from user_tables where ....);

6. suppose an error occured in the execution of procedure in the for loop body what will be happened? if the error occured, how to continue the program without exiting. write an example.

i think if we put the loop in embedded block, then the error will be handled by respective exception_handler of that block and cursor passed to the next block then program runs smoothly.

Hoekbandarupalli34MCA2K2Billy VerreynnePurvesh KChris HuntAshu_Neoranit B
«1

Answers

  • Hoek
    Hoek Member Posts: 16,087 Gold Crown

    Just use the search box on the upper left on this page: Oracle Database Online Documentation 11g Release 2 (11.2)

  • Frank Kulash
    Frank Kulash Member, Moderator Posts: 42,501 Red Diamond

    Hi,

    Post your answers, and specific questions about them.  (For example, if you're not sure what the question means, or how to find the answer, or if your answer really applies to all situations).

    Let's take the last question you posted, for example:
    "39. how many hints are there provided by oracle?"

    You might wonder if they really expect an exact number, or if an approximation is good enough.  You might not know which manual contains the answer, or what keyword(s) to look up in the index to find the answer.

  • SomeoneElse
    SomeoneElse Member Posts: 14,867 Silver Crown

    > please give me the answers for all.

    You're kidding, right?


  • Chris Hunt
    Chris Hunt Member Posts: 2,066 Gold Trophy
    Please give me the answers for all.

    Sure. Please give me all the money you get from the job, since it's me that'll be answering all the interview questions.

  • SomeoneElse
    SomeoneElse Member Posts: 14,867 Silver Crown

    Actually, if I were to present these questions to a potential candidate the answer I'd want to hear is "wow, what a bunch of shitty questions".


    HoekBilly VerreynneAshu_Neo
  • Frank Kulash
    Frank Kulash Member, Moderator Posts: 42,501 Red Diamond
    edited Oct 16, 2013 12:38PM

    Hi,

    SomeoneElse wrote:
    
    Actually, if I were to present these questions to a potential candidate the answer I'd want to hear is "wow, what a bunch of shitty questions".
    
     

    Not entirely.

    Some certainly are poor questions. Some require clarification; they might have meant something reasonable.

    Some aren't bad interview questions.  For example:

    "6. what is mutating table error? how can you solve that problem?"

    I think this question is okay.  It is a common enough problem; and there are different ways (some good, some terrible) to deal with the problem.  How the candidate answers this question can tell you a lot about the candidate's experience and intelligence.

  • Hoek
    Hoek Member Posts: 16,087 Gold Crown

    Yup, most of those questions are outdated, from the previous century, or badly phrased....now "shall we create a table in the procedure"?

  • Mike Kutz
    Mike Kutz Member Posts: 6,199 Silver Crown
    edited Oct 16, 2013 1:30PM

    SomeoneElse

    I partly agree with you, but I'd be more interested in hearing the person's reason on why they are bad questions.

    On the other hand, if a person with zero(0) knowledge asks the questions, the local guru can then judge the candidate's capability of communicating Oracle concepts (to others) based on how much the interviewee has learned.

    In that sense, the questions are perfect.

    (except some of the syntax related ones)

    MK

    bandarupalli
  • yes these bunch of shitty questions are been asked by the interviewers....

    because people like me are kids and people like you are dinosaurs in sql,pl/sql i thought...

    but this is the platform which is connecting masters like you and learners like me so i'm requesting you to get answered ....

    please help us .. if you can...

    thanks in advance

  • SomeoneElse
    SomeoneElse Member Posts: 14,867 Silver Crown

    >  learners like me so i'm requesting you to get answered ....

    OK, but are you really interested in learning or just memorizing some answers to get through the next interview?

This discussion has been closed.