what is a view?

Answers were Sorted based on User's Feedback



what is a view?..

Answer / rad

view is a stored query and does not store any table data.

Is This Answer Correct ?    2 Yes 0 No

what is a view?..

Answer / s. senthil kumar

A view is a virtual table. Every view has a Query attached
to it. (The Query is a SELECT statement that identifies the
columns and rows of the table(s) the view uses.)

Is This Answer Correct ?    1 Yes 0 No

what is a view?..

Answer / senthil kumar

View is the virtual table. It is DML statement.

Is This Answer Correct ?    1 Yes 0 No

what is a view?..

Answer / 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 This Answer Correct ?    0 Yes 0 No

what is a view?..

Answer / guest

View is used to viewing the data and not for manipulating
it.

Is This Answer Correct ?    0 Yes 0 No

what is a view?..

Answer / manjunath k

a view consists of a stored query accessible as a virtual
table composed of the result set of a query.

Is This Answer Correct ?    0 Yes 0 No

what is a view?..

Answer / sunil maurya

A view is simply the representation of a SQL statement that
is stored in memory so that it can easily be re-used. For
example, if we frequently issue the following query

SELECT empid FROM emp;

I might well want to make this a view (the reality is that
we would probably never create a view for a statement this
simple but we wanted to use an easy example).

To create a view use the create view command as seen in this
example
CREATE VIEW view_emp
AS
SELECT empid FROM emp;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

What is a user role in oracle?

0 Answers  


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  


How to see free space of each tablespace?

0 Answers  


Explain a data segment?

0 Answers  


How to apply filtering criteria at group level in oracle?

0 Answers  






What would you use to improve performance on an insert statement that places millions of rows into that table?

1 Answers  


What is an Index ? How it is implemented in Oracle Database ?

4 Answers  


What are the oracle built-in data types?

0 Answers  


What do you mean by a database transaction & what all tcl statements are available in oracle?

0 Answers  


I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?

2 Answers   Zensar,


How does oracle handle read consistency?

0 Answers  


How to Remove the 3rd highest salary person record from table?

9 Answers   HCL, IBM,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)