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

1085

---

Explain user account with reference to oracle.

1000

---

Explain constraining triggers.

1108

---

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

1110

---

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

1022

---

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

1039

---

Explain oracle’s system global area (sga).

1158

---

Differentiate between function and procedure in oracle.

1095

---

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

1071

---

Which are the five query types available in oracle?

966

---

Explain parameter file in oracle.

1044

---

Is a rollback possible to any savepoint?

1113

---

Give the various rollback segment states.

1062

---

Explain cascading triggers.

1087

---

What is a mutating table and a constraining table?

1128

---