What are the source of constraints?

1006

List out the different types of locks available in sql server?

1045

How to select all columns of all rows from a table in oracle?

1124

What are the different subsets of sql?

1648

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

1901

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1129

what is the command syntax for inserting a document?

53

what is sql server agent? : Sql dba

1179

what is spatial nonclustered index

1054

How do I create a trace in sql server?

1113

Which statement is used in a select query for partial matching?

1239

Why should you use or avoid select * statements?

1106

Can sql servers link to other servers like oracle?

913

Explain “row_number()” in sql server with an example?

1073

Why we use the openxml clause?

1072