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

Indexes in oracle ?

Keane India Ltd, L&T,

3 10523

Query to retrieve record for a many to many relationship ?

Keane India Ltd,

2521

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

CTS, Keane India Ltd, TCS, Wipro,

34 65489

Write a simple Store procedure and pass parameter to it ?

Keane India Ltd,

3 7769

How do you optimize SQL queries ?

CarrizalSoft Technologies, Infosys, Oracle,

6 35901

What are the types of triggers ?

Aspire, BirlaSoft, TCS,

26 60973

Types of locks in database ?

HCL, TCS, Tieto,

8 76864

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

TCS,

5 14710

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

TCS,

3 11765

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

TCS,

4 16789

Types of backups ?

TCS,

3 10502

What is INSTEAD OF trigger ?

Hexaware, TCS,

13 61363

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

Microsoft, TCS,

4 25430

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 118567

Types of joins ?

Polaris, TCS,

11 24037

Un-Answered Questions { Databases }

What purpose does the model database server? : sql server DBA

1196

What is a matrix report and how many minimum groups are required to prepare the same?

1147

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1024

Is it possible to declare or create a cursor for update of table? If yes tell me how?

869

Define mongodb?

Give some features of MongoDB.

How large can a postgresql database be?

837

What is sql in java?

1091

What is sql profiling in oracle?

1066

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

960

what are the 'mysql' command line arguments? : Sql dba

1144

What is primary key, unique key, and foreign key?

976

What is a proxy object?

1068

What is sql partition?

1112

When does a workload on SQL Azure get throttled?

131

For More Un-Answered { Databases } Questions Click Here