What are the advantages of Views ?

Answer Posted / nishi

- Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table.

- Hide data complexity.

- Simplify commands for the user.

- Present the data in a different perspective from that of the base table.

- Store complex queries.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the usage of control file in oracle?

619


How to unlock the sample user account in oracle?

566


How to divide query output into groups in oracle?

567


What is Undo Management Advisor in Oracle?

618


Write a syntax for update query in oracle?

628






How to use like conditions in oracle?

581


What are the types of trigger in oracle?

583


Explain index?

757


HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1003


What is a static data dictionary in oracle?

578


Explain the use of online redo log files in oracle.

597


What is the difference between translate and replace?

569


Which environment variables are absolutely critical in order to run the OUI?

1668


What is literal?

597


what is difference between sql plus and sql*plus? (not sql and sql plus).

3358