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

Define transaction and transaction isolation levels?

984

Explain the scenarios or situations under which progress database creates new index entry for a record?

1034

In which phase of mload can I use .filler?

925

How to activate all indexes in firebird?

1054

Explain environment of openedge?

945

How to repair a corrupt firebird database?

1067

Explain what are the types of transparencies?

938

Explain a checkpoint and when does it occur?

1010

Explain about the case statement present in stored procedure?

888

What versions of clipper does netlib support?

1003

Is it possible to declare or create a cursor for update of table? If no tell me why?

1051

How to recreate the index on a firebird table?

908

What are different types of transaction isolation levels?

1011

How to debug stored procedures?

972

What is openedge translation manager?

1077

Un-Answered Questions { Databases }

What is oracle log switch?

619

Is pdo more secure than mysqli?

882

What is it unwise to create wide clustered index keys?

1007

What are the types of table?

978

What is Transparent Data Encryption?

1001

What are the three pl sql block types?

1009

how many values can the set function of mysql take? : Sql dba

987

How large can a mysql table be?

958

What are triggers? Why do we use them? Diff types of triggers? What are magic tables?

949

What is meant by Active-Passive and Active-Active clustering setup?

1176

Is the primary key column of a table an index in ms sql server?

962

What is an oracle tablespace?

1044

Which date function is used to find the difference between two dates?

578

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1034

Tell me what are the essential components of sql server service broker?

941

For More Un-Answered { Databases } Questions Click Here