Answer Posted / dinesh

Type CC is Varray(5) of number;
c CC:=CC(1,2,3,4,5);
Begin
c.trim /* Delete last 5th Element with thier place holder from varray*/
c.trim(3)/*remove last 3 element with thier place holder from varra
c.delete/* delete all the varray.

What is archive log in Oracle?

1184

---

How to create an oracle testing table?

1128

---

What is oracle datasource?

1041

---

When do you get a .pll extension in oracle? Explain its importance

1099

---

What's dateware house and what's clustor with practicle example

2236

---

How to define an anonymous procedure with variables?

1242

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

1036

---

Explain do view contain data?

1052

---

How data locks are respected in oracle?

1113

---

Explain the different normalization forms?

1157

---

What is the relation of a user account and a schema in oracle?

1126

---

How to manage transaction isolation level?

1057

---

Explain rename?

1045

---

Why is oracle so popular?

1055

---

State all possible different index configurations a table can possibly have?

1104

---