SQL Server Interview Questions
Questions Answers Views Company eMail

what are the joins,primary key,foriegn key, candidate key, super key and expain them?


6 11579

explain different types of jions with examples briefly?


1 4377

explain different types of jions with examples briefly?

Accenture, Zensar, Excellence,

2 5597

explain different types of jions with examples briefly?


3 7332

can we call functions from stored procedure in SQL Server 2005 ? How?

3 9234

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table


17 32558

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 3075

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 3807

Difference between Triggers and Stored Procedure

Protech, HCL, Claimat, Silgate,

23 56572

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 3249

How to list all tables having unique constraints in any of the columns in a database.

1 2911

Advantages and Disadvantages of Cursor?

TCS, Zenith, Polytechnic,

15 81071

Write a query to delete duplicate records in SQL SERVER


36 55228

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

6 5716

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 3898

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

How do you Implement SSIS Packages in your Project?


1 01 101 01010


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?


1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do


Why do you want to join software field as you have done your BE in Electronics?


How to trouble shoot if unable to connect SQL Server


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


optimization techinques


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.


This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?


Call by value and call by reference in procedure and function, with NOCOPY.


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


tell me the disaster recovery plan


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


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