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 4875

in fun why return single value?

UST,

1 3348

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

Quest,

8 102979

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

1581

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 12271

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

1 4517

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

BoA,

1 3661

what is kernel?

Microsoft,

2 5709

what is shell?

Microsoft,

2 4979

what is the difference between dbms and rdbms?

Oracle,

3 6190

what is the difference between sql& oracle?

Oracle,

11 14359

Un-Answered Questions { Databases }

Explain foreign key in sql?

623

How do I check mysql version?

491

Explain acid?

613

What are the data types in postgresql?

434

What is the maximum line size that dbms_output can handle?

563

What does pl sql developer do?

511

Which certification is best for sql?

542

How to convert numeric values to integers in ms sql server?

534

What is update_statistics command?

576

Does asenumerable execute the query?

605

Where does mongodb store data linux?

Can we use jpa with mongodb?

What is the purpose of using a heap table?

534

What are referenced objects? Explain the importance of referencing.

What is the full form of dql?

516

For More Un-Answered { Databases } Questions Click Here