What are subqueries in sql server? Explain its properties.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is data compression? : sql server database administration

0 Answers  


What are the types of table?

0 Answers  


Explain the different index configurations a table can have?

0 Answers  


How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 Answers  


What is a group function explain with an example?

0 Answers  


How sql server executes a statement with nested subqueries?

0 Answers  


What is a hint?

0 Answers  


Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)

8 Answers  


1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

10 Answers   Perot Systems,


What is clustered vs nonclustered index?

0 Answers  


Difference between drill down and drill through report.

0 Answers  


Do you know what are the properties of the relational tables?

0 Answers  


Categories