IST 272 Module 2

Card Set Information

IST 272 Module 2
2013-07-24 16:28:32
database sql server

IST 272 Module 2 Flashcards. Stored Procedures, Triggers, and Functions
Show Answers:

  1. What is a view?
    A "virtual table" or a stored SELECT query
  2. What is a view used for?
    To retrieve and modify data
  3. Name three modifications you can make while using a view?
    Insert, update, and delete records
  4. A view that uses these functions will nullify the ability to modify the data contained within
    Aggregate functions
  5. What is an indexed view
    This type of view will help you speed up complex queries such as calculations and data manipulation queries
  6. What is the query optimizer?
    The component in SQL Server that analyzes your query, compares them with available indexes, and decides which index returns a result set the fastest.
  7. What is a stored procedure?
    Predefined batch of code stored as an object in the database to do work.
  8. What is T-SQL and CLR?
    Two types of code used for User Stored Procedures
  9. What is the keyword OUTPUT?
    If you omit this keyword when you execute the stored procedure, the stored procedure still completes but does not return the modified value.
  10. When SQL Server process a stored procedure, the Query Optimizer first checks the procedure cache for this.
    an already in memory execution plan
  11. A trigger has the same functionality as this
    stored procedure
  12. Fires automatically when the event where it is defined occurs- it can never be called directly
  13. Two types of triggers found in SQL Server
    DDL and DML
  14. These triggers execute automatically when an action such as insert, delete, and/or update executes against a table or view
    DML triggers
  15. Names for tables created by a trigger
    inserted and deleted
  16. The default behavior of a trigger takes place as this action
    AFTER action
  17. These triggers fire on CREATE, ALTER, and DROP statements
    DDL triggers
  18. Name the two parts of CTEs
    • WITH clause containing SELECT statement
    • and outer SELECT statement
  19. Two types of subqueries
    correlated and non-correlated
  20. This type of subquery depends and references columns from the outer query