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

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

993

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

1038

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

958

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

942

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

1068

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

1350

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

1533

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

1300

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

1161

What is sql server replication? : sql server replication

1005

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

1231

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

999

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

1236

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

1091

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

1105

Un-Answered Questions { Databases }

What is clustered table in Oracle?

1220

Define neo4j?

what are different types of raid configurations? : Sql server database administration

1074

Can we insert data if clustered index is disabled?

960

What are the restrictions that views have to follow?

993

Does mysql use t sql?

992

what are user defined datatypes? : Sql server database administration

982

List out some of the requirements to set up a sql server failover cluster?

1046

How to restore sybase database in sap?

978

what is the difference between sql and t-sql? : Transact sql

1103

What do you mean by cluster and non cluster index?

1097

What is building blocks of client/server?

1124

Is truncate ddl or dml?

1004

What are the different kinds of ssrs reports?

217

What is the difference between nvl and nvl2?

997

For More Un-Answered { Databases } Questions Click Here