Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288) there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?
12 20534While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?
8 17471
Which statement is used in a select query for partial matching?
What is oracle latest version?
How to provide default values to function parameters?
What is self contained sub query?
How can you append an identity column to a temporary table?
do you know how to configure db2 side of the application? : Sql server database administration
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?
How to convert character strings into numeric values?
define sql insert statement ? : Sql dba
What is an indexed view?
How to Change a users password from unix shell.
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What are the properties of the transaction?
What is subquery? Explain the properties of a subquery?
Who proposed the relational model?