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 are indexes? What are b-trees?

1012

What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?

942

What's the difference between clustered and non-clustered indexes?

988

What are different types of joins in sql?

1055

How do we select distinct values from a table?

937

Can you explain insert, update and delete query?

1072

Can you explain the select into statement?

1046

What are the two types of indexes and explain them in detail?

951

What is normalization? What are different type of normalization?

966

What are the two types of indexes and explain them in detail? Or what's the difference between clustered and non-clustered indexes?

880

What are dml and ddl statements?

1005

What is etl process in data warehousing? What are the different stages in 'data warehousing'?

867

How to select the first record in a given set of rows?

927

What is 'cross join'? Or what is cartesian product?

892

What is the default '-sort' order for a sql?

914

Un-Answered Questions { Databases }

What is forward declaration in pl sql?

1100

what is denormalization? : Sql server database administration

947

How much is a sql server license?

981

What are the two authentication modes in sql server?

1146

What is the difference between natural join and equi join?

953

How MySQL Optimizes DISTINCT?

1134

What are distributed partitioned views?

1098

What is postmaster pid file in postgres?

970

What is spool?

1067

How show all rows in sql?

1028

What is advantages of progress actional?

942

What is sql data?

1010

How many triggers you can have on a table?

1007

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?

1799

What is 2-tier architecture?

966

For More Un-Answered { Databases } Questions Click Here