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,

619

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,

550

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,

616

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,

590

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

Hexaware, Seventhsense Technologies,

687

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 is a crosstab query?

960

Is there any restriction on the use of union in embedded sql?

1157

What are different types of views?

948

What are distributed partitioned views?

1076

Is sql a postgresql?

941

Why are forms important in databases?

900

Difference between 2NF &3NF ?

1084

How do I edit a database in mysql workbench?

915

query optmization techniques and quwry analyser+projects+ppts

2421

Can we use max in where clause?

925

How to write pl sql program in mysql command prompt?

1096

How to integrate the ssrs reports in application?

985

What versions of clipper does netlib support?

1003

I have a task regarding access database. I and my organization is using access database to maintain my access files in well mannered way. But due to varied reasons access file showing error message Error 3112: Your access database got corrupted will not be able to show the database. Due to this error message I will not be able to access my access database. I don't have any idea how to recover access database or how to fix access database errors without affecting my original database????? Is there any relevant solution to repair access database?????

1890

What is match command?

For More Un-Answered { Databases } Questions Click Here