Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3238)
SQL Server (4518)
MS Access (429)
MySQL (1401)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3302)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

How to create DSN..Explain?

Accenture, BeBo Technologies, Infosys,

2 19444

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

BeBo Technologies, Wipro,

7 66403

What are inner join and outer join?

3 10141

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

Amdocs, CSC, TCS,

29 69092

what are Triggers?

TCS,

7 11243

what are stored procedures?

TCS, Wells Fargo,

7 9634

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

Green Info Solutions, TCS,

7 14474

what are views?

TCS,

8 16359

what is web server?

Satyam,

3 10193

What are functions

3 7719

What are the different table present in MYsql?

3 10247

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 10489

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

i2, Oracle,

2 16319

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

CA,

1 3672

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

2 4270

Un-Answered Questions { Databases }

What is change tracking in sql server?

235

What is the difference between char and varchar?

253

How do you rename a table in mysql?

217

What is rowtype?

228

How to load data through external tables?

263

How to work with data objects interactively?

279

A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

110

Explain Capacity planning to create a database? and how to monitor it?

3355

What is offset and limit in sql?

257

Describe mysql transaction properties.

228

Explain the advantages of merge replication?

228

Can we store files in mysql?

213

How to create a simple user defined function in ms sql server?

245

What are the properties of the relational tables?

228

What is flag in sql?

225

For More Un-Answered { Databases } Questions Click Here