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 do you mean by merge in oracle?

1006

Describe an oracle table?

1062

What are the differences between primary key and unique key?

1020

What is the difference between substr and instr?

1050

Describe varray?

1068

How can you merge two tables in oracle?

1014

How to store pictures on to the database?

991

Explain temporal data types in oracle

1101

List out the difference between commit, rollback, and savepoint?

1052

What is transaction server isolation?

1055

What is transaction server auto commit?

1076

What is transaction server explicit transaction?

1047

What is transaction server distributed transaction?

1072

What is transaction server consistency?

1062

Do you know nested transaction?

972

Un-Answered Questions { Databases }

What are the types of database recovery models?

1140

You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.

594

What does edb stand for?

1035

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2035

What is bulk compiling in pl/sql.?

1146

What are statistics?

1015

How to create a Master database in SQL server ?

1104

What are the operating modes in which database mirroring runs? : sql server DBA

1198

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

981

What is rdbms and its types?

882

what is a primary key? : Sql dba

1048

Can you sum a count in sql?

1029

Is sql similar to python?

990

What is self contained scalar sub query?

988

How would you improve throughput in sybase?

986

For More Un-Answered { Databases } Questions Click Here