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

What is a transaction and why is it important?

1111

Explain a differential backup?

1037

between cast and convert which function would you prefer and why?

976

What are the advantages dts has over bcp?

1017

What does it mean if @@cursor_row returns a negative number?

1005

What are the different types of replication you can set up in sql server?

1062

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

926

What information is maintained within the msdb database?

993

Can a table be moved to different filegroup?

993

Which database stores information about replication?

1084

Can the “if update (colname)” statement be used in a delete trigger?

1007

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

897

What is the difference between dbcc indexdefrag and dbcc reindex?

1005

What is the maximum length of an extended property?

999

How can you fix a poorly performing query?

1205

Un-Answered Questions { Databases }

When we will denormalize data?

1037

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2119

How to start and stop sybase database in linux sap?

953

What is page-level compression?

977

How to connect to a local oracle 10g xe server?

1005

What is path setting for dll?

What is attribute? : sql server analysis services, ssas

1030

What is Redo Log Buffer in Oracle?

1227

When you use @@error and try-catch?

1065

What is mongoose used for?

you need to add parameters to a query in ms access database. How would you do that?

857

What is the recovery model? List the types of recovery model available in sql server?

915

How delete all records from table in sql?

988

What is difference between equi join and natural join?

1072

What are the differences between interval year to month and interval day to second?

1044

For More Un-Answered { Databases } Questions Click Here