Ssdo Quiz For Aptech (SQL Server 2005)

84 Questions | Total Attempts: 1714

SettingsSettingsSettings
Please wait...
SQL Server Quizzes & Trivia

How to learn well SSDO


Related Topics
Questions and Answers
  • 1. 
    The Cursor Stored Procedures are.........- 2 true choices.
    • A. 

      sp_describe_column

    • B. 

      Sp_indexs

    • C. 

      Sp_primarykeys

    • D. 

      Sp_cursor_list

    • E. 

      A and D

  • 2. 
    All information  about tables in user Database  is stored in a set of tables called the System catalog.that can be accessed using........- 1 true choice.
    • A. 

      Sercurity Stored Procedures

    • B. 

      Catalog Stored Procedures

    • C. 

      Distributed Query Stored Procedures

    • D. 

      A and B

    • E. 

      User-define Stored Procedures

  • 3. 
    Where are Catalog Stored Procedures ?-2 true choices
    • A. 

      Sp_column

    • B. 

      sp_addalias

    • C. 

      Sp_describe_cursor

    • D. 

      Sp_database and sp_statistics

    • E. 

      A and C

  • 4. 
    The Stored procedures use to manage the security of the database. They are:-1 true choice.
    • A. 

      Database Mail and SQL mail stored Procedures

    • B. 

      Cursor Stored Procedures.

    • C. 

      Sercurity Stored Procedures

    • D. 

      Database Mail and SQL mail stored Procedures.

    • E. 

      Distributed Query Stored Procedures

  • 5. 
    Database Mail and SQL mail stored Procedures.- 1 true choice.
    • A. 

      Used to pefrom email operations from with in the SQL server.

    • B. 

      Use in the management of distributed queries.

    • C. 

      Use to implement the fuctionality of a Cursor.

    • D. 

      Use to manage the security of the DB.

    • E. 

      Send mail to the SQL server.

  • 6. 
    The Stored Procedure - 2 true choices.
    • A. 

      Is a set of pre-compiled T-SQL statements executed as a single unit.

    • B. 

      Is a set of T-SQL that are executed as a single block of code that performs a specific task.

    • C. 

      Is used in database Administrative and information activities.

    • D. 

      Can be created to carry out repetitive

    • E. 

      All of about.

  • 7. 
    The ........is used to change the owner of the current database.-1 true choice.
    • A. 

      Sp_cursor_list

    • B. 

      Sp_changedbowner

    • C. 

      Sp_addalias

    • D. 

      Sp_describe_column

    • E. 

      A and D

  • 8. 
    Advantages of The Store Procedures are:
    • A. 

      Reduced client/server traffic

    • B. 

      Can be created to carry out repetitive

    • C. 

      Reuse of code.

    • D. 

      A and B

    • E. 

      B and D

  • 9. 
    Which  are not System Stored Procedures?-2 true choices.
    • A. 

      Distributed Query Stored Procedures

    • B. 

      Extended Stored Procedures

    • C. 

      Temporary Stored Procedures

    • D. 

      Database Mail and SQL mail stored Procedures.

    • E. 

      Cursor Stored Procedures

  • 10. 
    The Stored procedures  are created for temporary use with a session are called...- 1 true choice.
    • A. 

      Local Temporary Procedures

    • B. 

      Global Temporary Procedures

    • C. 

      Remote Stored Procedures

    • D. 

      Temporary Stored Procedures

    • E. 

      Customer Stored Procedures

  • 11. 
    The..............are used to perform tasks that are unable to be perform using standard T-SQL statement.- 1 true choice
    • A. 

      Extended Stored Procedures.

    • B. 

      T-SQL Stored Procedures

    • C. 

      Local stored Procedures

    • D. 

      B and C

    • E. 

      Not of about

  • 12. 
    The................are not residents of SQL server. they are implemented as Dynamic Link Libraries(DLL) executed outsite the SQL Sever Environment.- 1 true choice.
    • A. 

      Remote Stored Procedures

    • B. 

      Temporary Stored Procedures

    • C. 

      Extended Stored Procedures.

    • D. 

      B and C

    • E. 

      Customer Stored Procedures

  • 13. 
    The ...................are created individual user databases.And  can not be accessed by any user other than the one who has created it.- 1 true choice
    • A. 

      Extended Stored Procedures

    • B. 

      Temporary Stored Procedures

    • C. 

      Local stored Procedures

    • D. 

      Global Temporary Procedures

    • E. 

      B and C

  • 14. 
    The Global Tem Procedures  ....- 3 true choices
    • A. 

      Are dropped at the end of the last session.

    • B. 

      Are dropped at the end of the current session

    • C. 

      Can only be used by its owner

    • D. 

      Can be used any user

    • E. 

      Are visible for all users

  • 15. 
    Temporary Stored Procedures include:- 2 true choices
    • A. 

      Local Temporary Procedures

    • B. 

      Global Temporary Procedures

    • C. 

      Local stored Procedures

    • D. 

      Customer Stored Procedures

    • E. 

      A and C

  • 16. 
    EXECUTE xp_fileexists 'C:\sample.txt' - 1 true choice.
    • A. 

      Check file sample.txt exists.

    • B. 

      Check file sample.txt exists or not

    • C. 

      Execute a file is named sample.txt

    • D. 

      A and C

    • E. 

      Not all about

  • 17. 
    OBJECT_DEFINITION() - 2 choices
    • A. 

      System stored procedure use to display the dependencies of a stored procedure

    • B. 

      System function used to display the definition of a stored procedure.

    • C. 

      System view used to display definition of a stored procedure.

    • D. 

      System function used to display the definition of a stored procedure by specifying the object ID of the procedure.

    • E. 

      A and D

  • 18. 
    The...............create stored procedures for performance of various tasks, they are referred  to as user-defined or custom stored procedures and can be set to override the default system procedures.- 1 true choice.
    • A. 

      Extended Stored Procedures

    • B. 

      Customer Stored Procedures

    • C. 

      T-SQL Stored Procedures

    • D. 

      System Stored Procedures

    • E. 

      A and D

  • 19. 
    Using "OUTPUT" clause.- 2 true choice
    • A. 

      Return information from each row on which the INSERT, UPDATE, and DELETE have been executed.

    • B. 

      Create stored procedures for performance of various tasks, they are referred to as user-defined or custom stored procedures

    • C. 

      Useful to retrieve the value of an identity or computed column after an INSERT or UPDATE operation

    • D. 

      Print out a Variable.

    • E. 

      E and C

  • 20. 
    When a local temporary table is created inside a stored procedures, the table disappears when the procedure is exited.
    • A. 

      False

    • B. 

      True

  • 21. 
    System stored procedure used to display the definition of a stored procedure?-1 true choice.
    • A. 

      Object_definition()

    • B. 

      Sp_helptext

    • C. 

      Sp_depends

    • D. 

      Sys.sql_modules

    • E. 

      Sp_display

  • 22. 
    A Stored Procedure can reference tables,views, user-define functions and other
    • A. 

      True

    • B. 

      False

  • 23. 
    The permission associated with the stored procedure are not lost when a store procedure is re-created. And when a stored procedure is altered, the permissions defined for the stored procedure remain the same even though the procedure definetion is changeed
    • A. 

      True

    • B. 

      False

  • 24. 
    Everyone can  modify or rename all procedure.
    • A. 

      True

    • B. 

      False

  • 25. 
    Stored procedures can be dropped if they are no longer needed. if another stored procedure calls a deleted procedure,- 1 choice.
    • A. 

      A replaced procedure is dipslay.

    • B. 

      An error message is display.

    • C. 

      No procedure display

    • D. 

      B and C

    • E. 

      None about