what are aggregate and scalar functions? : Sql dba

1116

Does group by remove duplicates?

1099

What is the current version of postgresql?

1144

what is collation? : Sql dba

1211

Were you involved in any data conversion, which one?

8

What is the latest version of postgresql?

941

How to export data from database and import into another?

978

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

2201

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?

1899

Can delete statement be rollbacked?

1038

Why and when do stored procedure recompile?

1042

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1277

Why we use the openxml clause?

1059

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1177

Are you familiar with user exits in reports?

6