Answer / Pankaj Raj

A package in PL/SQL is a collection of related programming units, such as functions, procedures, types, and variables, that can be accessed by multiple programs. Packages allow for modularization, encapsulation, and reusability of code.

what is difference between procedure and function

10 Answers   MCN Solutions, Wipro,

---

How to fetch records from a partitioned table?

2 Answers   HSBC,

---

What is self-join and what is the requirement of self-join?

1 Answers  

---

What is schema in sql?

1 Answers  

---

1. Which is an aggregate function? a. Union b. like c. max d. Rank

1 Answers   Fintellix,

---

How do you optimize a stored procedure in sql?

1 Answers  

---

Can we rename a column in the output of sql query?

1 Answers  

---

What is lexical units in pl sql?

1 Answers  

---

What is normalization sql?

1 Answers  

---

what is a database transaction? : Sql dba

1 Answers  

---

Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index

2 Answers   Polaris,

---

Why primary key is required?

1 Answers  

---