Define 'view' advantage ?

Answer Posted / deva

view is the window for the data stored in the table(s). It
is the pointer to the data, will not store any data with in it.

more secure to the unauthorized data.
Time complexity reduces when we are accessing the data.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain an exception?

558


What is the difference between 10g OEM and 11g OEM?

556


Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1569


From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

579


How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

1795






Explain the importance of .pll extension in oracle?

546


What is the difference between view and materialized view in Oracle?

595


Why does oracle 9i treat an empty string as null?

530


How to store only time; not date and time?

548


What is key preserved table?

554


Explain enable novalidate constraint.

591


Explain an index?

654


Difference between the “verify” and “feedback” command?

757


What are a collation and state the different types of collation sensitivity?

543


State all possible different index configurations a table can possibly have?

558