Answer Posted / vinay dixit
please find the advantages as given below :-
a) data security - no need to give permission on the table,
infact a view can be created, having only selected number
of coloums in its definition. So user will only be able to
see those coloums.
b) simplicity - a very complicated query can be saved as a
view defenition. when needed can be called by its view name.
c) removes dependency - Can be very helpful to remove the
dependecny from the underlying tables. Suppose a view is
created by joining several tables. After some time, there
are some changes on the tables, so only defenition of view
can be changed and there is no need to change all the code
where view is used.
d) No space - takes no space ( except materialized view )
Is This Answer Correct ? | 61 Yes | 4 No |
Post New Answer View All Answers
What is db journal file?
Can primary key be changed?
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
Explain what is table in a database?
How many types of functions are there in sql?
Why is stored procedure faster than query?
Can you join a table to itself?
what are the authentication modes in sql server? How can it be changed? : Sql dba
How do I count rows in sql query?
What is bind reference and how can it be created?
What is the difference between truncate and drop statements?
Why is nosql good?
What are the packages in pl sql?
Which sql statement is used to delete data from a database?
What are the possible values for the boolean data field?