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

What is the diff bet plan,package,dbrm?

1162

What are collection pools? What are the advantages?

945

Can you have more than one cursor open at any one time in a program ?

1005

What is openedge abl in terms of taking the perspective of the developer?

969

Explain what are super servers?

1200

What is environment of openedge?

975

Which two statements are true about a foreign key?

1027

How to reorder the table columns (fields)?

1159

Define truncate and delete commands?

1062

What are the restrictions applicable while creating views?

999

Explain 2nf?

1007

How to do replication of firebird databases?

1001

What is the difference between hashed file stage and sequential file stage in relates to datastage server?

1138

Explain what are triggers and rules?

968

Could you give me an example how, where I code checkpoint and restart. I need and example

1100

Un-Answered Questions { Databases }

What are the security related catalog views? : sql server security

992

What is a checkpoint in dbms?

1183

Determine when to use stored procedure to complete sql server tasks?

1114

What are the requirements to use odbc connections in php scripts?

1159

How you will Show unique records.

1071

How do I open the query tool in pgadmin?

860

What is the trigger in sql?

1004

Explain about the implementation of business logic in stored procedures?

781

What is the difference between Delete, Truncate and Drop in Oracle?

1185

in mongodb, What is crud?

Explain what are the two types of oltp?

1089

What is mysqlcommand?

1060

Define magic tables in sql server?

1122

How do I tune a mysql query?

946

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

1081

For More Un-Answered { Databases } Questions Click Here