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

How to Truncate Table in Oracle

HCL,

1219

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

HCL,

1096

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

Informatica,

1137

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

Informatica,

1114

Explain the use of Merge statement in oracle 11g

Infosys,

1088

What are the tools for Oracle ?

Infosys,

1117

What is the difference between primary key and secondary key?

Axtria, ITC Indian Tobacco Company,

1024

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

ITC Indian Tobacco Company,

1060

What is a Federated Query ?

MCN Solutions,

1068

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

Infosys,

1094

What are the advantages of using Query Strings?

MCN Solutions,

1114

What do you mean by Correlated subquery in database?

B-Ways TecnoSoft,

1059

How to know the Architecture of the Database

HCL,

1211

How we can connect the Webform pages with database?

HCL,

1018

What is the difference between indexes,views,synonyms?

HCL,

1197

Un-Answered Questions { Databases }

Explain about the architecture of MYSQL?

1027

Explain the use of control file?

1182

Explain joins in oracle?

1095

Differences between clustered and non-clustered in sybase?

960

What is sql server replication? : sql server replication

1050

There is no space in file system and you need to take a back up. What will you do?

910

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1066

How to run queries on external tables?

1099

How do you delete data from a table?

1110

How to select an oracle system id (sid)?

1126

11. Display the client number and name and the client number and name of the person who referred that client.

2398

how to do partition in sqlserver

2547

Is pl sql a scripting language?

1084

Which dbms is best?

971

What is foreign key in access?

919

For More Un-Answered { Databases } Questions Click Here