Define 'view' advantage ?
Answers were Sorted based on User's Feedback
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 |
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 |
What are joins, explain all types of joins?
why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?
How to initialize variables with default values?
Why should I use oracle database?
What is oracle in java?
How to loop through a cursor variable?
What is the difference between an Oracle Schema and an Oracle Instance?
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
What are set operators?
What is a Segment ?
How to concatenate two text values in oracle?
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?