1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

What is the difference between TRUNCATE and DROP?

 633

What are the disadvantages of using querystrings to send data from one page to another?

 588

What is the difference between ddl,dml and dcl commands?

BirlaSoft, Verifone,

613

Explain DBCC?

QuestPond,

572

Explain what role entity and relationship play in an ER diagram.

 581

Explain about service Broker functions?

 617

Can you tell me about the concept of ER diagrams?

 600

What are different type of Collation Sensitivity?

 557

Which one is faster delete/truncate? Why?

Infosys,

1 996

Difference between DELETE and TRUNCATE?

TCS,

617

What is Cross Join and in which scenario do we use Cross Join?

QuestPond,

576

What is a View ? Can we insert, Update and delete a view?

Arigo Infotech,

632

What is Dependency Injection and provide example?

 620

Can two different columns be merged into single column? Show practically?

QuestPond,

613

What is the difference between DataRow.Delete() and DataRow.Remove()?

 742

Un-Answered Questions { SQL Server }

What is the significance of null value and why should we avoid permitting null values?

534

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

548

Do you know what are acid properties of transaction?

526

What is compression - row-level and page-level compression?

535

Tell me about joins in database system and explain each in detail.

601




What are the differences between having and where clause.

559

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

644

What is truncate table?

550

Define constraints and give an example of their use?

565

What is acid mean in sql server?

580

What are advantages of ssrs or why we should use ssrs?

104

What is partition in sql server?

537

What is collation?

715

what are the new features in SSRS?

104

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

551

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