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

Can foreign key be deleted?

934

Can a table have 2 primary keys?

994

What are the components of dbms?

967

Can an entity have two primary keys?

992

How is foreign key related to primary key?

987

Can foreign key be duplicate?

1075

What are the five major components of a dbms?

947

Can two tables have the same primary key?

1228

What are the properties of primary key?

990

What do you mean by normalisation?

1060

What are the 3 types of schema?

1127

Can we join two tables without primary key?

1066

What are the types of normalization?

1041

What are the elements of dbms?

980

How many types of objects are there?

1028

Un-Answered Questions { Databases }

What is the data pump export utility?

1100

How to delete a database from mysql server.

1076

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1064

Can you have a composite foreign key?

819

What is the advantage of using preparedstatement?

965

How to create a stored program unit?

1244

Explain what is public role in sql server?

1147

How to resolve the ORA-39133 error in Oracle?

1134

Why are you getting errors when creating a new odbc dsn?

1236

What are records give examples?

1024

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1232

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1076

What happens if null values are involved in expressions?

1044

What is the purpose of the partition table?

1065

What does pragma mean?

1068

For More Un-Answered { Databases } Questions Click Here