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 point of foreign keys?

1 847

What is the difference between a primary key and a composite key?

1 858

What is foreign key in java?

1 916

How do I start pgadmin?

1 834

How do I add a foreign key in pgadmin?

1 1007

What is a foreign key constraint why are such constraints important?

1 872

Is foreign key required?

1 829

What is composite primary key?

1 934

What is pgadmin tool?

1 931

How do you enter data in pgadmin4?

1 927

Is foreign key should be unique?

1 841

What is lookup wizard access?

1 919

What are the advantages of microsoft access?

1 961

What are modules in ms access?

1 862

What is ms access table?

1 912

Un-Answered Questions { Databases }

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

1021

What are the different SQL Server Versions you have worked on?

1077

Suppose database is running slow, what will you do?

2590

How do I start sql server 2017?

1011

How to select all columns of all rows from a table in oracle?

1122

Why we use the openxml clause?

1072

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1064

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

1126

Can we do dml on views?

1032

How to provide default values to function parameters?

1247

What are the source of constraints?

1006

How to define array in mongoose schema?

How do I create a trace in sql server?

1112

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

1083

List out the different types of locks available in sql server?

1045

For More Un-Answered { Databases } Questions Click Here