1.

State The Differences Between Database View & Projection View?

Answer»

The BASIC differences between projection view and DATABASE view are:

  • Database view can built over many tables whereas projection view can be built over a single table only.
  • Database view can be updated if the view is built over a single table whereas in projection view data can be updated.
  • In case of database view, data updates can USE open SQL or native SQL whereas in case of projection view, data updates MUST use open SQL.
  • Database view can be BUFFERED whereas Projection view cannot be buffered.

The basic differences between projection view and database view are:


Discussion

No Comment Found

Related InterviewSolutions