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 are sp_configure commands and set commands?

1034

What is the ‘fillfactor’?

980

What is read uncmmited?

1078

What is an sql server agent?

1080

What is the difference between for trigger and after trigger?

1123

What are the steps you can take to avoid “deadlocks”?

989

Explain user defined views?

982

What is catalog views?

1088

What is table-valued sub query?

981

What is the difference between a function and a stored procedure?

1085

What is the difference between update lock and exclusive lock?

988

Does the order of columns in update statements matter?

928

What is use of @@ spid in sql server?

1227

How to delete duplicate rows from table except one?

1003

Can we insert data if clustered index is disabled?

960

Un-Answered Questions { Databases }

How can you retrieve a portion of any column value by using a select query?

932

What stored by the master?

969

What does it mean to manipulate data?

1018

What are materialized views & where do we use them? What is a materialized view?

What is an oracle cursor variable?

1101

Does google use postgresql?

913

What is the primary use of normalization?

1028

What happens if you add a new index to large table?

953

Can another user execute your local temporary stored procedures?

1006

What is the most important ddl statements in sql are?

1013

Does mongodb support primary-key, foreign-key relationship?

How to verify a user name with sqlcmd tool?

1092

What is a trace file and how is it created in oracle?

1076

You need to multiply all values of a single column. How would you do that?

900

What do you understand by data model?

1114

For More Un-Answered { Databases } Questions Click Here