what is schema? : Sql dba

1133

What are the advantages of database?

1009

what is dbms? : Sql dba

1058

List the ways in which dynamic sql can be executed?

1079

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

1239

What is sql or structured query language?

1218

What are different types of constraints?

995

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

Why use identity in sql server?

1189

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2097

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

27

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2044

Why and when do stored procedure recompile?

1052

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1841

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

1052