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 purpose of primary key?

1 1094

What is the purpose of the primary key?

1 1134

What is the use of primary key?

1 1069

What is update query?

1 1050

What makes a good primary key?

1 1109

What program will open a mdb file?

1 1035

Why do we need a foreign key?

1 1186

Why primary key is required?

1 1071

What is the difference between integer and long integer in access?

1 986

What is the latest version of microsoft access?

1 986

What is the maximum number of rows in access 2010?

1 985

What is the difference between form and report in ms access?

1 996

What is the maximum length a text field can be in access?

1 825

What is the use of ms access 2007?

1 871

What is the main component of ms access database?

1 851

Un-Answered Questions { Databases }

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

Suppose database is running slow, what will you do?

2586

How to provide default values to function parameters?

1242

How many concurrent programs you have customized, can you name some of them?

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1850

Why use identity in sql server?

1189

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

1121

When should you use an instead of trigger?

1042

What is your daily office routine?

2333

How raid can influence database performance?

1104

Does view occupy space?

1005

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1021

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 different SQL Server Versions you have worked on?

1075

What is sql or structured query language?

1212

For More Un-Answered { Databases } Questions Click Here