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

What is 2nf in the dbms?

974

Explain the concept of acid properties in dbms?

1116

What is meant by a database?

1018

How is the pattern matching done in the sql?

1178

Why is the use of dbms recommended?

1264

Explain the concepts of a primary key and foreign key.

898

What are the different types of languages that are available in the dbms?

1044

What are the different levels of abstraction in the dbms?

910

Explain by listing some major advantages of dbms.

944

What is the main difference between union and union all?

901

What is the purpose of sql?

964

What is the concept of sub-query in terms of sql?

970

What are the main differences between primary key and unique key?

1003

What is a join in the sql?

1004

What is dbms used for?

1016

Un-Answered Questions { Databases }

Is pl sql still used?

987

Write a query to display current date and time?

932

Is nosql relational?

952

Do I need a report server to run reports in my application?

168

Can ddl statements be used in pl/sql?

1154

what is a constraint? : Sql dba

1187

Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.

1004

What is mrc and what is its use? : oracle accounts receivable

1235

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

957

What is data management process?

958

How to know, what indexes exist in a collection?

What is 1nf normalization form?

1049

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2363

1. What is PO rate variance gain and loss?

2933

Does the order of columns in update statements matter?

927

For More Un-Answered { Databases } Questions Click Here