Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 5848

in fun why return single value?

UST,

1 4316

what is different between inline query,subquery& corelated query?

Quest,

8 107165

where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it

1 2071

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??

8 14938

can anyone please tell what are the roles and responsibilities of a teradata developer in detail???

1 5267

how can we use a composite key for two tables and how can we represent it

BoA,

1 4517

what is kernel?

Microsoft,

2 6943

what is shell?

Microsoft,

2 6145

what is the difference between dbms and rdbms?

Oracle,

3 7559

what is the difference between sql& oracle?

Oracle,

11 18437

Un-Answered Questions { Databases }

Can we rollback truncate?

1072

what is the command syntax for inserting a document?

what is the difference between openrowset and openquery?

1186

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

2046

What are the different SQL Server Versions you have worked on?

1077

how many tables will create when we create table, what are they? : Sql dba

1140

Can we do dml on views?

1032

Can sql servers link to other servers like oracle?

910

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

1108

how to start mysql server? : Sql dba

1260

1. Tell me about your self? 2. Latest Project Introduction? 3. Difference between server jobs and parallel jobs? 4. Seq-Seq Explain its behavior and execution mode and which parallelism technique is used? 5. What is padding characters? 6. Seq-Seq, Seq-Copy-Seq which one is the best and efficient? 7. How many reject links do we have to a transformer? 8. How many reject links to join stage? 9. Difference between join and lookup? 10. How to design PX routine? 11. How can we call job in another job? 12. Difference between batch and sequencer? 13. Which Database is used? 14. What is change capture? Give briefing of that? 15. What is change Code? Explain? 16. How you call UNIX in Ds? 17. How do you call JCL in UNIX? 18. How do you pass the job status of one job to another job? Have designed any job sequencer? 19. How do you find a file in existed directory? 20. How can you call parallel jobs in transformer? 21. Execution of jobs in command line? 22. Tuning of sql queries? 23. What is orchestrating metadata? 24. What are junk dimension? 25. What are the third party tools you are used? 26. What are the system variables you have used?

1907

Any work done in oracle workflow builder. Did you customize or build a new workflow?

What are the kinds of subquery?

1101

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1605

Is primary key clustered index?

1015

For More Un-Answered { Databases } Questions Click Here