If a View on a single base table is manipulated will the changes be reflected

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

If a View on a single base table is manipulated will the
changes be reflected on the base table?

Question Posted / guest

5 Answers
14640 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

If a View on a single base table is manipulated will the changes be reflected on the base table?..

Answer / ehsraka

Yes, definitely. Since the view is based on a single table
and falls within the cateogory of simple view. Any change /
modification on the records will be reflected in the base
table.

Is This Answer Correct ?

8 Yes

0 No

If a View on a single base table is manipulated will the changes be reflected on the base table?..

Answer / tulsi

yes it will be reflected in the base table

Is This Answer Correct ?

7 Yes

3 No

If a View on a single base table is manipulated will the changes be reflected on the base table?..

Answer / aks

Depends on privileges granted to view (select,insert,update);

Is This Answer Correct ?

4 Yes

1 No

If a View on a single base table is manipulated will the changes be reflected on the base table?..

Answer / naresh

Hi

Not only on a single based table, changes made on a view
which created on multiple tables also will update on base
tables,if the relation ship between primary key and Foreign
key relationships are proper and if the Integrity
constraints are mentioned.

Cheers!
Naresh

Is This Answer Correct ?

4 Yes

1 No

If a View on a single base table is manipulated will the changes be reflected on the base table?..

Answer / papal

yes if there is no use of "CHECK WITH option"
then definitally chnages in view affects the base table

Is This Answer Correct ?

3 Yes

1 No

Post New Answer

More SQL PLSQL Interview Questions

What is raw datatype in sql?

0 Answers

SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.

3 Answers

What are crud methods?

0 Answers

What are conditional predicates?

0 Answers

What is the difference between partitioning and sharding?

0 Answers

what is the difference between implicit and explicit trigger

2 Answers Tech Mahindra,

what is primary key? : Sql dba

0 Answers

What is the difference between a database and a relational database?