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

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


SQL Server Interview Questions
Questions Answers Views Company eMail

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

 1 2821

one table has four field id,name,design,salary. i have to find maximum salary .

 6 5165

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

 2 9307

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

 3 3558

How to find the date and time of last updated table?

Teledata,

6 7139

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 21560

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

 3 7289

What value could be assigned to Varchar Type?

 3 4283

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

 3 3994

What types of integrity are enforced by a foreign-key constraint

 1 3326

What are the main control-of-flow T-SQL constructs?

1 3927

What are the two virtual tables SQL Server maintains for triggers?

 3 6870

What does the INSTEAD OF trigger do?

 3 5975

What are explicit and implicit transactions?

BirlaSoft,

4 19745

What are the two types of concurrency?

 4 6060

Un-Answered Questions { SQL Server }

What is merge?

416

Explain foreign key in sql server?

427

What are the different types of locks in the database?

341

What are the restrictions while creating batches in sql server?

428

how can you check the level of fragmentation on a table? : Sql server administration

391




which backup strategy you are following at ur company

1587

Can truncate be rolled back?

379

Explain the properties of the relational tables?

409

What is subquery explain with example?

364

What do you understand by user-defined function in the sql server?

354

What is the difference between dropping a database and taking a database offline?

448

What happens to a statement batch if there is a compilation error?

367

What are page splits?

415

What is indexing in sql server with example?

361

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

451

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