Answer Posted / samir

You can have 1 each INSTEAD OF trigger for INSERT, UPDATE,
and DELETE.

You can have as many AFTER triggers as you want up to the
limit of the total maximum number of SQL Server objects.

Within AFTER triggers, you can have only 1 FIRST and 1 LAST
trigger for INSERT, UPDATE, and DELETE.

This information is available in Books Online
under "Triggers".

Give the different types of rollback segments.

1031

---

How will you identify oracle database software release?

1010

---

What is a trigger and what are its types in oracle?

1073

---

Differentiate between pre-select and pre-query?

1107

---

How to call a stored function with parameters?

1046

---

How to set up autotrace for a user account?

1059

---

How to rename an index?

1073

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

2007

---

How to open and close an explicit cursor in oracle?

1058

---

What are the execution control statements?

1065

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4366

---

How to drop a stored procedure in oracle?

1051

---

what are the advantages of running a database in archive log mode?

2203

---

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2209

---

What are the restrictions in a oracle read only transaction?

1036

---