Friday, August 17, 2007

SQL Server Interview Questions

Database Concepts

What is database or database management systems (DBMS)?

What’s difference between DBMS and RDBMS ?

What are CODD rules?

Is access database a RDBMS?

What’s the main difference between ACCESS and SQL SERVER?

What’s the difference between MSDE and SQL SERVER 2000?

What is SQL SERVER Express 2005 Edition?

What is SQL Server 2000 Workload Governor?

What’s the difference between SQL SERVER 2000 and 2005?

What are E-R diagrams?

How many types of relationship exist in database designing?

What is normalization? What are different type of normalization?

What is denormalization ?

Can you explain Fourth Normal Form?

Can you explain Fifth Normal Form?

What’s the difference between Fourth and Fifth normal form?

Have you heard about sixth normal form?

What is Extent and Page?

What are the different sections in Page?

What are page splits?

In which files does actually SQL Server store data?

What is Collation in SQL Server?

Can we have a different collation for database and table?

SQL

Revisiting basic syntax of SQL?

What are “GRANT” and “REVOKE’ statements?

What is Cascade and Restrict in DROP table SQL?

How to import table using “INSERT” statement?

What is a DDL, DML and DCL concept in RDBMS world?

What are different types of joins in SQL?

What is “CROSS JOIN”?

You want to select the first record in a given set of rows?

How do you sort in SQL?

How do you select unique rows using SQL?

Can you name some aggregate function is SQL Server?

What is the default “SORT” order for a SQL?

What is a self-join?

What’s the difference between DELETE and TRUNCATE ?

Select addresses which are between ‘1/1/2004’ and ‘1/4/2004’?

What are Wildcard operators in SQL Server?

What’s the difference between “UNION” and “UNION ALL” ?

What are cursors and what are the situations you will use them?

What are the steps to create a cursor?

What are the different Cursor Types?

What are “Global” and “Local” cursors?

What is “Group by” clause?

What is ROLLUP?

What is CUBE?

What is the difference between “HAVING” and “WHERE” clause?

What is “COMPUTE” clause in SQL?

What is “WITH TIES” clause in SQL?

What does “SET ROWCOUNT” syntax achieves?

What is a Sub-Query?

What is “Correlated Subqueries”?

What is “ALL” and “ANY” operator?

What is a “CASE” statement in SQL?

What does COLLATE Keyword in SQL signify?

What is CTE (Common Table Expression)?

Why should you use CTE rather than simple views?

What is TRY/CATCH block in T-SQL?

What is PIVOT feature in SQL Server?

What is UNPIVOT?

What are RANKING functions?

What is ROW_NUMBER()?

What is RANK() ?

What is DENSE_RANK()?

What is NTILE()?

What is SQl injection ?

.NET Integration

What are steps to load a .NET code in SQL SERVER 2005?

How can we drop an assembly from SQL SERVER?

Are changes made to assembly updated automatically in database?

Why do we need to drop assembly for updating changes?

How to see assemblies loaded in SQL Server?

I want to see which files are linked with which assemblies?

Does .NET CLR and SQL SERVER run in different process?

Does .NET controls SQL SERVER or is it vice-versa?

Is SQLCLR configured by default?

How to configure CLR for SQL SERVER?

Is .NET feature loaded by default in SQL Server?

How does SQL Server control .NET run-time?

What’s a “SAND BOX” in SQL Server 2005?

What is an application domain?

How are .NET Appdomain allocated in SQL SERVER 2005?

What is Syntax for creating a new assembly in SQL Server 2005?

Do Assemblies loaded in database need actual .NET DLL?

You have a assembly which is dependent on other assemblies, will SQL Server load the

dependent assemblies?

Does SQL Server handle unmanaged resources?

What is Multi-tasking?

What is Multi-threading?

What is a Thread ?

Can we have multiple threads in one App domain?

What is Non-preemptive threading?

What is pre-emptive threading?

Can you explain threading model in SQL Server?

How does .NET and SQL Server thread work?

How is exception in SQLCLR code handled?

Are all .NET libraries allowed in SQL Server?

What is “Hostprotectionattribute” in SQL Server 2005?

How many types of permission level are there for an assembly?

In order that an assembly gets loaded in SQL Server what type of checks are done?

Can you name system tables for .NET assemblies?

Are two version of same assembly allowed in SQL Server?

How are changes made in assembly replicated?

Is it a good practice to drop a assembly for changes?

In one of the projects following steps where done, will it work?

What does Alter assembly with unchecked data signify?

How do I drop an assembly?

Can we create SQLCLR using .NET framework 1.0?

While creating .NET UDF what checks should be done?

How do you define a function from the .NET assembly?

Can you compare between T-SQL and SQLCLR?

With respect to .NET is SQL SERVER case sensitive?

Does case sensitive rule apply for VB.NET?

Can nested classes be accessed in T-SQL?

Can we have SQLCLR procedure input as array?

Can object datatype be used in SQLCLR?

How’s precision handled for decimal datatypes in .NET?

How do we define INPUT and OUTPUT parameters in SQLCLR?

Is it good to use .NET datatypes in SQLCLR?

How to move values from SQL to .NET datatypes?

What is System.Data.SqlServer?

What is SQLContext?

Can you explain essential steps to deploy SQLCLR?

How do create function in SQL Server using .NET?

How do we create trigger using .NET?

How to create User Define Functions using .NET?

How to create aggregates using .NET?

What is Asynchronous support in ADO.NET?

What is MARS support in ADO.NET?

What is SQLbulkcopy object in ADO.NET?

How to select range of rows using ADO.NET?

What are different types of triggers in SQl SERVER 2000 ?

If we have multiple AFTER Triggers on table how can we define the sequence of the

triggers ?

How can you raise custom errors from stored procedure ?

No comments: