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 3635

Select the Nth lowest value from a table?

4 5488

What is difference between Rename and Alias?

1 4482

Difference between an implicit & an explicit cursor.?

2 7426

What is a OUTER JOIN?

1 2805

What is the purpose of a cluster?

1 3355

What is OCI. What are its uses?

1 3227

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

2 3790

Display Odd/ Even number of records?

3 6579

What are various constraints used in SQL?

Polaris,

1 3851

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

1 3887

Difference between NO DATA FOUND and %NOTFOUND?

1 4482

Can you use a commit statement within a database trigger?

4 5465

What WHERE CURRENT OF clause does in a cursor?

2 4237

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

2 4030

Un-Answered Questions { Databases }

What is the architecture of ms sql reporting service?

985

Can we linked SharePoint to a SQL databasebe?

1103

What is the role of 8 analysers in mongodb?

What is the difference between an inner and outer join?

1012

How to connect ms access to sql servers through odbc?

1030

What is the port 5432?

821

What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

941

What is indexing in sql server with example?

1002

How do I start sql profiler?

993

Is mysql same as mariadb?

907

Does drop table remove indexes?

806

How many types of keys are there in sql?

1038

How do I edit a table in mysql workbench?

850

What is the stored procedure to view current lock and processes respectively?

882

What is identity?

1014

For More Un-Answered { Databases } Questions Click Here