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

How to Truncate Table in Oracle

HCL,

1154

What is the purpose of tables, private synonyms and public synonyms in Oracle?

HCL,

1045

Â How to use an oracle sequence generator in a mapping?

Informatica,

1074

Â What are the oracle DML commands possible through an update strategy?

Informatica,

1063

Explain the use of Merge statement in oracle 11g

Infosys,

1027

What are the tools for Oracle ?

Infosys,

1062

What is the difference between primary key and secondary key?

Axtria, ITC Indian Tobacco Company,

968

What do you know about Master Data & Transaction Info Package?

ITC Indian Tobacco Company,

995

What is a Federated Query ?

MCN Solutions,

1002

What is the Structural difference between bitmap and b-tree index ?

Infosys,

1026

What are the advantages of using Query Strings?

MCN Solutions,

1067

What do you mean by Correlated subquery in database?

B-Ways TecnoSoft,

998

How to know the Architecture of the Database

HCL,

1158

How we can connect the Webform pages with database?

HCL,

951

What is the difference between indexes,views,synonyms?

HCL,

1126

Un-Answered Questions { Databases }

How to create function without parameter in sql server?

1054

how would you convert a secondary server into a primary server ?

179

Is blocked because of many connection errors mysql?

844

Explain drop constraint oracle?

1067

How do I order by ascending in sql?

1020

What is query in ms access?

738

Is sqlite good enough for production?

992

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

948

what are the disadvantages of mysql? : Sql dba

1149

Explain few examples of RDBMS?

1039

Is sql sequential or random?

1031

Does user triggers have entry for trigger with compilation errors?

1034

List some mysql advantages and disadvantages?

966

What is memory table?

902

Explain the importance of partitioning.

985

For More Un-Answered { Databases } Questions Click Here