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

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

Synergy,

1 6435

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 16570

what is DTS what are tasks available

Wipro,

1 3914

Normalization and denormalization

Wipro,

3 6973

Diffrent types of function

Wipro,

1 4531

diffrence between function and procedure

Wipro,

5 7622

diffrence between Cluster Index and non Cluster Index

Wipro,

3 6368

System variable and temporary variables

Wipro,

2305

optimization techinques

Wipro,

2735

user defined datatypes

Wipro,

1 4579

What is bulk collections?

2 7989

what is External tables? explain with examples

TCS,

2 13966

what is difference between decode and case function?

2 10285

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

Polaris,

2551

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

Value Labs,

3028

Un-Answered Questions { Databases }

What is a super key? How is it different from a candidate key?

871

What is the purpose of floor function?

1100

What is a DBMS, query, SQL?

1102

On startup, the transaction log of a database has filled and recovery has suspended, what can I do?

1046

How do I clear the screen in sql plus?

1091

Explain try...catch with sql server?

1074

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

643

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

2054

What is a concurrency problem in dbms?

1035

What are the column comparisons operators?

1313

How to store values to array from mysql database in php?

1004

What is blob database?

997

What do you understand by check constraint in sql server?

1028

What is importing utility?

1045

What are the basic features of ms access?

1099

For More Un-Answered { Databases } Questions Click Here