Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



SQL Server Interview Questions
Questions Answers Views Company eMail

Which command executes the contents of a specified file?

ABC, InfoMedia,

2 5687

Which command displays the SQL command in the SQL buffer, and then executes it?

TCS,

3 10229

Which system tables contain information on privileges granted and privileges obtained

1 5815

Which system table contains information on constraints on all the tables created?

2 5642

what command is used to create a table by copying the structure of another table?

7 10702

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 7946

What is the use of CASCADE CONSTRAINTS?

3 8818

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

Crown Solutions,

1255

What are the type of Indexes? which one is best, why?

6 6483

How to work on DTS?what is the main requirement?

Getit, ivan,

1 3812

I have student marks in a student table. I need second highest mark .Then what will the query for this?

NetCore, Patni, SAP Labs, Temenos, Wipro,

34 46631

how to find nth highest salary

Cognizant, IBM, NexGen, Oracle,

103 140038

About types of indexes in SQL server ?

Cognizant,

2 5759

Difference between writing SQL query and stored procedure ?

Cognizant, Infosys, TCS, Veritas,

15 66917

About DTS usage ?

Cognizant, Wipro,

2 6022







Un-Answered Questions { SQL Server }

Explain the relational database management system (rdbms)?

183


List all types of constraints in sql server?

214


Write query to return all rows sql?

246


Can an entity have two primary keys?

181


Explain difference between cross join and full outer join?

218






What are the different SQL Server Versions you have worked on?

227


Do you know what are different types of replication in sql server?

198


how can u get last observation in an unknown dataset ?

1514


What are magic tables in sql server?

216


Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

288


What is create statement?

182


How do I run sql server 2014?

173


What are the different normalization forms?

212


Can I disable or restrict ssrs export formats (rendering formats)?

42


When should you use an instead of trigger?

218