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,

538

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

Hexaware,

568

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,

521

what is oracle data integrator (odi)?

Hexaware,

584

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

Seventhsense Technologies,

559

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

Seventhsense Technologies,

519

can we implement package in package?

Hexaware, Seventhsense Technologies,

546

does odi support web services?

Hexaware, Seventhsense Technologies,

537

how to handle exceptions?

Hexaware, Seventhsense Technologies,

578

how to implement data validations?

Hexaware, Seventhsense Technologies,

550

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

Hexaware, Seventhsense Technologies,

651

how to remove the duplicate in odi?

Hexaware, Seventhsense Technologies,

591

how to write the sub-queries in odi?

Hexaware, Seventhsense Technologies,

653

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

Hexaware, Seventhsense Technologies,

578

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

Hexaware, Seventhsense Technologies,

718

Un-Answered Questions { Databases }

How will you differentiate between varchar & varchar2?

1007

How many columns can a mysql table have?

865

What is rank function?

996

What is store procedure? When do you use?

890

Explain what is scheduled job and how to create it?

922

What is a system database and what is a user database? : sql server DBA

1141

How to create a simple user defined function in ms sql server?

986

How to save query output to a local file?

989

How can you validate emails using a single query?

849

What is the maximum database size for sql express?

984

What do you mean by collation recursive stored procedure?

1031

How to retrieve field values using mssql_result()?

1225

What is localdb mssqllocaldb?

1033

How many aggregate functions are available there in sql?

952

What is normalization? What are different type of normalization?

891

For More Un-Answered { Databases } Questions Click Here