Question 10


Answer A is correct. database_principals refers to anything that security can be assigned to, such as a user, role, and so on. sys.objects (sysobjects) holds information about all objects in the current database and needs a WHERE clause to limit the listing to user only (Type = U) objects.

For more information, see the following sources:

  • Chapter 6, "Database Maintenance"

  • SQL Server 2005 Books Online: "SQL Server Database Engine, System Stored Procedures (Transact-SQL), Database Engine Stored Procedures (Transact-SQL), sp_help (Transact-SQL)"




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net