Implementing Views: Query Modification vs. Base Tables
4 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is one disadvantage of implementing a view using the approach of query modification?

  • Difficulty in understanding the modified query
  • Increased security vulnerabilities
  • Incompatibility with certain types of databases
  • Inefficiency for views defined via complex queries (correct)

    • When implementing a view using query modification, what happens to the view query?

  • It is replaced with a new query
  • It is converted into a stored procedure
  • It is modified into a query on the underlying base tables (correct)
  • It is executed directly without modification

    • Which of the following is an example of implementing a view using query modification?

  • UPDATE Manager SET Salary = Salary + 10000
  • DELETE FROM Employee WHERE Salary < 50000
  • INSERT INTO Department (Dnumber, Dname) VALUES (5, 'Sales')
  • SELECT Fname, Lname, Dname, Dnumber, Salary FROM EMPLOYEE, DEPARTMENT WHERE SSN=MgrSSN AND Salary > 100000 (correct)

    • What does the text describe as a way to implement a view using query modification?

    <p>Modifying the view query into a query on the underlying base tables</p> Signup and view all the answers

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser