Define oracle database

1040

---

Explain oracle instance.

1171

---

What is ceil and floor in oracle?

1067

---

Can a parameter be passed to a cursor?

1115

---

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1066

---

Explain user account with reference to oracle.

973

---

Explain constraining triggers.

1090

---

What is the maximum limit on the number of columns in a table?

1079

---

Why do you create or replace procedures rather that drop and recreate.

1003

---

How would you change old and new values in an insert, delete and update triggers?

1015

---

Explain oracle’s system global area (sga).

1136

---

Differentiate between function and procedure in oracle.

1071

---

Give the constructs of a package, function or a procedure.

1033

---

Which are the five query types available in oracle?

947

---

Explain parameter file in oracle.

1022

---