OraFAQ Forum: Training & Certification » Query For PL SQL Opportunity

Home » Other » Training & Certification » Query For PL SQL Opportunity

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query For PL SQL Opportunity [message #678937]

Thu, 23 January 2020 01:14

adisharma
Messages: 1
Registered: January 2020

Junior Member

Hello Everyone, I am new here and want to know more PL SQL interview questions, Is there any reference to provide me top interview questions list or provide any kind of tips? I want to know which types of questions have put in technical interviews. I have search on google to find it but I want to know as a fresher level questions and I want to prepare myself, I have almost completed my course and looking for a good opportunity. Kindly suggest me please some tips and tricks.

Report message to a moderator

Re: Query For PL SQL Opportunity [message #678952 is a reply to message #678937]

Thu, 23 January 2020 11:49

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

How about the Oracle documentation? That should be the first place to check. Also, there are so many online tests to practice. If your focus is only to crack the interview somehow, then you are missing out on learning front. There are no tricks to learning, you need to like what you are learning. As you said you are a beginner, I would suggest stick to understanding the basics and have 100% clarity. Nobody would expect real world knowledge if you have no experience, they will look for how much you have learned and understood the basics.

Also, if it interests you, then you could prepare for OCA developer certification. Preparation will give you insights, and later stage when you are comfortable you could go for the certification as well.

[Updated on: Thu, 23 January 2020 11:52]

Report message to a moderator

Re: Query For PL SQL Opportunity [message #679040 is a reply to message #678952]

Thu, 30 January 2020 05:52

rohanjoshi0894
Messages: 2
Registered: January 2020

Junior Member

here is the list of interview question which you can refer for the interviews:
Question: What is PL/SQL?
Question: What are the differences between PL/SQL and SQL?
Question: What is the basic structure of PL/SQL?
Question: Define cursor and its use.
Question: Why do we use database triggers? Give the syntax of a trigger.
Question: How do you compile PL/SQL code?
Question: Explain exception handling in PL/SQL.
Question: Tell about a few data types in PL/SQL.
Question: What is the difference between %TYPE and %ROWTYPE? Give an example.
Question: What constitutes a PL/SQL package?
Question: List some schema objects that are created using PL/SQL.
Question: Explain the difference between procedure and function.
Question: Explain the difference between procedure and trigger.
Question: What are the different types of cursors in PL/SQL?
Question: What are the different types of constraints?
Question: What are the differences between triggers and constraints?
Question: Explain different types of PL/SQL blocks.
Question: Explain PL/SQL Records.
Question: Explain the difference between commit and savepoint.
Question: What is the difference between actual and formal parameters?
Question: How is a DECLARE statement used?
Question: Tell us about SQLCODE and SQLERRM.
Question: What is rollback? How is it different from rollback to statement?
Question: What is IN OUT parameter?
Question: Is it possible to accept user inputs during runtime? How?
Question: Give a simple way to run a query faster.
Question: What are some of the pre-defined exceptions in PL/SQL?
Question: How do you trace the PL/SQL code?
Question: How to restrict string length in PL/SQL?
Question: What is the purpose of the UTL_FILE package in PL/SQL?
Question: What are DBMS_OUTPUT and DBMS_DEBUG?
Question: List some cursor attributes in PL/SQL.
Question: What is the purpose of NVL?
Question: On a table, how many triggers can be applied?
Question: How can we achieve consistency using PL/SQL?
Question: Write a simple procedure to select some records from the database using some parameters.
Question: Explain the error ORA-03113.
Question: Can you use IF statement inside a SELECT statement? How?
Question: What is SYS.ALL_DEPENDENCIES?
Check here the solution of these PL-SQL interview questions.

Report message to a moderator