Answer Posted / asha
Null
| Is This Answer Correct ? | 8 Yes | 15 No |
Post New Answer View All Answers
What happens if date-only values are provided as date and time literals?
What is join query?
What stored by the model?
What are the types of lock supported by ?
How to apply filtering criteria at group level with the having clause in ms sql server?
What is etl - extraction, transformation, and loading?
How to Check if table exists in sql server?
What is function of ROLLUP ?
What is the difference between varchar and nvarchar datatypes?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What is the difference between indexing and hashing?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
How to delete duplicate rows from table except one?
What is a partition key?
Can group by and orderby be used together?