SQL Server Interview Questions
Questions Answers Views Company eMail

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

Polaris,

6 11579

explain different types of jions with examples briefly?

Zensar,

1 4377

explain different types of jions with examples briefly?

Accenture, Zensar, Excellence,

2 5597




explain different types of jions with examples briefly?

Zensar,

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

HP,

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

Infosys,

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?

833


1 01 101 01010

740


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

858


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

1332


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

1022






How to trouble shoot if unable to connect SQL Server

766


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

1151


optimization techinques

1330


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.

1263


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?

1236


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

150


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

392


tell me the disaster recovery plan

1285


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

2676


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

1647