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

How to create DSN..Explain?

Accenture, BeBo Technologies, Infosys,

2 35655

What is the difference between SQL, DDL, and DML?

BeBo Technologies, Wipro,

7 73861

What are inner join and outer join?

3 25408

What are joins..how many types of joins are there?

Amdocs, CSC, TCS,

29 96765

what are Triggers?

TCS,

7 28352

what are stored procedures?

TCS, Wells Fargo,

7 26779

what are indexes..how many types of index's are there and what are they?

Green Info Solutions, TCS,

7 31398

what are views?

TCS,

8 34892

what is web server?

Satyam,

3 25604

What are functions

3 22834

What are the different table present in MYsql?

3 25585

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 26276

what is the difference between oracle 81,91,11i

i2, Oracle,

2 30910

How client makes connection with server in client/server architecture?

CA,

1 17670

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 6706

Un-Answered Questions { Databases }

what is a trigger? : Sql dba

1009

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

885

Is stored procedure faster than query?

949

What does the on update no action do?

999

Can foreign key have duplicate values?

876

What language you can use with mongodb?

What is difference between global temporary tables and local temporary tables?

1208

What is data modelling explain?

845

List the advantages of using stored procedures?

1030

Which tcp/ip port does the sql server run on? How can it be changed?

1032

what is sub-query? : Transact sql

1081

Who uses access database?

807

Compare the terms mongodb and couchdb?

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

2128

How to define an anonymous block?

1127

For More Un-Answered { Databases } Questions Click Here