Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3258)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3328)
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

For web applications from which version of Oracle is suitable?

1 5236

What are the main diff. between oracle 7.3 and oracle 8i?

1 4883

What is mutating table?

Saama Tech,

11 64150

How to call DDL statements from pl/sql?

5 32177

How to perform a loop through all tables in pl/sql?

Evosys, MBT,

4 15660

How to maintain the history of code changes of pl/sql?

3 14056

what are Dynamic SQL statements?

9 24483

Does it possible to pass object (or) table as an argument to a remote procedure?

TCS,

1 14642

What is pl/sql and what is it used for?

4 14333

what is constraining table?

2 13345

How pl/sql source code can be protected?

3 10465

What is the result, when NULL is compared with NULL?

TCS,

22 47989

What can be a size of a pl/sql block? Is there any limit?

2 12250

what are %TYPE and %ROWTYPE? what is the difference?

ICICI, Saama Tech, Sail,

7 47134

How to set the time zone for MySQL to particular country time?

2917

Un-Answered Questions { Databases }

Explain trigger and its types?

805

How to turn off warning messages during php execution?

735

What is the usage of regular expressions in mysql?

658

Explain the term entity set in dbms?

827

What is transaction server isolation?

756

What are trace flags and mention a few common trace flags used with sql server?

757

Why is nosql good?

784

What is the difference between view and materialized view in Oracle?

836

how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)

1798

What are the limitations of check constraint?

760

Can we modify approve purchase order?if yes what is navigation?

1725

List the different types of joins?

755

Write a query to display even rows in student table using mysql?

656

Explain types of indexing in dbms?

698

Differentiate table scan from index scan.

672

For More Un-Answered { Databases } Questions Click Here