how to start mysql server? : Sql dba

1257

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

What is an indexed view?

1016

what is bcp? When does it used? : Sql dba

1051

What is temporary table in sql server? Why we use temp table?

1006

Explain system functions or built-in functions? What are different types of system functions?

1055

How to provide default values to function parameters?

1242

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

1142

How do I create a trace in sql server?

1109

When should you use an instead of trigger?

1041

Have you created fact table and dimension tables?

696

What is in place upgrade in sql server?

1118

How do I find query history in sql server?

1018

Equi join and non equi join is possible with sql server?

1117

How can we solve concurrency problems?

1115