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

in compatibility in report registration?

Convergys,

1 4179

what is integrity n how many integrity rules r there?

Convergys,

2 8215

Where do u define the select statement of the parameter? is it followed by the & variable ?

Zensar,

2 5575

What is user exit.?

IBM, Synergy, Zensar,

2 8554

How you define procure to pay?

PWC, Zensar,

1 9762

How do u give the list of values in bind parameter

Zensar,

1 5830

What are the types of trigger actions?

Zensar,

4 7896

Can you mention lexical parameter in select statement in the data model?

Zensar,

1 8546

What is 4-way match?

Zensar,

2 13471

What is responsibility and how u attach How to create user and how u attach with responsibility.

Zensar,

2098

In what situation u create the BPA.

Zensar,

2254

What is the difference between BPA AND Contract What are documents and test cases u followed

Zensar,

2439

Can We Restore a Table that accidantly dropped.

TCS,

8 15976

what command is used to create a table by copying the structure of another table including constraints ?

CMC, eicc,

6 16679

Find out the 3rd highest salary?

BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,

51 75492

Un-Answered Questions { Databases }

Differentiate between pre-select and pre-query?

1160

How to convert the oracle reports to excel sheet from oracle?

Explain the difference between a primary key and a unique key?

1029

Explain about Microsoft access?

903

How to generate create view script on an existing view?

1045

What is pivot query?

1124

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1132

does the query needs a hint to access a materialized view?

1910

How large can a mysql database become?

1059

Explain about Views?

1128

How to delete a login name in ms sql server?

1128

How to call postgresql function in asp net?

978

What is the maximum number of records in mysql table?

979

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1077

You see a wait on lms process in statspack, what does that mean?

617

For More Un-Answered { Databases } Questions Click Here