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

Does my odi infrastructure require an oracle database?

Hexaware,

608

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

Hexaware,

668

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,

587

what is oracle data integrator (odi)?

Hexaware,

673

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

Seventhsense Technologies,

672

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

Seventhsense Technologies,

586

can we implement package in package?

Hexaware, Seventhsense Technologies,

650

does odi support web services?

Hexaware, Seventhsense Technologies,

619

how to handle exceptions?

Hexaware, Seventhsense Technologies,

657

how to implement data validations?

Hexaware, Seventhsense Technologies,

643

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

Hexaware, Seventhsense Technologies,

741

how to remove the duplicate in odi?

Hexaware, Seventhsense Technologies,

668

how to write the sub-queries in odi?

Hexaware, Seventhsense Technologies,

750

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

Hexaware, Seventhsense Technologies,

642

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

Hexaware, Seventhsense Technologies,

794

Un-Answered Questions { Databases }

Can two tables have same primary key?

1027

What is pl sql block in dbms?

1057

What are the differences between a dbms and rdbms?

1068

What is the simplest tool to run commands on oracle servers?

1057

State a few properties of relational databases?

1184

How do I rename a mysql database?

1009

What is external database?

919

How do I limit the number of oracle database connections generated by weblogic server?

1124

What are commit and rollback in sql?

1170

What is a relation schema?

1078

What is sql key?

1047

What is cost in sql execution plan?

1048

Can you edit the .rdl code associated with a linked report?

168

What happens if a tablespace clause is left off of a primary key constraint clause?

623

What is row level locking in access?

938

For More Un-Answered { Databases } Questions Click Here