Do we need to rebuild index after truncate?

1126

How do I start sql server 2017?

1006

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

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

what is collation? : Sql dba

1223

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2346

Is inner join faster than left join?

1272

How to remove duplicate rows from table except one?

1077

how to start mysql server? : Sql dba

1258

What are the different types of subquery?

1227

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

2207

What is a scheduled job or what is a scheduled task?

1029

When should you use an instead of trigger?

1042

define sql insert statement ? : Sql dba

1092

How do I remove duplicates in two columns?

1175