Answer Posted / roopesh kumar

A view is a logical db object which is created for data
security, data hiding etc. In database onle views
defination stored.

Syntax: create or replace view name_vw as select col1,
col2, ......... from table1, table2 where ....;

Types: (1) simple view
(2) complex view
(3) read only view
(4) force view
(5) with check option

Point the difference between translate and replace?

1144

---

Explain what are synonyms used for?

1091

---

What are the types of trigger in oracle?

1024

---

How to lock and unlock a user account in oracle?

1157

---

What to do if the binary spfile is wrong for the default instance?

1106

---

Explain the use of indexes option in imp command.

1252

---

what is the dual table in oracle?

1036

---

What is meant by a deadlock situation?

1148

---

How to synchronize 2 schema's objects?

2230

---

How can we force the database to use the user specified rollback segment?

1191

---

How to create a single index for multiple columns?

1077

---

What do you know about normalization? Explain in detail?

995

---

Explain an index segment?

1154

---

Name the various constraints used in oracle?

1073

---

How to start a specific oracle instance?

1077

---