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

Define ddl and dml.

1 1099

Define join and enlist its types.

1 1176

Enlist the various relationships of database.

1 1099

define aggregate functions.

1 993

Differentiate table scan from index scan.

1 1116

What do you mean by index hunting?

1 1205

Enlist ways to efficiently code transactions.

1 1188

Mention what are the benefits of pl/sql packages?

1 1198

What does plvtab enables you to do when you showthe contents of pl/sql tables?

1136

Mention what does the hierarchical profiler does?

1 1166

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1 1237

What plvcmt and plvrb does in pl/sql?

1 1378

Mention what pl/sql package consists of?

1 1056

Explain how exception handling is done in advance pl/sql?

1 1059

What does the hierarchical profiler does?

1 1158

Un-Answered Questions { Databases }

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2043

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

What is the current version of postgresql?

1152

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

1059

Is inner join faster than left join?

1271

How to rebuild the master database?

1154

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2174

What are the source of constraints?

1006

define sql insert statement ? : Sql dba

1092

Which statement is used in a select query for partial matching?

1237

What is in place upgrade in sql server?

1119

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?

1841

What is a coalesce function?

1275

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

1108

what is the command syntax for inserting a document?

For More Un-Answered { Databases } Questions Click Here