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 make the project as .exe file in oracle forms & reports(d2k)?

Were you involved in any data conversion, which one?

What is oracle d2k? Why we use it?

Why we use oracle d2k?

What are the new features in release 11i?

How to get / select the nth row from the table?

Do you know table based value sets?

What are materialized views & where do we use them? What is a materialized view?

What is a staging area? Do we need it?

When do you analyze the tables?

Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?

What are parameter files? Where do we use them?

What is the purpose of a staging area?

Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?

What are active transformation / passive transformations?

Un-Answered Questions { Databases }

What is nonclustered index with included columns ?

986

What is the sql case statement used for? Explain with an example?

1013

How to convert characters to numbers in oracle?

1084

What are the differences between lov and list item?

1090

What are the limitations of rdbms?

979

How do I view tables in mysql workbench?

938

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

2115

What are the data management skills?

565

How many postgresql users are there, worldwide?

1089

What port does sql server use?

1079

What is the point of foreign keys?

791

What do you mean by group by clause?

1058

Can cursors be part of a trigger body?

1655

What do you mean by collation recursive stored procedure?

1075

Is there any link between pr form(purchse requisition)and po form(purchase order)

2744

For More Un-Answered { Databases } Questions Click Here