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

Oracle (3253)
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

Diff. b/w Full Outer Join And Cross Join?

3 7588

What is Self Join?

4 6748

what is data abstraction

Semantic Space,

3 7237

What is mutating trigger?How to avoid it??

Tech Mahindra,

3 14115

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

Logitech, Mphasis,

1 16689

How do you invoke datastage using unix?

3 7006

What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?

7 12533

how to take mysql database structure backup

6 11156

How do you start MySQL on Linux?

Cybernet,

5 8205

How to get max 100 values from sql server

7 13634

What are the factors you will check for the performane optimization for a database query?

CarrizalSoft Technologies, DELL, SoftSol,

7 11976

IS it possible to built the oracle database without setting the kernal parameters?

EDS,

2399

I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,

2 5213

write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 22841

I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.

6 8600

Un-Answered Questions { Databases }

What is the full form of ddl?

979

The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

627

What is a checkpoint in dbms and when does it occur?

1033

Mention how oracle flex asm works?

Does office 365 include access database?

821

Why c++ used in clipper?

962

What are page splits? : SQL Server Architecture

1046

What is tablix?

169

How do you know the version of your mysql server?

1238

What is cardinality in db?

1081

What is use of trigger?

994

What are the different types of trigger and explain its various uses and functions?

1182

Explain the difference between sql and couchdb?

How do you rename a database?

977

How to convert comma separated string to array in pl/sql?

1247

For More Un-Answered { Databases } Questions Click Here