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

Why do we need to use a database?

1 1029

Why would someone use a database?

1 993

Can I create table without primary key?

1 1063

Can a composite key be null?

1 1058

Can a foreign key be a duplicate?

1 979

Can a foreign key have a different name?

1 1010

Can a key be both primary and foreign?

1 1061

Can a primary key be a foreign key?

1 1104

Can a table have no primary key?

1 1131

Can a varchar be a primary key?

1 1066

Can primary key be changed?

1 971

Can there be 2 primary keys in a table?

1 1064

Can we create foreign key without primary key?

1 1055

Can we enter data in a table in design view?

1 1026

Do foreign keys improve performance?

1 1076

Un-Answered Questions { Databases }

what is the command syntax for inserting a document?

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1207

Does group by remove duplicates?

1106

What is normalization and what are the advantages of it?

1050

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 all the common sql function? : Sql dba

1120

How to define array in mongoose schema?

How to connect php with different port numbers?

1170

How do I remove duplicates in two columns?

1172

What are the different subsets of sql?

1641

Explain “row_number()” in sql server with an example?

1066

What is the latest version of postgresql?

946

What are the two main functions of queries in databases?

1518

What is the primary use of the model database?

1144

What is oracle latest version?

1165

For More Un-Answered { Databases } Questions Click Here