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

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

Indexes in oracle ?

Keane India Ltd, L&T,

3 8744

Query to retrieve record for a many to many relationship ?

Keane India Ltd,

2081

Query to get max and second max in oracle in one query ?

CTS, Keane India Ltd, TCS, Wipro,

34 57465

Write a simple Store procedure and pass parameter to it ?

Keane India Ltd,

3 6527

How do you optimize SQL queries ?

CarrizalSoft Technologies, Infosys, Oracle,

6 33310

What are the types of triggers ?

Aspire, BirlaSoft, TCS,

26 53930

Types of locks in database ?

HCL, TCS, Tieto,

8 74409

Types of indexes. What is the default key created when a primary key is created in a table ?

TCS,

5 12904

What is clustered, non-clustured and unique index. How many indexes can be created on a table ?

TCS,

3 10547

Can we create non-clustured index on a clustered index ?

TCS,

4 15412

Types of backups ?

TCS,

3 9281

What is INSTEAD OF trigger ?

Hexaware, TCS,

13 57763

What is difference between triggers and stored procedures. And advantages of SP over triggers ?

Microsoft, TCS,

4 23767

Write a query to get 2nd maximum salary in an employee table ?

Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,

69 102881

Types of joins ?

Polaris, TCS,

11 20275

Un-Answered Questions { Databases }

What is cursor in pl sql?

580

What is sybase used for?

477

How you can change the database name in SQL SERVER?

674

How we can create an index in mongodb?

Can you do multiple joins in sql?

550

what is the difference between union and union all? : Sql dba

548

What is the difference between a database and a spreadsheet?

475

Why use truncate instead of delete?

548

What is regex in mysql?

535

What is a select query statement in oracle?

545

Explain about network model?

591

How to create a new view in oracle?

622

How do I setup a local sql server database?

540

How do I find the sql server database version?

534

Is mysql free for commercial use?

476

For More Un-Answered { Databases } Questions Click Here