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.
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
In object-oriented terminology, you "____" a segment of code that might cause an error.
A. try B. catch C. throw D. observe
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
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