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

When you open Access 2007, you can retrieve your recently viewed databases on the right side of the menu

Indicate whether the statement is true or false

Computer Science & Information Technology

In object-oriented terminology, you "____" a segment of code that might cause an error.

A. try B. catch C. throw D. observe

Computer Science & Information Technology

In Outline view,a small gray circle next to a paragraph indicates _____.?

A. ?the text is body text and not a heading B. ?that every heading has subordinate text C. ?the text is a heading and not body text D. ?that there is body text below every heading

Computer Science & Information Technology

Case-Based Critical Thinking Questions ? Case 1-2 Kamilla is creating a presentation about her family for a homework assignment. Her friend Ivan, a PowerPoint 2016 expert, is helping her. ? ? Once Kamilla decides to work with the Title slide she sees that it has two ____.

A. picture tabs B. contextual tabs C. text placeholders D. picture placeholders

Computer Science & Information Technology