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

Oracle (3259)
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)

Databases Interview Questions

Questions Answers Views Company eMail

Explain datetimeoffset data type in sal server 2008?

908

What is buffer cash in sql server?

1152

Define master database?

1070

Explain transaction server auto commit?

1041

What are the essential components of sql server service broker?

1019

Why do we use non clustered index?

1083

How to use the inserted and deleted pseudo tables?

961

Define full outer join?

956

Explain concepts of analysis services?

963

Explain where clause?

986

What are the advantages of sql stored procedure?

1074

Explain syntax for disabling triggers?

1041

Define left outer join?

971

How dts is used to extract, transform and consolidate data?

1073

How to implement service broker?

1011

Un-Answered Questions { Databases }

What are number line correlation administrators will use while working with a subquery?

1177

What is amo? : sql server analysis services, ssas

1089

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

967

How to display the records between two range in Oracle SQL Plus?

1146

How do you restart mysql?

909

can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

2551

Explain hostprotectionattribute in sql server 2005?

1029

Which database does facebook use?

979

What are extended events in sql server?

955

When I delete any data from a table, does the sql server reduce the size of that table?

1018

What is implicit mode in sql server?

1105

What is recycle bin in Oracle?

1150

Is sql server free?

918

Can you upgrade sql express to full sql?

1068

what are the performance views in an oracle rac environment?

1055

For More Un-Answered { Databases } Questions Click Here