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 foreign key example?

1 833

Is postgresql better than oracle?

1 895

Why foreign key constraint is important?

1 884

What is the difference between oracle and postgresql?

1 1042

What is the purpose of foreign key constraints?

1 971

How do you delete a row in pgadmin 4?

1 894

How do you create a foreign key in pgadmin 4?

1 875

Is postgresql like oracle?

1 924

Is pgadmin free?

1 860

Can you have a composite foreign key?

1 883

Is index automatically created on primary key?

1 907

Can a unique key be a foreign key?

1 910

What are the rules of setting a primary key?

1 891

How do you edit data in pgadmin?

1 929

How is postgresql different from oracle?

1 835

Un-Answered Questions { Databases }

Disadvantages of the indexes?

1218

How efficient you are in oracle and SQL server?

1251

What is oracle latest version?

1170

what is schema? : Sql dba

1137

What are wait types?

1239

Do we need to rebuild index after truncate?

1128

What is normalization and what are the advantages of it?

1054

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1844

Have you created fact table and dimension tables?

705

Who proposed the relational model?

1027

What are the properties of the transaction?

1069

Can we do dml on views?

1032

What are different types of constraints?

995

Is there some bulk load or other way to import a lot of data fast?

931

do you know how to configure db2 side of the application? : Sql server database administration

1117

For More Un-Answered { Databases } Questions Click Here