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

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

1 1048

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

1 1097

What are the difference between primary key and unique key? : sql server database administration

1 1002

Can you tell me some of the common replication dmv's and their use? : sql server replication

1 1004

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

1 1124

What type of locking occurs during the snapshot generation? : sql server replication

1 1397

Explain what stored procedure sp_replcounters is used for? : sql server replication

1 1591

What are the different types of sql server replication? : sql server replication

1 1419

How will you monitor replication latency in transactional replication? : sql server replication

1 1242

What is sql server replication? : sql server replication

1 1080

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

1 1309

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

1 1057

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1 1288

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1 1144

Is it possible to replicate data from sql server to oracle? : sql server replication

1 1166

Un-Answered Questions { Databases }

When should you use an instead of trigger?

1048

define sql insert statement ? : Sql dba

1097

Any work done in oracle workflow builder. Did you customize or build a new workflow?

What are the steps in creating a database?

1009

List out the different types of locks available in sql server?

1046

What is oracle latest version?

1171

What are the different subsets of sql?

1648

What is clustered index

1083

How to write a left outer join with the where clause in oracle?

1151

How to put more than 1000 values into an oracle in clause?

1112

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1857

What is your daily office routine?

2344

Can you index views?

953

Why and when do stored procedure recompile?

1056

Can sql servers link to other servers like oracle?

914

For More Un-Answered { Databases } Questions Click Here