SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

Is Sql non procedural query language?

Verifone,

1 670

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

ADITI,

449

How efficient you are in oracle and SQL server?

CGI,

487

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

Tech Mahindra,

434

What do you understand by SQL*Net?

Tech Mahindra,

479

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

IBM,

459

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

IBM,

436

When to use Inner join & when to use subquery?

IBM,

436

how many type of indexing in database?

IBM,

452

Difference between rowid and rownum in SQL?

Virtusa,

1 604

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

Tavant Technologies, Virtusa,

1 1327

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

Amazon,

411

what is the difference between Delete and Truncate command in SQL

BirlaSoft,

478

What Is Rdbms?

Accenture,

523

How can you tell if a database object is invalid?

MCN Solutions,

474

Un-Answered Questions { SQL Server }

Can you always create a cache of a report?

What is table valued function and scalar valued functions?

357

Is foreign key unique?

435

Explain active/passive and active/active cluster configurations?

460

Can we call stored procedure in view in sql server?

350

How to install sql server 2005 express edition?

447

How do you clear a log file?

362

What is a full text index?

366

Is ssrs support other database except ms sql server?

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

472

Write a sql query to get zero records from a table having n number of records?

534

What is a coalesce function?

473

What is recompile sql server?

410

What is wrong with sql server client libarary dll, ntwdblib.dll?

394

What is command parameter in ssrs?

For More Un-Answered { SQL Server } Questions Click Here