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:
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.
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;
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:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers