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

Does my odi infrastructure require an oracle database?

Hexaware,

557

explain what is odi?why is it different from the other etl tools.

Hexaware,

616

if the source have total 15 records with 2 records are updated and 3 records are newly inserted at the target side we have to load the newly changed and inserted records

Hexaware,

549

what is oracle data integrator (odi)?

Hexaware,

623

how to load the data with one flat file and one rdbms table using joins?

Seventhsense Technologies,

614

how to reverse engineer views(how to load the data from views)?

Seventhsense Technologies,

552

can we implement package in package?

Hexaware, Seventhsense Technologies,

582

does odi support web services?

Hexaware, Seventhsense Technologies,

560

how to handle exceptions?

Hexaware, Seventhsense Technologies,

603

how to implement data validations?

Hexaware, Seventhsense Technologies,

589

how to implement the logic in procedures if the source side data deleted that will reflect the target side table?

Hexaware, Seventhsense Technologies,

686

how to remove the duplicate in odi?

Hexaware, Seventhsense Technologies,

627

how to write the sub-queries in odi?

Hexaware, Seventhsense Technologies,

704

in the package one interface got failed how to know which interface got failed if we no access to operator?

Hexaware, Seventhsense Technologies,

608

suppose having unique and duplicate but I want to load unique record one table and duplicates one table?

Hexaware, Seventhsense Technologies,

748

Un-Answered Questions { Databases }

What do you mean by e-r model?

1000

Why we need to use secondry database file? though, we can do same work using primary database file also.

6885

Define entity.

940

When using replication, can some members use journaling and others not?

How do I connect to a database in mysql workbench?

1024

Explain about functional dependency and its relation with table design?

1008

What happens to a statement batch if there is a compilation error?

966

Explain system views?

1086

Where is mongodb stored?

Can access database be used online?

784

How do I insert multiple rows in a table?

895

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

904

Explain how many normalization forms?

1031

What is mvcc in postgresql?

832

What is varchar sql?

1138

For More Un-Answered { Databases } Questions Click Here