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

Oracle (3259)
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 3560

Select the Nth lowest value from a table?

4 5363

What is difference between Rename and Alias?

1 4414

Difference between an implicit & an explicit cursor.?

2 7325

What is a OUTER JOIN?

1 2736

What is the purpose of a cluster?

1 3272

What is OCI. What are its uses?

1 3172

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

2 3689

Display Odd/ Even number of records?

3 6479

What are various constraints used in SQL?

Polaris,

1 3778

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

1 3814

Difference between NO DATA FOUND and %NOTFOUND?

1 4408

Can you use a commit statement within a database trigger?

4 5338

What WHERE CURRENT OF clause does in a cursor?

2 4127

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

2 3932

Un-Answered Questions { Databases }

How a database is related to tablespaces?

998

How to stop superserver service on linux using only firebird tools?

1045

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

978

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1173

How to convert numbers to characters in oracle?

988

What is an expression in ms sql server?

1030

Is microsoft access part of office?

815

How to display odd rows in student table in mysql?

947

Do you know what are pages and extents? : SQL Server Architecture

953

What is the difference between a form and a report in access?

843

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

938

Can we debug stored procedure?

976

What is the main difference between union and union all?

853

Can you remove an open file under unix?

653

How useful is microsoft access?

814

For More Un-Answered { Databases } Questions Click Here