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 35717

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

BeBo Technologies, Wipro,

7 73981

What are inner join and outer join?

3 25470

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

Amdocs, CSC, TCS,

29 97066

what are Triggers?

TCS,

7 28438

what are stored procedures?

TCS, Wells Fargo,

7 26877

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

Green Info Solutions, TCS,

7 31487

what are views?

TCS,

8 34975

what is web server?

Satyam,

3 25683

What are functions

3 22884

What are the different table present in MYsql?

3 25638

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 26363

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

i2, Oracle,

2 30970

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

CA,

1 17710

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

2 6735

Un-Answered Questions { Databases }

What is the usage of distinct keyword?

1067

How do you run a query?

989

List the various oracle database objects?

1057

In what script is snap$ created? In what script is the scott/tiger schema created?

2708

What is user-defined scalar function?

965

What are the functions of rdbms?

997

how to create “alternate row colour”?

146

Is ms sql traffic encrypted?

922

How to use "if" statements on multiple conditions?

1174

Explain the scenarios or situations under which progress database creates new index entry for a record?

1034

How many number of columns can a RECORD GROUP have ?

2027

How to get a list of columns in a view using the "sp_columns" stored procedure?

1041

Where are the settings stored for each instance in oracle?

1105

Which language rdl files made of?

130

Explain the difference between replace() and translate() functions in oracle?

1036

For More Un-Answered { Databases } Questions Click Here