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?

894

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?

1119

What is environment of openedge?

920

Which two statements are true about a foreign key?

972

How to reorder the table columns (fields)?

1089

Define truncate and delete commands?

1009

What are the restrictions applicable while creating views?

949

Explain 2nf?

957

How to do replication of firebird databases?

948

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

1096

Explain what are triggers and rules?

909

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

1012

Un-Answered Questions { Databases }

How to see the event list of an existing trigger using sys.trigger_events?

1075

What is partial key?

1058

Explain phantom deadlock?

1238

Explain go command in sql server?

1040

How to rename an existing column with sql server management studio?

999

how to start mysql server? : Sql dba

1200

Define Wed Edition in SQL Azure?

100

What is a recursive stored procedure?

1185

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

1594

What are the export options of ssrs?

173

How to download oracle sql developer?

1110

how to get @@error and @@rowcount at the same time? : Sql dba

1028

What is the function of mysqldump?

1074

Design database draw er diagram for a certain scenario ?

4579

What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?

668

For More Un-Answered { Databases } Questions Click Here