SQL Server Interview Question and Answers

41. What is the difference between system objects and user objects?
  • SQL Server creates system objects during the installation process.
  • They are part of the system, and most of them are necessary for SQL Server to function properly.
  • Whereas system objects are part of the SQL Server system, you create user objects.
  • User objects include the databases, stored procedures, functions, and other system objects that you build.
42. Who is responsible for backing up SQL Server databases?
  SQL Server administrator.
43. What is a Server Role?
  A server role is pre-defined by SQL Server. It possesses a pre-defined set of rights.
44. What is the name of the system variable that returns the number of rows affected by a SQL statement?
45. What keyword do you use to return a value from a stored procedure?
  The OUTPUT keyword.

Page 9 of 15