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 5659

What is difference between Rename and Alias?

1 4575

Difference between an implicit & an explicit cursor.?

2 7539

What is a OUTER JOIN?

1 2878

What is the purpose of a cluster?

1 3429

What is OCI. What are its uses?

1 3299

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

2 3873

Display Odd/ Even number of records?

3 6715

What are various constraints used in SQL?

Polaris,

1 3941

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 4574

Can you use a commit statement within a database trigger?

4 5624

What WHERE CURRENT OF clause does in a cursor?

2 4365

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

2 4129

Un-Answered Questions { Databases }

how to join query for one source type is oracle another source type is sql server ?

2479

Why is %isopen always false for an implicit cursor?

1153

What is flexfileds and use of flexfileds in odi?

631

What is difference between getdate and sysdatetime in sql server 2008?

1099

What does edb stand for?

1075

How to assign a tablespace to a users in oracle?

1090

What is the difference between mysql_connect and mysqli_connect?

1022

What is 1nf 2nf 3nf?

1036

Is mysql a framework?

983

What is the difference between partition and index?

1062

What are the steps required to view your mysql database?

1143

How does index hunting help in improving query performance?

989

How we can get the current date in mysql?

1000

What are the tables in sql?

1152

What is the physical representation for a many-to-many relationship?

1138

For More Un-Answered { Databases } Questions Click Here