Answer Posted / ashutosh

Schema is a collection of user defined objects such as
(table,view,procudure,etc..)

How do I call oracle stored procedures that take no parameters?

773

---

How to create a single index for multiple columns?

751

---

Please explain oracle data types with examples?

777

---

What is data type in oracle?

762

---

Explain integrity constraint?

863

---

What is data block in Oracle?

832

---

How to filter out duplications in the returning rows using oracle?

830

---

What are the major difference between truncate and delete?

726

---

Explain the use of record length option in exp command.

798

---

What are the uses of Database Trigger ?

1318

---

What are the attributes of the cursor?

751

---

Can we convert a date to char in oracle and if so, what would be the syntax?

759

---

How to use group functions in the select clause using oracle?

797

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1668

---

What are the tools for Oracle ?

797

---