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

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 6046

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 8245

what is the difference difference between procedure and packages

3i Infotech, Oracle,

2 10551

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

3i Infotech,

3 8762

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

3i Infotech,

3 8133

function can return multiple value?how give give sample coding

3i Infotech, CTS, Excelity Global, UHG,

2 16395

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

3i Infotech,

4 11876

why we use nocopy?

Polaris,

2 7702

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

Polaris,

3 9903

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 7679

What are all the difference between Like and Contains ?

LG Soft,

2 11018

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,

2144

what is isolation level at dead lock?

Verizon,

2213

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

Verizon,

1 5493

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

1945

Un-Answered Questions { Databases }

What do you understand by a stored procedure?

1156

Please explain compound trigger in oracle?

1111

What are programming functions?

999

What is full outer join in sql server joins?

1143

What is offset in sql query?

1179

What are different types of raid levels?

1244

How to execute the cursor queries with "open" statements?

1245

How do I change global variables in mysql?

951

Define views.

1074

Explain the wait events in statspack report 'db sequential real'?

693

What is the maximum size of a database that can be opened in Microsoft Access?

930

What are the types of schema?

832

What is DB Development software?

2120

What are the 4 objects in access?

953

If you have an example table, what is the best way to get sizing data for the production table implementation?

601

For More Un-Answered { Databases } Questions Click Here