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 5719

in fun why return single value?

UST,

1 4217

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

Quest,

8 106759

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

2010

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 14449

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

1 5168

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

BoA,

1 4419

what is kernel?

Microsoft,

2 6811

what is shell?

Microsoft,

2 5976

what is the difference between dbms and rdbms?

Oracle,

3 7394

what is the difference between sql& oracle?

Oracle,

11 17909

Un-Answered Questions { Databases }

How do indexes help, types?

968

How can I combine multiple rows into a comma-delimited list in oracle?

1062

Explain the difference between physical and logical data independence?

916

diff b/w inter process and in process

2095

How to drop an index?

962

What is the function of grid naming service used in oracle rac

What are the parts of a function?

943

Could you please let me know the interfaces in OM / FA??

2270

How do you size a resultset?

918

What is the difference between truncate and delete? Why is one faster?

648

How do I know if localdb is running?

956

Explain about the difficulties faced by the database developer in implementing pre compiled statements?

725

What is vector point function?

1055

What is the use of mysql_close()?

979

Is truncate autocommit in oracle?

1087

For More Un-Answered { Databases } Questions Click Here