Define oracle database

998

---

Explain oracle instance.

1117

---

What is ceil and floor in oracle?

1017

---

Can a parameter be passed to a cursor?

1059

---

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

1017

---

Explain user account with reference to oracle.

933

---

Explain constraining triggers.

1047

---

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

1020

---

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

954

---

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

958

---

Explain oracle’s system global area (sga).

1085

---

Differentiate between function and procedure in oracle.

1024

---

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

990

---

Which are the five query types available in oracle?

908

---

Explain parameter file in oracle.

980

---