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?

1164

What are collection pools? What are the advantages?

948

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

1007

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

975

Explain what are super servers?

1201

What is environment of openedge?

975

Which two statements are true about a foreign key?

1033

How to reorder the table columns (fields)?

1159

Define truncate and delete commands?

1062

What are the restrictions applicable while creating views?

1000

Explain 2nf?

1009

How to do replication of firebird databases?

1004

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

1139

Explain what are triggers and rules?

968

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

1102

Un-Answered Questions { Databases }

Is mariadb better than mysql?

1104

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

1041

Is primary key clustered index?

996

Explain the structure of pl/sql in brief.

1142

How do I run a query in pl sql developer?

1053

What is the usage of the distinct keyword?

1277

What is the function of mysqldump?

1127

How do I change the datatype in postgresql?

1038

How long does it take to create an index on a large table?

798

how can you process messages in order asynchronously?

1037

what is a deadlock? : Sql server database administration

1150

Explain why variables called the most powerful component of ssis?

1178

Do you know what is lock escalation?

1058

What is a database in computer?

1015

How does mysql store data?

985

For More Un-Answered { Databases } Questions Click Here