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 does fill factor concept mean with respect to indexes?

978

Explain the term specialization.

916

What do you understand by correlated subqueries in dbms?

1027

Mention few case manipulation functions in sql

1049

what are the acid properties in dbms?

1081

What are the differences between hash join, merge join and nested loops?

1075

Explain the term generalization.

1059

What is concurrency control?

1120

What do you understand by sub-queries in sql?

997

What is a deadlock and mention how it can be resolved?

919

Write a query to remove duplicate rows from a table?

958

Write a query to create a duplicate table with and without data present?

918

Explain database partitioning and its importance.

1057

Mention the differences between the clustered and non-clustered index

969

write a query to retrieve the last day of next month in oracle.

995

Un-Answered Questions { Databases }

What are the steps to process a single select statement?

998

How do you analyze table partition using oracle provided package?

561

What do you know about mongodb?

What are scalar functions?

1063

Why do we use triggers?

1024

Which sql server table is used to hold the stored procedure script?

1012

What is the maximum rows in sql server table?

969

Explain what is a view?

1121

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1472

What are the different ways to optimize a sql query?

995

what is the diffrence between core dba and apps dba?

2628

How to rename an existing column with sql server management studio?

1061

How can set the multipal database ?

3016

How can I add Reporting Services reports to my application?

134

How to retrieve error messages using odbc_errormsg()?

1122

For More Un-Answered { Databases } Questions Click Here