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

Indexes in oracle ?

Keane India Ltd, L&T,

3 10695

Query to retrieve record for a many to many relationship ?

Keane India Ltd,

1 2598

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

CTS, Keane India Ltd, TCS, Wipro,

34 66945

Write a simple Store procedure and pass parameter to it ?

Keane India Ltd,

3 7922

How do you optimize SQL queries ?

CarrizalSoft Technologies, Infosys, Oracle,

6 36263

What are the types of triggers ?

Aspire, BirlaSoft, TCS,

26 61984

Types of locks in database ?

HCL, TCS, Tieto,

8 77206

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

TCS,

5 14970

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

TCS,

3 11931

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

TCS,

4 16963

Types of backups ?

TCS,

3 10677

What is INSTEAD OF trigger ?

Hexaware, TCS,

13 61987

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

Microsoft, TCS,

4 25664

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 121156

Types of joins ?

Polaris, TCS,

11 24632

Un-Answered Questions { Databases }

Have you created fact table and dimension tables?

703

What is sql or structured query language?

1220

Design database draw er diagram for a certain scenario ?

4645

If a cursor is open, how can we find in a pl/sql block?

1235

Where can you add custom error messages to sql server?

1198

What is subquery? Explain the properties of a subquery?

1056

What is in place upgrade in sql server?

1121

define sql insert statement ? : Sql dba

1094

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1602

How efficient you are in oracle and SQL server?

1251

What are the different SQL Server Versions you have worked on?

1076

what is collation? : Sql dba

1224

How to export data from database and import into another?

989

When should you use an instead of trigger?

1042

Do we need to rebuild index after truncate?

1128

For More Un-Answered { Databases } Questions Click Here