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...

Classes can be created from other classes by using _______________

a) encapsulation b) polymorphism c) inheritance d) attributes e) machine code

Computer Science & Information Technology

The escape sequence \n represents the _____________ character, which causes the cursor to position to the beginning of the next line on the screen.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

In the figure above, item 5 is pointing to the ____.

A. file list displaying subfolders and files for the item B. Navigation pane C. column headings D. details pane

Computer Science & Information Technology

The Presentation Wizard can walk you through creating a new Impress presentation

Indicate whether the statement is true or false

Computer Science & Information Technology