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

Is oracle an operator?

899

---

Explain what are the characteristics of data files?

1045

---

In which language oracle has been developed?

1030

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

978

---

What is a table in oracle?

946

---

How do I spool in oracle?

958

---

What happens if recursive calls get out of control?

1029

---

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

2159

---

How can you merge two tables in oracle?

955

---

What is the parameter mode that can be passed to a procedure?

999

---

query optmization techniques and quwry analyser+projects+ppts

2383

---

How to delete a user account in oracle?

927

---

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2317

---

Differentiate between pre-select and pre-query?

1063

---

How to get a create statement for an existing table?

925

---