Explain what happens when you create a query that involves a view.

What will be an ideal response?


When you create a query that involves a view, SQL changes the query to one that selects data from the table(s) in the database that created the view. The query that uses the view is merged with the query that defined the view to form the query that is actually executed.

Computer Science & Information Technology

You might also like to view...

A constructor

a. can only be used to initialize b. must initialize all member variables c. can do anything any other method can do. d. usually initializes all, or most, member variables

Computer Science & Information Technology

Objects drawn or moved on top of other objects merge with or ____________________ the existing objects.

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

Computer Science & Information Technology

A sparkline is

A) is a label that describes either the category axis or the value axis. B) is a label that describes the chart. C) a miniature chart contained in a single cell. D) is the value or name of a data point.

Computer Science & Information Technology

Program ____________________ consists of the instructions written using a programming language that ultimately can be executed by a computer.

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

Computer Science & Information Technology