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 is the diff bet plan,package,dbrm?

1105

What are collection pools? What are the advantages?

896

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

959

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

919

Explain what are super servers?

1121

What is environment of openedge?

922

Which two statements are true about a foreign key?

972

How to reorder the table columns (fields)?

1090

Define truncate and delete commands?

1012

What are the restrictions applicable while creating views?

949

Explain 2nf?

958

How to do replication of firebird databases?

950

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

1100

Explain what are triggers and rules?

911

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

1014

Un-Answered Questions { Databases }

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1021

Where is database used?

917

How to convert a date to char in oracle? Give one example.

1069

What is database architecture?

704

What does partition by mean in sql?

967

What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

944

What should be the fill factor for indexes created on tables? : sql server database administration

1141

What are the restrictions while creating batches in sql server?

1062

how to create a new table in mysql? : Sql dba

988

What is the difference between getdate and sysdatetime?

1013

How many types of indexes are there in sql?

985

tell us something about heap tables. : Sql dba

1101

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2316

Sql technical questions

1283

hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com

2385

For More Un-Answered { Databases } Questions Click Here