Define oracle database

1045

---

Explain oracle instance.

1180

---

What is ceil and floor in oracle?

1069

---

Can a parameter be passed to a cursor?

1126

---

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

1068

---

Explain user account with reference to oracle.

990

---

Explain constraining triggers.

1096

---

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

1086

---

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

1006

---

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

1022

---

Explain oracle’s system global area (sga).

1139

---

Differentiate between function and procedure in oracle.

1077

---

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

1045

---

Which are the five query types available in oracle?

949

---

Explain parameter file in oracle.

1029

---