Define oracle database

1101

---

Explain oracle instance.

1234

---

What is ceil and floor in oracle?

1124

---

Can a parameter be passed to a cursor?

1182

---

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

1141

---

Explain user account with reference to oracle.

1031

---

Explain constraining triggers.

1167

---

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

1156

---

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

1072

---

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

1081

---

Explain oracle’s system global area (sga).

1189

---

Differentiate between function and procedure in oracle.

1157

---

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

1098

---

Which are the five query types available in oracle?

1002

---

Explain parameter file in oracle.

1085

---