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 10658

Query to retrieve record for a many to many relationship ?

Keane India Ltd,

2577

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

CTS, Keane India Ltd, TCS, Wipro,

34 66535

Write a simple Store procedure and pass parameter to it ?

Keane India Ltd,

3 7871

How do you optimize SQL queries ?

CarrizalSoft Technologies, Infosys, Oracle,

6 36133

What are the types of triggers ?

Aspire, BirlaSoft, TCS,

26 61611

Types of locks in database ?

HCL, TCS, Tieto,

8 77107

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

TCS,

5 14881

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

TCS,

3 11877

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

TCS,

4 16913

Types of backups ?

TCS,

3 10625

What is INSTEAD OF trigger ?

Hexaware, TCS,

13 61833

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

Microsoft, TCS,

4 25603

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 120185

Types of joins ?

Polaris, TCS,

11 24419

Un-Answered Questions { Databases }

What is byte access?

994

What are magic tables in sql server?

1203

What is t-sql? : Transact sql

1041

How do you connect to a database?

1151

Which database is best for storing large data?

945

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1054

How to rename an index in oracle?

1172

What is a trigger? Why we need it?

1058

How data can be copied from one table to another table?

1004

How can windows applications connect to oracle servers?

1118

Explain logical operators in sql server?

1184

How to combine two function together?

2202

what are date and time data types in mysql? : Sql dba

1025

What happens when unicode strings concatenate with non-unicode strings?

1187

What is database development process?

939

For More Un-Answered { Databases } Questions Click Here