UrbanPro
true

Learn Database Training from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

Interview questions on Packages in Oracle

Gavi Y.
24/12/2016 0 1

Let me list few standard questions asked in the interviews on plsql package.

1. Why packages are used? What are it's advantages?

2. Name few bulin-in Oracle packages.

3. Can we have a function or procedure declared in Package specification and not defined in package body and why?

4. Can we have a function or procedure not declared in Package Specs and defined in Package body alone?

5. What are private components in Plsql packages?

6. Can we have only a Package specification and no body at all? If yes, under what circumstances? Such a Package specification would be compiled without errors?

7. Can we have Package body alone and no Specs? Will it be compiled without errors?

8. What is overloading and how is it accomplished in Oracle?

9. What are restrictions on overloading?

10. What are differences between and advantages/disadvantages of stand alone and packaged procedures/Functions?

11. What is forward declaration?

12. What are the disadvantages of Pacakges?

13. What is session varibale and how is it defined in package?

14. How Packages improve or degrade performance?

15. What is pragma serially_reusable and why is it used?

These questions actually cover the entire lesson on Plsql Packages.

 

 

 

0 Dislike
Follow 0

Please Enter a comment

Submit

P

Pooja K | 17/08/2021

Would you please share answers to these questions?

0 0

Other Lessons for You

PowerPivot For Excel
PowerPivot is an add-in for Microsoft Excel 2010 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous...

Pl SQL Cursors
To process an SQL statement, ORACLE needs to create an area of memory known as the context area; this will have the information needed to process the statement. This information includes the number...

New features of Oracle 23ai
2 of the new features of Oracle 23ai (previously Oracle 23c) with respect to SQL are discussed. 1. Boolean datatype included in SQL. Previously, boolean was not part of SQL, but belonged to Oracle...

Try too choose suitable industry which will give more happyness
In any industry, if its suitable and if its more interest then every body can create wonders. So let choose which is best suitable to you mean while dont think u want to become no 1. As per your capabilities,...
K

K C Reddy

0 0
0

10 Best Job Interview Tips for Jobseekers
10 Best Job Interview Tips for Jobseekers:- 1. Conduct Research on the Employer, Hiring Manager, and Job Opportunity2. Review Common Interview Questions and Prepare Your Responses3. Dress for Success4....

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more