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 are bind variables?

1 1168

what is the sequence of firing triggers in forms?

1 1713

What is a relationship and what are they?

1 1264

What is the difference between having clause and where clause?

1 1137

What are the types of join and explain each?

1 1136

What is the difference between local and global temporary table?

1 1109

When are we going to use truncate and delete?

1 1048

what is bcp? When is it used?

1 1205

Compare sql & pl/sql

1 1246

When is the update_statistics command used?

1 1213

What is cte?

1 1043

What are all the different types of indexes?

1 1216

What is the syntax and use of the coalesce function?

1 1247

Explain correlated query work?

1 1131

Explain the steps needed to create the scheduled job?

1 1120

Un-Answered Questions { Databases }

Why and when do stored procedure recompile?

1054

What are the different subsets of sql?

1648

Can delete statement be rollbacked?

1050

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1844

What is the difference between for xml raw and for xml auto?

1112

What are the advantages of database?

1009

What is sql server query analyzer?

1123

What is in place upgrade in sql server?

1123

Were you involved in any data conversion, which one?

What versions of clipper does netlib support?

1088

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1128

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1064

what is the age limit for groups1 examination

2337

What is a coalesce function?

1275

How do I remove duplicates in two columns?

1179

For More Un-Answered { Databases } Questions Click Here