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 6218

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

2 15763

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

7 13289




Difference between Cluster and Non-cluster index?

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

32 123856

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

2 6944

Explain DBMS, RDBMS?

6 19488

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

TetraSoft, Wipro,

3 17750

Explain the basic concepts of SQL server architecture?

College School Exams Tests,

2 14058




Explain couple pf features of SQL server

2 4024

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

1740

Explain fundamentals of Data ware housing & OLAP?

2 5609

Explain the new features of SQL server 2000?

1 4556

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

937

Explain sp_configure commands, set commands?

3 9263

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

CSC,

2 13503


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

what are the Prerequisites for Replication?

8748


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1228


how to take backup bcp out for a column in table in sql server?

924


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1119


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

911






IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

728


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

748


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1182


what is checksum in sql server.........???

467


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2839


how can you attach more than 20 ldf files in sql server

899


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

963


Does any body please help me what question's have asked for SSRS in the interview?

978


If a stored procedure is taking a table data type, how it looks?

4791


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

690