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,

1117

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

HCL,

1006

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

Informatica,

1035

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

Informatica,

1025

Explain the use of Merge statement in oracle 11g

Infosys,

991

What are the tools for Oracle ?

Infosys,

1029

What is the difference between primary key and secondary key?

Axtria, ITC Indian Tobacco Company,

937

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

ITC Indian Tobacco Company,

950

What is a Federated Query ?

MCN Solutions,

971

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

Infosys,

978

What are the advantages of using Query Strings?

MCN Solutions,

1035

What do you mean by Correlated subquery in database?

B-Ways TecnoSoft,

958

How to know the Architecture of the Database

HCL,

1114

How we can connect the Webform pages with database?

HCL,

905

What is the difference between indexes,views,synonyms?

HCL,

1073

Un-Answered Questions { Databases }

What is the purpose of normalization in dbms?

1107

Why do we use functions?

871

What is the size limitation of an Access database?

824

What is cis and how can I use it?

1009

What is difference between statement and preparedstatement?

952

how can you communicate with operating system files from oracle?

1012

How many types of dba are there?

535

Is sql injection illegal?

982

When is the update_statistics command used?

1065

Which data loaded are in target db?

537

What are drillthrough reports?

149

How to upsert (update or insert into a table)?

973

Who are naive users?

965

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1721

What is bulk collect in oracle?

973

For More Un-Answered { Databases } Questions Click Here