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 a query?

1 949

Name the buffer in which all the commands that are typed in are stored

1 882

What is BCNF (Boyce-Codd Normal Form)?

1 939

What is Multivalued dependency?

1 853

What is 4NF?

1 983

What is System R? What are its two major subsystems?

1 906

Which part of the RDBMS takes care of the data dictionary? How

1 1087

What is the Disadvantage in File Processing System?

1 911

What is Data Model?

1 1086

What is E-R model?

1 945

Brief theory of Network, Hierarchical schemas and their properties

1 932

What is 2NF?

1 913

What is a checkpoint and When does it occur?

1 846

How do you communicate with an RDBMS?

1 1034

What do you mean by flat file database?

1 992

Un-Answered Questions { Databases }

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2698

Is inner join faster than left join?

1273

How raid can influence database performance?

1108

Have you written applications to retrieve stored images in a table?

1083

Where can you add custom error messages to sql server?

1197

Can sql servers link to other servers like oracle?

910

Can we do dml on views?

1029

What is a concurrency problem in dbms?

1049

what is the age limit for groups1 examination

2335

How do I find query history in sql server?

1018

how many tables will create when we create table, what are they? : Sql dba

1139

Can delete statement be rollbacked?

1050

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

1108

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

1075

For More Un-Answered { Databases } Questions Click Here