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 Remove the 3rd highest salary person record from table?

9 Answers   HCL, IBM,


1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

1 Answers   Wipro,


difference between procedures and function?

7 Answers   IBM,


How to invoke the data pump export utility?

0 Answers  


What is oracle open database communication (odbc)?

0 Answers  






How to get a list of all background sessions in the database?

0 Answers  


Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?

3 Answers  


Can I create users through internet explorer in oracle 10g?

0 Answers   MCN Solutions,


Explain cascading triggers.

0 Answers  


How do we create privileges in oracle?

0 Answers  


If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

7 Answers   IBM,


What are the parameters that we can pass through a stored procedure?

0 Answers  


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)