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 use of foreign key?

1 941

What is data modelling concepts?

1 987

Why is data modelling important?

1 924

What is the main purpose of normalization?

1 1112

How can we optimize stored procedure?

1 1029

What is 1nf 2nf 3nf?

1 1048

What command is used to delete the data from the table without deleting the table structure?

1 1073

What is the phantom problem?

1 1059

What does schema mean?

1 1049

What data type is money?

1 919

What does tinyint mean?

1 985

What does innodb stand for?

1 1044

Can varchar be primary key?

1 985

Can a table have multiple primary keys?

1 967

How do I insert multiple rows in a table?

1 964

Un-Answered Questions { Databases }

Design database draw er diagram for a certain scenario ?

4641

How to put more than 1000 values into an oracle in clause?

1102

Can we use distinct and group by together?

1129

Were you involved in any data conversion, which one?

How to start an oracle instance?

1092

What are wait types?

1230

How do I remove duplicates in two columns?

1174

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

1021

Does group by remove duplicates?

1106

what is the age limit for groups1 examination

2331

How to remove duplicate rows from table except one?

1077

How to connect php with different port numbers?

1171

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1597

Is it possible to have clustered index on separate drive from original table location?

1034

Why and when do stored procedure recompile?

1052

For More Un-Answered { Databases } Questions Click Here