Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


    • Create BookmarkCreate Bookmark
    • Create Note or TagCreate Note or Tag
    • PrintPrint
    Share this Page URL
    Help

    Self Test Answers

    Implement a View

    1. A. An indexed view index must be unique, and the view must have been created with the schema binding option enabled.

    B, C, and D are incorrect.

    2. C. This is the only accurate statement. The sp_addview system procedure does not exist.

    A, B, and D are incorrect.

    3. B. Views are queried in exactly the same manner as a standard table.

    A is incorrect.

    4. B. Because indexed views are materialized, updates to the underlying table requires updates to the view.

    A, C, and D are incorrect.

    5. A. The same GRANT statement that is used to give SELECT access to a table is used to give SELECT access to a view.

    B, C, and D are incorrect.


      

    You are currently reading a PREVIEW of this book.

                                                                                            

    Get instant access to over
    $1 million worth of books and videos.

      

    Start a Free Trial