Answer Posted / krishna

12 triggers

What is transaction control statement and how many types of transaction control statement in Oracle?

1235

---

How to connect the oracle server as sysdba?

1131

---

Differentiate between pre-select and pre-query?

1153

---

What is pragma autonomous transaction in oracle?

1123

---

Explain coalesce function?

1250

---

What are a query and state the different types of queries and their uses?

1064

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2191

---

Is there a combination of "like" and "in" in sql?

1114

---

Explain oracle data types with examples?

1080

---

How to rename a column in an existing table?

1083

---

What is meant by a deadlock situation?

1154

---

How to define a data field as not null?

1162

---

When system tablespace is created?

1090

---

Which are the five query types available in oracle?

999

---

How to empty your oracle recycle bin?

1075

---