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 compound key?

961

Describe why operational and informational systems are separate.

962

What are the steps to follow when preparing to create a table?

899

what are the advantages of using them.

1123

Describe the difference between embedded and dynamic sql.

1096

Briefly describe an outer join.

972

What are the disadvantage in file processing system?

991

Explain issues for database performance.

961

Describe the difference between homogeneous and heterogeneous distributed database.

1084

Describe the four types of indexes.

1116

Explain concurrency transparency.

1062

what are the different kinds of indexing?

1026

What is file manager?

923

does pl/sql support “overloading”? Explain

1001

what are database files, control files and log files. How many of these files should a database have at least? Why?

881

Un-Answered Questions { Databases }

What do you mean by etl?

What is materialized view in Oracle?

1083

Is natural join and equi join same?

988

How to turn off warning messages during php execution?

1063

What is Data Dictionary Cache in Oracle?

1179

Define select, insert, create, delete, update, drop keywords

1062

Why is nosql good?

1040

What skills do you need to be an administrator?

576

What is difference between index and primary key?

1108

what is denormalization and when would you go for it? : Sql server database administration

1218

What are the main phases of database development?

994

What is user defined functions?

993

In which format does an image save in SQL Server database ?

1014

What do you mean by database normalization and why is it important?

What are the subsets of sql?

1150

For More Un-Answered { Databases } Questions Click Here