SQL SERVER Tips and Tricks

Bookmark
  • Home
  • Video Tutorial
  • Interview Questions
  • Performance Tuning
  • SQL EXAMPLES
Search: 
  Go

Categories

  • Examples (15)
  • INTRODUCTION (14)
  • Join in SQL Server (8)
  • Miscellaneous (5)
  • SQL SERVER COMMANDS (29)
  • SQL SERVER DDL COMMANDS (3)
  • SQL SERVER DML COMMANDS (8)
  • SQL SERVER Error Messages (4)
  • SQL SERVER FUNCTIONS (10)
  • SQL SERVER GENERAL QUESTIONS (28)
  • SQL SERVER GENERAL SCENARIOS (1)
  • SQL Server Installation (1)
  • SQL SERVER Interview Questions (8)
  • sql server performance tuning tips (3)
  • SQL SERVER Tutorial for the Beginners (1)
  • Stored Procedures (20)
  • Templates (6)
  • white papers (1)

Archives

  • ▼  2012 (144)
    • ►  January (9)
    • ►  March (2)
    • ▼  April (46)
      • Commands in SQL SERVER
      • TCL Command in SQL SERVER
      • DCL Commands in SQL SERVER
      • DDL Commands in SQL SERVER: CREATE
      • DDL Commands in SQL SERVER: ALTER
      • DDL Commands in SQL SERVER : DROP
      • DDL Commands in SQL SERVER: TRUNCATE
      • DML Commands in SQL SERVER : INSERT (Part 1)
      • DML Commands in SQL Server: INSERT (Part 2) -- Ins...
      • DML Commands in SQL Server: UPDATE
      • DML Commands in SQL Server: SELECT
      • DML Commands in SQL Server: DELETE
      • Whats Difference between DELETE and TRUNCATE Comma...
      • SQL Server Interview Questions: Part1
      • SQL Server Interview Questions: Part2
      • SQL Server Interview Questions: Part3
      • SQL Server Interview Questions: Part4
      • How to enable OPENROWSET in SQL SERVER?
      • General Error messages in SQL SERVER
      • SELECT in SQL SERVER
      • TOP in SQL Server
      • WHERE Clause in SQL Server
      • IN Clause in SQL Server
      • BETWEEN in SQL Server
      • DISTINCT in SQL Server
      • How to drop all the tables from database in SQL Se...
      • ORDER BY in SQL Server
      • GROUP BY in SQL Server
      • Group By Errors in SQL Server
      • HAVING Clause in SQL Server
      • Aggregate Functions in SQL Server
      • COUNT in SQL SERVER
      • SUM in SQL Server
      • MAX Function in SQL Server
      • MIN in SQL SERVER
      • AVG in SQL SERVER
      • What is the difference between HAVING and WHERE in...
      • SELECT ,DISTINCT, FROM, WHERE, GROUP BY,HAVING an...
      • Joins in SQL SERVER
      • INNER JOIN in SQL Server
      • LEFT OUTER JOIN in SQL Server
      • RIGHT OUTER JOIN in SQL SERVER
      • FULL OUTER JOIN in SQL SERVER
      • CROSS JOIN in SQL SERVER
      • SQL Server Interview Questions: Part5
      • SELF JOIN in SQL SERVER
    • ►  May (53)
    • ►  August (26)
    • ►  September (6)
    • ►  November (1)
    • ►  December (1)
  • ►  2013 (4)
    • ►  February (1)
    • ►  November (1)
    • ►  December (2)

SQL Server Interview Questions: Part1

Posted on Friday, 13 April 2012 by SQL Developer

  1. Name the system Databases in SQL Server ? (or) What are System Databases?
  2. How to find the size of a database?
  3. What is the purpose of sp_helpdb?
  4. What is the purpose of sp_database?
  5. What is use of sys.master_files table?
  6. which command will delete backup history from msdb?
  7. Can we create the objects in system databases?
  8. How to check whether Resource database exists in server or not?
  9. What is DBMS(Database Management System)?
  10. Difference between different versions of SQL Server?

Email ThisBlogThis!Share to XShare to Facebook
This entry was posted in SQL SERVER Interview Questions . Bookmark the permalink.
Newer Post »
«Older Post

Leave a reply

About

This blog is created to provide complete solutions for all possible problems in SQL SERVER. It contains SQL SERVER Performance techniques, SQL SERVER Interview questions and complete SQL Tips.

Followers

Copyright © 2012 SQL SERVER Tips and Tricks