How many concurrent programs you have customized, can you name some of them?

34

What is the current version of sql?

1091

Suppose database is running slow, what will you do?

2590

What is the difference between upgrade and migration in sql server?

1178

How can I check that whether automatic statistic update is enabled or not?

1108

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2209

What is subquery? Explain the properties of a subquery?

1056

Why and when do stored procedure recompile?

1052

What is normalization and what are the advantages of it?

1054

What kind of problems occurs if we do not implement proper locking strategy?

1493

What is a view in sql?

1035

How can you append an identity column to a temporary table?

1065

How do I find the sql server version?

1099

What are the steps in creating a database?

1004

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