SQL Server Interview Questions
Questions Answers Views Company eMail

Is Sql non procedural query language?

Verifone,

1 910

Write a SQL command to insert and update only a particular field?

ADITI,

625

How efficient you are in oracle and SQL server?

CGI,

639

What are the steps to follow to configure SQL*Net?

Tech Mahindra,

559

What do you understand by SQL*Net?

Tech Mahindra,

613

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

IBM,

600

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

IBM,

574

When to use Inner join & when to use subquery?

IBM,

579

how many type of indexing in database?

IBM,

577

Difference between rowid and rownum in SQL?

Virtusa,

1 1039

How can you swap values between two rows in a table using single- SQL statement?

Tavant Technologies, Virtusa,

1 1834

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

Amazon,

564

what is the difference between Delete and Truncate command in SQL

BirlaSoft,

626

What Is Rdbms?

Accenture,

673

How can you tell if a database object is invalid?

MCN Solutions,

613


Un-Answered Questions { SQL Server }

How to set the current database in ms sql server?

523


Do you know what is lock escalation?

580


What is BLOCK statements in SQL?

805


Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

627


how to trace the traffic hitting a sql server? : Sql server database administration

1127






Can I save my report as html, excel or word? : sql server management studio

546


How to connect ms access to sql servers through odbc?

548


How do use Having,Group by,Group function in SQL?

1352


What does asynchronous call backs means?

621


Explain the difference between cross join and full outer join?

497


How to convert character strings into numeric values?

573


Describe triggers features and limitations?

504


How to get the definition of a trigger back?

545


How can we improve performance by using SQL Server profiler?

576


How to install sql server 2005 express edition?

590