Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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?

1031

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

1074

In which phase of mload can I use .filler?

970

How to activate all indexes in firebird?

1123

Explain environment of openedge?

987

How to repair a corrupt firebird database?

1126

Explain what are the types of transparencies?

980

Explain a checkpoint and when does it occur?

1080

Explain about the case statement present in stored procedure?

943

What versions of clipper does netlib support?

1058

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

1119

How to recreate the index on a firebird table?

959

What are different types of transaction isolation levels?

1065

How to debug stored procedures?

1025

What is openedge translation manager?

1121

Un-Answered Questions { Databases }

How many triggers are possible in mysql?

1010

Where is mysql data stored linux?

1063

Can group by and orderby be used together?

1069

Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)

824

What is the full meaning of mysql?

1013

What is oracle server autotrace in oracle?

1221

How to debug stored procedures?

1025

What is a stored procedure in sql with example?

1202

What are drilldown reports?

160

What do you mean by e-r model?

1056

What is mysqli_connect_error ()?

1080

What is the default server name for sql server?

1235

Explain the difference between mysql_fetch_array(), mysql_fetch_object()?

995

Does mysql use t sql?

1026

How many employees does mongodb have?

For More Un-Answered { Databases } Questions Click Here