Answer Posted / sunitha
View is a logical representation of subset of data.
there are simple,complex and materialized views.
View does't take any space in database.
view are used for security purpose.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many postgresql users are there, worldwide?
In what condition is it good to disable a trigger?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
how to use 'mysql' to run sql statements? : Sql dba
What is restrict in sql?
how many columns can be used for creating index? : Sql dba
Can you have more than one trigger on a table?
What is java sql connection?
what are the performance and scalability characteristics of mysql? : Sql dba
what are the different index configurations a table can have? : Sql dba
What is sql used for?
How do you truncate?
What is application trigger?
What are the possible values for the boolean data field?
How does index help in query performance?