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's the difference between file and database? Can files qualify as a database?

981

What's difference between dbms and rdbms ?

973

What is the sql 'in' clause?

970

I have a table which has lot of inserts, is it a good database design to create indexes on that table?

912

What is snow flake schema design in database? What's the difference between star and snow flake schema?

886

Can you explain the 'between' clause?

1142

What are the different stages in 'data warehousing'?

1013

What is order by clause?

939

Have you heard about sixth normal form?

1020

What are different type of normalization?

987

What's the difference between 'union' and 'union all' ?

1022

How many types of relationship exist in database designing?

908

Can you explain fourth normal form and fifth normal form ?

843

What is database or database management systems (dbms)?

975

What's the difference between delete and truncate ?

1072

Un-Answered Questions { Databases }

What is the difference between sharding and replication?

1075

What does truncate mean in sql?

1048

What are the advantages of manual database?

984

What are the parts of a sql statement?

1107

What is replication server? What is its role in sybase?

966

What are the difference between primary keys and foreign keys?

984

How do I install mysql on windows 10 64 bit?

933

What specific conditions database should meet, before you can bulk copy data into it using bcp?

1000

What are the various types of relationships in database? Define them.

907

mention different types of relationships in the dbms?

1043

Where is dbms used?

1099

What is 1 NF (Normal Form)?

867

How many categories of data types used by sql server?

1040

Write a sql select query that only returns each name only once from a table?

1035

How can we create the complete backup of data in the oracle.

2183

For More Un-Answered { Databases } Questions Click Here