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 35723

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

BeBo Technologies, Wipro,

7 73988

What are inner join and outer join?

3 25479

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

Amdocs, CSC, TCS,

29 97083

what are Triggers?

TCS,

7 28447

what are stored procedures?

TCS, Wells Fargo,

7 26880

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

Green Info Solutions, TCS,

7 31498

what are views?

TCS,

8 34981

what is web server?

Satyam,

3 25687

What are functions

3 22889

What are the different table present in MYsql?

3 25642

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 26370

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

i2, Oracle,

2 30975

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

CA,

1 17712

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

2 6738

Un-Answered Questions { Databases }

How to name query output columns in ms sql server?

968

What is the difference between flex mode and confined mode?

1052

How do you view log files in sybase?

940

How much does mongodb cost?

How can you see all indexes defined for a table?

1121

What is sql server query analyzer?

1033

What happens if you use a wrong connect identifier?

1066

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2168

Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba

1028

What happen when we delete the table using trigger?

902

When to use Inner join & when to use subquery?

1164

How do you bind variables in pl sql?

1097

What are temporal data types in oracle?

1124

What mean sql?

1014

What is Object Oriented model?

1037

For More Un-Answered { Databases } Questions Click Here