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 10557

Query to retrieve record for a many to many relationship ?

Keane India Ltd,

2540

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

CTS, Keane India Ltd, TCS, Wipro,

34 65721

Write a simple Store procedure and pass parameter to it ?

Keane India Ltd,

3 7803

How do you optimize SQL queries ?

CarrizalSoft Technologies, Infosys, Oracle,

6 35958

What are the types of triggers ?

Aspire, BirlaSoft, TCS,

26 61140

Types of locks in database ?

HCL, TCS, Tieto,

8 76925

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

TCS,

5 14753

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

TCS,

3 11781

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

TCS,

4 16814

Types of backups ?

TCS,

3 10526

What is INSTEAD OF trigger ?

Hexaware, TCS,

13 61479

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

Microsoft, TCS,

4 25468

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 119007

Types of joins ?

Polaris, TCS,

11 24109

Un-Answered Questions { Databases }

Explain meant by 3-tier architecture?

958

Explain clause in sql?

1038

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1077

What are three advantages to using sql?

1040

What is a nested table?

1078

What is psql command?

992

Mention the different types of cursor?

1010

How do I connect to postgresql server?

928

Which is faster subquery or join?

1240

what is a mixed extent? : Sql server administration

1126

Is mongodb a relational database?

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1950

What is MySQL?

1015

Write a query to remove duplicate rows from a table?

904

How much does mongodb cost?

For More Un-Answered { Databases } Questions Click Here