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

Determine how to use the inserted and deleted pseudo tables?

1004

Explain trigger classes i.e. Instead of and after trigger?

888

Describe triggers features and limitations?

998

What is ms sql server service broker?

1006

Please explain what is “asynchronous” communication in sql server service broker?

948

What are the components of sql server service broker?

1033

Tell me what are the essential components of sql server service broker?

961

Do you know how to implement service broker?

945

Explain what is the main purpose of having conversation group?

954

Explain sql server service broker?

989

Tell me what do we need queues in sql service broker?

1009

How to encrypt data between dialogs?

1125

Explain isolation levels that sql server supports?

1050

Explain what is lock escalation and what is its purpose?

949

Explain different types of lock modes in sql server 2000?

943

Un-Answered Questions { Databases }

What is the use of the drop option in the alter table command?

603

Can we take the full database backup in log shipping?

968

What is difference between 2 tier and 3 tier architecture?

792

Can we commit inside a function in oracle?

975

can u combine pipeline parallelism and partition parallalism? how and whan?

2346

What are the daily activities of oracle dba?

630

I need to run a report at scheduled timings only. I don't want to run the report on sundays. How to do this?

What is oracle partial backup?

591

What are different replication agents and what's their purpose? : sql server replication

1031

What is an anonymous block?

1269

What is scalar function?

1060

I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

1558

Is oracle faster than sql server?

964

How do I run multiple versions of sybase on the same server?

896

What is a transact-sql statement?

1074

For More Un-Answered { Databases } Questions Click Here