Define 'view' advantage ?

Answers were Sorted based on User's Feedback



Define 'view' advantage ?..

Answer / o.nagamani

View is a virtual storage of the original table.It is the
one kind of data hiding.

Advantages of View:
1. Restrict Data Access and/or simplify data access.
2. Simplify Data manipulation.
3. Import and Export data.
4. Merge Data.

Is This Answer Correct ?    12 Yes 3 No

Define 'view' advantage ?..

Answer / 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

More Oracle General Interview Questions

How to recover a dropped table in oracle?

0 Answers  


how can db_files > maxdatafiles since db_files is for instance and the later is for database

0 Answers   CTS,


Explain the use of rows option in exp command.

0 Answers  


What is an Integrity Constrains ?

3 Answers  


Can anyone give me information about oracle certification

1 Answers  






Explain the family trees and connection by clause

0 Answers  


What is a user role in oracle?

0 Answers  


What is materialized view in Oracle?

0 Answers   MCN Solutions,


What is the string concatenation operator in oracle?

0 Answers  


What is the relation of a user account and a schema?

0 Answers  


There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep

4 Answers   Microsoft,


What are joins..how many types of joins are there?

29 Answers   Amdocs, CSC, TCS,


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)