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 service-specific middleware?

997

Explain dml (data manipulation language)?

914

What are the ways to tune reporting services?

1001

How do you call a stored procedure from jdbc?

942

Define data, entity, domain and referential integrity?

1101

Explain atomicity and aggregation?

991

Which two can be implemented as a centrally located logical architecture?

923

What is data sparsity and how it effect on aggregation?

932

How to lock records in a table?

1004

What is building blocks of client/server?

1108

Explain the hierarchical database?

997

Explain data independence?

1027

Explain dml compiler?

1052

How to prevent firebird.log file from filling up the disk partition?

928

How to unzip a file in ssis?

1065

Un-Answered Questions { Databases }

What trigger means?

977

Why do we need to use a database?

961

What is dirty read?

1080

What is the latest version of microsoft sql server?

1046

How to use subqueries with the exists operator in oracle?

1027

What is the difference between the LIKE and REGEXP operators?

1035

How do you create a simple database?

983

Do you know what is difference between index seek vs. Index scan?

954

What are the benefits of modeling?

1082

How to create table with timestamp in postgres?

813

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1054

Have you created fact table and dimension tables?

640

what is the difference between filters and conditions?

2421

what is the information that can be stored inside a bit column? : Sql server database administration

963

State the various uses of dbcc command?

1060

For More Un-Answered { Databases } Questions Click Here