Home » Other » Training & Certification » Query For PL SQL Opportunity
Query For PL SQL Opportunity [message #678937] Thu, 23 January 2020 01:14 Go to next message
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.
Re: Query For PL SQL Opportunity [message #678952 is a reply to message #678937] Thu, 23 January 2020 11:49 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3171
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 Go to previous messageGo to next message
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.
Re: Query For PL SQL Opportunity [message #679047 is a reply to message #679040] Thu, 30 January 2020 10:27 Go to previous messageGo to next message
Michel Cadot
Messages: 67370
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Would you mind to post the solution of each question here.

Re: Query For PL SQL Opportunity [message #679048 is a reply to message #679047] Thu, 30 January 2020 10:41 Go to previous messageGo to next message
rohanjoshi0894
Messages: 2
Registered: January 2020
Junior Member
Michel Cadot wrote on Thu, 30 January 2020 10:27

Would you mind to post the solution of each question here.

Yes I can, but there is a post from where you can refer all the answer of these questions:

[Edit MC: URL removed]

[Updated on: Thu, 30 January 2020 11:39] by Moderator

Report message to a moderator

Re: Query For PL SQL Opportunity [message #679050 is a reply to message #679048] Thu, 30 January 2020 11:39 Go to previous message
Michel Cadot
Messages: 67370
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So you are just a spammer.

Previous Topic: ISP Supplies | MikroTik MTCNA Training
Next Topic: Hi
Goto Forum:
  


Current Time: Mon Sep 28 04:53:57 CDT 2020