Interview FAQs

FAQs of level

Microsoft SQL Server 2000 is a full-featured relational database management system (RDBMS) that offers a variety of administrative tools to ease the burdens of database development, maintenance and administration. The more frequently used tools: Enterprise Manager, Query Analyzer, SQL Profiler, Service Manager, Data Transformation Services and Books Online. Lets take a brief look at each:

Enterprise Manager is the main administrative console for SQL Server installations. It provides you with a graphical "birds-eye" view of all of the SQL Server installations on your network. You can perform high-level administrative functions that affect one or more servers, schedule common maintenance tasks or create and modify the structure of individual databases.

Query Analyzer offers a quick and dirty method for performing queries against any of your SQL Server databases. It is a great way to quickly pull information out of a database in response to a user request, test queries before implementing them in other applications, create/modify stored procedures and execute administrative tasks.

SQL Profiler provides a window into the inner workings of your database. You can monitor many different event types and observe database performance in real time. SQL Profiler allows you to capture and replay system "traces" that log various activities. It is a great tool for optimizing databases with performance issues or troubleshooting particular problems.

Service Manager is used to control the MSSQLServer (the main SQL Server process), MSDTC (Microsoft Distributed Transaction Coordinator) and SQLServerAgent processes. An icon for this service normally resides in the system tray of machines running SQL Server. You can use Service Manager to start, stop or pause any one of these services.

Data Transformation Services (DTS) provide an extremely flexible method for importing and exporting data between a Microsoft SQL Server installation and a large variety of other formats. The most commonly used DTS application is the "Import and Export Data" wizard found in the SQL Server program group.

There are two wildcards are used for pattern matching:
1. _ for single character substitution and
2. % for multi-character substitution
Insert, update, delete, select, references, index, execute, alter, all.
1. TRUNCATE is a DDL command whereas DELETE is a DML command.
2. DELETE operation can be rolled back, but TRUNCATE operation cannot be rolled back.
3. WHERE clause can be used with DELETE and not with TRUNCATE.
TDS (Tabular Data Stream) Protocol is an application layer protocol, used to transfer data between a database server and a client.
Displaying 1 of 11Next
1 2 3 4 5 6 7 8 9 10 11
Need Help? Contact Us.

Log in


Forgot password?


New User