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

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

3 7451

What is Self Join?

4 6593

what is data abstraction

Semantic Space,

3 7081

What is mutating trigger?How to avoid it??

Tech Mahindra,

3 13934

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 16572

How do you invoke datastage using unix?

3 6839

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

7 12264

how to take mysql database structure backup

6 10864

How do you start MySQL on Linux?

Cybernet,

5 7963

How to get max 100 values from sql server

7 13392

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

CarrizalSoft Technologies, DELL, SoftSol,

7 11675

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

EDS,

2348

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 5124

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 22531

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 8360

Un-Answered Questions { Databases }

How many columns can you create for an index?

952

What is oracle d2k? Why we use it?

What is openedge workgroup rdbms?

1012

What are user-defined functions (udfs) in sql server?

989

How can a function retun more than one value in oracle with proper example?

1074

What is a php database?

880

Explain the third normal form(3nf)?

943

What is the benefit of using access over excel?

789

what is a relationship and what are they? : Sql dba

1101

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

118

What are sql server functions?

981

What is ddl command?

975

How to copy data from one table to another table?

996

List the various privileges that a user can grant to another user?

1043

What is service broker? : sql server database administration

994

For More Un-Answered { Databases } Questions Click Here