1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

 2 7417

Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

 2 17785

How do you find the number of rows in a table?

 7 16719

Difference between Cluster and Non-cluster index?

Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,

32 138231

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

 2 8460

Explain DBMS, RDBMS?

 6 22094

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

TetraSoft, Wipro,

3 20472

Explain the basic concepts of SQL server architecture?

College School Exams Tests,

2 15524

Explain couple pf features of SQL server

 2 5236

Scalability, Availability, Integration with internet, etc.)?

 2418

Explain fundamentals of Data ware housing & OLAP?

 2 7003

Explain the new features of SQL server 2000?

 1 5557

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

 1617

Explain sp_configure commands, set commands?

 3 11422

What is the basic functions for master, msdb, tempdb databases?

CSC,

2 15413

Un-Answered Questions { SQL Server }

Explain different types of collation sensitivity?

520

How can you control the amount of free space in your index pages?

596

What is spid in sql server profiler?

521

Which sql server table is used to hold the stored procedure scripts?

598

Is port 1433 secure?

526




what are cursors? : Sql server database administration

501

What are the underflow and overflow behaviors on float literals?

560

What is surrogate key? : sql server analysis services, ssas

681

Explain transaction server isolation?

530

What are the types of table?

535

Is the log file is a part of file group?

538

When multiple after triggers are attached to sql table, how to control the order of execution?

517

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

85

What is the difference between web edition and business edition?

87

What are sql server functions?

501

For More Un-Answered { SQL Server } Questions Click Here