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 proper subset of candidate key?

1051

What is the concept of optimization?

1116

What is the benefit of normalization?

1142

What is the full meaning of dml?

1006

What is optimization and its types?

1043

What is a ddl statement?

967

What is difference between equi join and inner join?

1046

What is the most common type of join?

1047

What is a periodical index?

985

What is abstracting periodical?

1000

What is mean by candidate key?

1069

What is purpose of normalization?

1005

What is the difference between composite index and covering index?

1015

What is difference between count (*) and count column?

955

What is the synonym of join?

1020

Un-Answered Questions { Databases }

What does it mean to normalize a database and why would you do it?

1032

difference between global n context sensitive segments?

2733

what is try_catch block in procedure

1821

What is table join?

1178

Explain the purpose of %type and %rowtype data types with the example?

1052

what is the syntax used for partition in tsql? : Transact sql

1064

What is an oracle stored procedure?

1117

How many text indexes can a mongodb collection have?

How do you create a database?

966

Explain what are the basic functions for master, msdb, model, tempdb databases?

1031

How will you identify oracle database software release?

1062

Define Wed Edition in SQL Azure?

102

Where sql server usernames and passwords are stored in a sql server?

1045

Calculate difference between 2 date / times in oracle sql?

1103

I am getting error "no communication channel" after changing the domain name? What is the solution?

654

For More Un-Answered { Databases } Questions Click Here