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

Display the records between two range?

2 3724

Select the Nth lowest value from a table?

4 5665

What is difference between Rename and Alias?

1 4578

Difference between an implicit & an explicit cursor.?

2 7539

What is a OUTER JOIN?

1 2878

What is the purpose of a cluster?

1 3434

What is OCI. What are its uses?

1 3303

How you open and close a cursor variable.Why it is required?

2 3873

Display Odd/ Even number of records?

3 6719

What are various constraints used in SQL?

Polaris,

1 3942

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

1 3990

Difference between NO DATA FOUND and %NOTFOUND?

1 4577

Can you use a commit statement within a database trigger?

4 5628

What WHERE CURRENT OF clause does in a cursor?

2 4366

Table A has 5 rows and table B has 0 rows Cartesian join on A,B will have----rows

2 4130

Un-Answered Questions { Databases }

Explain table and field in sql?

1122

How to round a numeric value to a specific precision?

1126

What are the types of join in sql?

1155

Define primary key?

1202

Is sql injection illegal?

1082

How do I find mysql version in mysql workbench?

999

What do you mean by dml compiler?

1123

how to handle exceptions?

657

Write a query to display current date and time?

977

Does oracle use sql?

993

What is morphia mongodb?

How do I show a collection in mongodb?

Explain different backup plans?

1007

What is table partitioning and why is it required?

What is sql server 2000 work load governor?

1162

For More Un-Answered { Databases } Questions Click Here