18) Assume that you have a relation R1 and a view V1 that is derived from...

Transcribed Image Text:

18) Assume that you have a relation R1 and a view V1 that is derived from R1; if you execute the following standard SQL code on some DBMS that runs the standard SQL language: Delete table R1 cascade Then the following SQL statement: Select * from V1 What will happen from the following? Choose the correct one and explain: a) The statement Select * from V1" will give error because V1 no longer exist b) The statement Select * from V1" will give error because V1 exists but have binding errors c) The statement" Select * from V1" will execute and give an empty result table 18) Assume that you have a relation R1 and a view V1 that is derived from R1; if you execute the following standard SQL code on some DBMS that runs the standard SQL language: Delete table R1 cascade Then the following SQL statement: Select * from V1 What will happen from the following? Choose the correct one and explain: a) The statement Select * from V1" will give error because V1 no longer exist b) The statement Select * from V1" will give error because V1 exists but have binding errors c) The statement" Select * from V1" will execute and give an empty result table

Answer rating: 100% (QA)

The detailed answer for the above question is provided below Answer ... View the full answer