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

In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record

Syntel,

2 5953

what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?

3i Infotech,

3 8133

what is the difference difference between procedure and packages

3i Infotech, Oracle,

2 10415

how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?

3i Infotech,

3 8617

function can return value ,procedure also return value through out parameter then what is the difference?

3i Infotech,

3 8009

function can return multiple value?how give give sample coding

3i Infotech, CTS, Excelity Global, UHG,

2 16302

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.

3i Infotech,

4 11731

why we use nocopy?

Polaris,

2 7583

what is explain plan?, given an example...

Polaris,

3 9750

create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

Polaris,

2 7588

What are all the difference between Like and Contains ?

LG Soft,

2 10890

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

Verizon,

2093

what is isolation level at dead lock?

Verizon,

2152

what r steps to we need to fallow b4 kill the process?

Verizon,

1 5410

If the job running very slow what is the action you do

1895

Un-Answered Questions { Databases }

What is the order in which the sql query is executed?

942

What is a database table?

977

explain pdq priority?

Explain the truncate in oracle?

968

How to assign new column names in a view?

919

What is the significance of master, tempdb and model databases?

1081

Define tool Manage Statistics in SQL Server 2000 query ?

1099

Does google use mongodb?

What is an sql server agent?

1070

What are the differences between drop, truncate and delete commands?

1066

What is the difference between push and pull subscription? : sql server replication

1219

who introduced sql?

1026

what is the different types of backups available in sql server? : Sql server database administration

934

What is database optimization?

959

What is difference between stored procedures and application procedures?

1015

For More Un-Answered { Databases } Questions Click Here