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

Oracle (3253)
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?

1 1199

Explain a differential backup?

1 1085

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

1 1041

What are the advantages dts has over bcp?

1 1076

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

1 1070

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

1 1124

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

1 986

What information is maintained within the msdb database?

1 1038

Can a table be moved to different filegroup?

1 1051

Which database stores information about replication?

1 1153

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

1 1055

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

1 957

What is the difference between dbcc indexdefrag and dbcc reindex?

1 1059

What is the maximum length of an extended property?

1 1056

How can you fix a poorly performing query?

1 1289

Un-Answered Questions { Databases }

how many tables will create when we create table, what are they? : Sql dba

1140

Have you used lexical parameters in reports?

Is primary key clustered index?

1015

How did mongodb get its name?

Suppose database is running slow, what will you do?

2590

Does group by remove duplicates?

1112

What is the difference between upgrade and migration in sql server?

1178

How can you append an identity column to a temporary table?

1065

what is dbms? : Sql dba

1061

What are wait types?

1239

Disadvantages of the indexes?

1218

What is the difference between case version and decode version?

1103

What is the current version of postgresql?

1168

What is the best sql course?

1046

What are the properties of the transaction?

1069

For More Un-Answered { Databases } Questions Click Here