Explain the conceptual di?erence between views and bulk insertion of tuples into base relations using the INSERT statement with an attached query.

What will be an ideal response?

Tuples in a view are not materialized, i.e., they are computed on demand. In contrast, when tuples are inserted into a relation using bulk INSERT they physically exist on the disk.

Computer Science & Information Technology

You might also like to view...

Before you import Excel data into Access, it is good practice to remove ________

A) data labels B) blank rows C) column headings D) all charts

Computer Science & Information Technology

The only way to empty the Recycle Bin is to empty it manually

Indicate whether the statement is true or false

Computer Science & Information Technology