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 35709

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

BeBo Technologies, Wipro,

7 73971

What are inner join and outer join?

3 25465

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

Amdocs, CSC, TCS,

29 97055

what are Triggers?

TCS,

7 28434

what are stored procedures?

TCS, Wells Fargo,

7 26874

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

Green Info Solutions, TCS,

7 31484

what are views?

TCS,

8 34971

what is web server?

Satyam,

3 25682

What are functions

3 22883

What are the different table present in MYsql?

3 25638

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 26358

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

i2, Oracle,

2 30967

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

CA,

1 17708

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

2 6733

Un-Answered Questions { Databases }

How do I insert multiple rows in a table?

895

Explain table?

1113

How do you delete duplicates in sql query using rowid?

946

How many types of indexes are there in mysql?

914

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

1004

When you use @@error and try-catch?

1043

What is the importance of three tier architecture?

1093

What is merge join?

1196

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

1004

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2083

What is database architecture? : sql server architect

882

Where is mysql data stored linux?

1017

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2103

Why oracle forms required?

1039

What are the various oracle database objects?

1144

For More Un-Answered { Databases } Questions Click Here