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 3128

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

 6 5806

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

 2 9626

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 3873

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

Teledata,

6 7753

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 22284

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 7722

What value could be assigned to Varchar Type?

 3 4663

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

 3 4429

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

 1 3580

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

1 4131

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

 3 7242

What does the INSTEAD OF trigger do?

 3 6384

What are explicit and implicit transactions?

BirlaSoft,

4 20430

What are the two types of concurrency?

 4 6560

Un-Answered Questions { SQL Server }

Can binary strings be used in arithmetical operations?

517

What is openrowset sql server?

511

What is data modification?

503

How many types of keys are there?

522

Do you know what is similarity and difference between truncate and delete in sql?

568




How to convert numeric expression data types using the cast() function?

540

What are translations and its use? : sql server analysis services, ssas

595

How to enforce security in sql server? : sql server security

614

Can you explain various data region available in ssrs with their use?

539

Explain different types of locks in sql server.

588

Tell me in brief how sql server enhances scalability of the database system?

513

Tell me the difference between clustered and non-clustered index?

503

What is right outer join in sql server joins?

677

Find first and last day of current month in sql server

591

Explain an automatic checkpoint

555

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