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

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

Microsoft,

2 7222

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 21859

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

IBM, TCS,

2 17421

What is INTVAL( )and where we use Plz any body help me

1 5880

what is primary key and foreign key when and where have to use

5 7521

can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.

2062

can we use a having cluase in groupby clause. if there are 500 records i will give rownumber<250 then how many records does it retrieve. wt is the result of nvl2(null,notnull,null) if there are four tables without using cartesian how many joins can be there. in the sql subqueries wt is the parent ans1)select 2)update,3) delete 4)2&3

i2,

2 6053

What is the difference between a stored procedure and a user defined function in sql server?

Millennium,

2 7867

could u plz explain about joins and views?

2 5272

plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005

3 5345

can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)

1 6476

what is the sql equivaent of the dataset relation object ?

2030

Differences between UNIQUE and DISTINCT in select statements

ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,

26 135745

what is view?

Accenture,

7 10972

How the Action Trigger works? and what is full syntex of srw.run_report?

CMC, Yantro Software,

1 9011

Un-Answered Questions { Databases }

List out the difference between commit, rollback, and savepoint?

1039

How do I view blob data?

863

What are the requirements to use odbc connections in php scripts?

1122

Discuss row chaining, how does it happen? How can you reduce it?

544

What are the different editions available in sql server 2000?

1056

What is the best partition size for windows 10?

1003

Mention what are the file storage options provided by oracle database for oracle rac?

Do you know what are various aggregate functions that are available?

1131

What is an entity-relationship diagram (erd)?

1217

Why MySQL is used?

1039

How to move files from one directory to another in pl sql?

1197

Is it true that mongodb uses bson to represent document structure?

Is sql harder than python?

1110

Which should I use, repagent or ltm in sybase?

972

What different steps will a sql server developer take to secure sql server?

999

For More Un-Answered { Databases } Questions Click Here