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

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

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

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

Synergy,

1 5604

If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?

JPMorgan Chase,

9 13495

what is DTS what are tasks available

Wipro,

1 3041

Normalization and denormalization

Wipro,

3 5589

Diffrent types of function

Wipro,

1 3850

diffrence between function and procedure

Wipro,

5 5808

diffrence between Cluster Index and non Cluster Index

Wipro,

3 5100

System variable and temporary variables

Wipro,

1707

optimization techinques

Wipro,

2194

user defined datatypes

Wipro,

1 3896

What is bulk collections?

2 6402

what is External tables? explain with examples

TCS,

2 12537

what is difference between decode and case function?

2 8994

what is the link between suppliers and banks in ap module in oracle apps? And also query?

Polaris,

2013

In oracle 10g export, import if we declare rows=y/n what would be the output?

Value Labs,

2397

Un-Answered Questions { Databases }

How is image stored in database?

579

What do you mean by denormalization?

491

How can windows applications connect to sql servers via odbc?

582

What is pl sql and why it is used for?

570

What is inverted file ?

967

Can you create your own sps for system wise?

523

How to sort the query output in oracle?

608

What is a database call?

552

How to delete a trigger in mysql?

485

How do I find duplicates in sql?

503

Can group functions be mixed with non-group selection fields?

528

How is data stored in mongodb?

How to use group functions in the select clause using oracle?

591

What type of database is postgresql?

430

Can we write ddl in trigger?

494

For More Un-Answered { Databases } Questions Click Here