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 5741

in fun why return single value?

UST,

1 4224

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

Quest,

8 106800

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

2016

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 14488

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

1 5187

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

BoA,

1 4436

what is kernel?

Microsoft,

2 6825

what is shell?

Microsoft,

2 6009

what is the difference between dbms and rdbms?

Oracle,

3 7414

what is the difference between sql& oracle?

Oracle,

11 17973

Un-Answered Questions { Databases }

How does clustered and non clustered index work?

939

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

1131

What are the main features of ms access?

841

What are string functions in sql?

1264

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1149

What is nvarchar in sql?

934

Is microsoft access included in office 365?

835

Tell me about builtinadministrator?

1012

Which was the neo4j first version and when was it released?

How is a full-text index updated?

964

How to download oracle database 10g xe?

1029

What are the fixed server level roles? : sql server security

1149

What is the use of lockboxes? : oracle accounts receivable

1224

What is blind sql injection?

1092

What do we have to check in database testing?

1034

For More Un-Answered { Databases } Questions Click Here