This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Replication”.
1. ___________ is a set of technologies for copying and distributing data and database objects from one database to another.
a) Replication
b) Database Mirroring
c) Log Shipping
d) None of the mentioned
View Answer
Explanation: Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks.
2. Point out the correct statement.
a) Transactional replication is typically used in server-to-server
b) Transactional replication is typically used in client-to-server
c) Transactional replication is typically used in client-to-client
d) None of the mentioned
View Answer
Explanation: Transactional replication is used in scenarios that require high throughput, including improving scalability and availability.
3. How many types of replication is provided by SQL Server?
a) 2
b) 3
c) 4
d) 5
View Answer
Explanation: Microsoft SQL Server provides three types of replication for use in distributed applications.
4. Replication in SQL Server is used to overcome ________________
a) Performance problems
b) Availability problems
c) Maintenance problems
d) All of the mentioned
View Answer
Explanation: Replication allows us to maintain the same database multiple copies at different locations.
5. Point out the wrong statement.
a) Log shipping and mirroring allows to maintain complete database redundancy
b) Replication allows to maintain some part of the database (a set of required objects) at users location
c) Replication is object level low availability feature
d) All of the mentioned
View Answer
Explanation: Replicate doesn’t distribute entire database, but only distributes some part of database like tables or views ensuring high availability feature.
6. Which of the following is a disadvantage of replication?
a) Improved performance
b) To move data closer to the user
c) Easy maintenance
d) None of the mentioned
View Answer
Explanation: In SQL Server 2005, replication had to be stopped in order to perform some actions like adding nodes, making schema changes, etc. But in 2008, these can be done online.
7. Which of the following stored procedure provide replication support for AlwaysOn?
a) sp_validate_replica_publishers
b) sp_validate_hosts_as_publishers
c) sp_validate_replica_hosts_as_publishers
d) all of the mentioned
View Answer
Explanation: Four new stored procedures provide replication support for AlwaysOn.
8. How many types of replication components are present in SQL Server?
a) 6
b) 7
c) 8
d) 9
View Answer
Explanation: SQL Server replication is based on the “Publish and Subscribe” metaphor.
9. Which of the following makes data available for replication?
a) Article
b) Publisher
c) Distributor
d) Subscription
View Answer
Explanation: Publisher is a source database where replication starts.
10. Two types of subscriptions present for replication is _____________
a) push and pull
b) throw and pull
c) push and throw
d) none of the mentioned
View Answer
Explanation: Push subscriptions are created at the Publisher server and pull subscriptions initiates the replication instead of the publisher.
Sanfoundry Global Education & Learning Series – SQL Server.
To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.
- Check SQL Server Books
- Practice Programming MCQs
- Check Information Technology Books
- Apply for Programming Internship
