Answer Posted / richa

In pl/sql we have two types of datatypes
1. scalar
2. composite.

In scalar u can store only one value at a time and
ex is a number(10),name char(1) etc.

While in Composite u can store whole row mean if one row
have 3 columns so u can store 3 values in a composite
datatype variable at a time.
Ex. emp employees%rowtype ;
Mean if enployees have 3 columns so in variable emp u can
store 3 values of 3 columns at a time .

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2231

---

What is flashback in Oracle?

1022

---

How can we view last record added to a table?

1040

---

What is the Tune Query

2295

---

What are the different types of record groups in oracle? Explain each of them

1027

---

How do I uninstall oracle client from windows?

1012

---

How to use existing values in update statements using oracle?

1069

---

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2471

---

What is the difference between formal parameters and actual parameters?

1089

---

How to count groups returned with the group by clause in oracle?

1079

---

What is program global area (pga) in oracle?

1030

---

What would you do with an in-doubt distributed transaction?

1980

---

Explain index?

1264

---

What is an oracle database?

1043

---

What are the limitations of check constraint?

1033

---