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 denormalization and why would someone consider doing so?

971

What is buffer manager?

931

How view is related to data independence?

990

How are exceptions handled in pl/sql? Give some of the internal exceptions name?

1030

What is system catalog or catalog relation?

1095

What are some disadvantages of a standard language such as sql?

902

Describe the difference between data and database administration.

1160

What is natural key?

1003

What is system r?

981

What is a distributed database?

1052

Name two utilities that oracle provides, which are use for backup and recovery.

908

Explain a join between tables?

1051

What is partial key?

1071

Can two oracle blocks have the same address?

1040

Explain the difference between two and three-tier architectures.

951

Un-Answered Questions { Databases }

What is data sparsity and how it effect on aggregation?

957

Explain degree of a relation?

921

Can we have multiple index on a table?

922

Where not exists in sql?

994

How to find the source of a table in sql server?

1013

What is longblob?

993

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3778

Do the mongodb databases have schema?

Explain about protocol layer present in SQL server?

1223

Write a syntax for update query in oracle?

1046

What is difference between rank () row_number () and dense_rank () in sql?

1120

How to resolve the ORA-39133 error in Oracle?

1135

how to do backup entire database? : Transact sql

1157

What is the cartesian product of table?

1025

What is the difference between inner join and equi join?

1011

For More Un-Answered { Databases } Questions Click Here