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


SQL Server Interview Questions
Questions Answers Views Company eMail

How can we remove orphan records from a table?

 529

What do you mean by recursive stored procedure?

 513

What structure can you implement for the database to speed up table reads?

 714

What are the acid properties?

 555

Explain different types of index?

 598

What are user-defined functions (udfs) in sql server?

 573

Explain how many normalization forms?

 581

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

 544

Explain boyce and codd normal form(bcnf)?

 539

How important do you consider cursors or while loops for a transactional database?

 539

In what version of sql server were synonyms released?

 506

What are the aggregate and scalar functions?

 527

What is the need for group functions in sql?

 569

What is the difference between varchar and varchar types?

 568

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

 572

Un-Answered Questions { SQL Server }

What is a trace frag?

648

Can the query output be sorted by multiple columns in ms sql server?

557

How do you set a trace flag in sql server?

559

Can you create a logon trigger in sql server 2005 express edition?

577

What is sql server transaction log file?

524




If no size is defined while creating the database, what size will the database have?

550

What are the components of dbms?

535

Can a table be moved to different filegroup?

574

What is isolation levels?

572

How to get a list of columns using the "sys.columns" view in ms sql server?

562

What is sql service broker?

592

Is sql server free?

528

What Is Rdbms?

676

What is an etl file?

530

How to count groups returned with the group by clause in ms sql server?

563

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