Database - SQL for Database Construction - Discussion

Discussion Forum : SQL for Database Construction - General Questions (Q.No. 6)
6.
To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
a particular column in a particular underlying table.
a particular column in a particular row.
a particular row in a particular underlying table.
None of the above is correct.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
6 comments Page 1 of 1.

Pranit said:   9 years ago
We create a view with the help of rows and columns, it means that we pick up the specific rows from a particular column from a table and creates a view.

So in the question They are saying that DBMS must associate a column with?

If we modify the view means we selecting less or greater number of rows from that column in a specific table and modify the table.

So DBMS must associate a column with a particular row in a particular underlying table.

So the answer is C.

Nisha said:   9 years ago
I am not able to understand. how did it happen?
(1)

Rupali said:   10 years ago
I am not able to understand, how its happens?

Asshvin Ade said:   1 decade ago
Question is not for simple update command, it's question about VIEW (i.e virtual table) update command.

Dileep said:   1 decade ago
update table_name
set column_name= newvalue
where condition;

ex:

alter emp
set sal=1500
where sal=1100;

Nitesh said:   1 decade ago
Can anyone please explain me how this happen?

Post your comments here:

Your comments will be displayed after verification.