SQL Question Answer For Beginners - Part D

1. What is the purpose of DTS?
2. What data sources can DTS connect to?
3. How do you transform data during the export/import procedure?
4. What tool can you use you use to design and modify DTS packages?
5. What is BCP?
6. What are the differences between BCP and the data transformation
package?
7. What databases do you need to back up? Why?
8. What media can you back up to?
9. What is a backup device?
10. What are the two ways of creating a backup of a SQL Server database?

11. What is the purpose of a database transaction log?
12. What might cause a database transaction log to fill up?
13. How does full backup differ from differential backup?
14. Is it possible to create a differential backup for a transaction log?
15. What are the steps for restoring a database from a normal backup?
16. How does backup and restoration of the Master database differ from any
other backup and restore operation?
17. What is the main purpose of a replication? What are the three types of servers (components) in the replication
model and what are their purposes?
19. What are the two types of subscription?
20. Name the replication agents.


1. DTS imports and exports data from a SQL Server database.
2. Any data source for which there is a valid OLE DB provider.
3. Either by attaching a VBScript module or T-SQL conversions to the DTS
package.
4. DTS Export/Import wizards.
5. BCP is the Bulk Copy command-line utility program; it uses the DB
Library interface to import and export large amounts of data into or out
of SQL Server.
6. BCP has only limited support for transferring data between heteroge-neous
data sources, virtually no support for data transformation, and no
visual interface for administration.
7. The system databases, especially the Master database, must be backed up
periodically, and before and after any major change to server properties,
so that you will be able to recover from a disaster. User databases should
be backed up periodically to minimize potential data loss.
8. Tape backup devices, files, and logical backup devices.
9. A backup device is a structured storage file. You can organize it in such a
way that it becomes storage for logical devices.
10. With the Database Backup Wizard or with Transact-SQL statements.

11. It is a sequential record of all transactions since the last differential or
database backup. You can use it to recover a database up to the point of
failure.
12. Unfinished transactions.
13. A differential backup backs up all data that have changed since the last
complete backup. It is much faster than a complete backup but can only
be used in conjunction with a full backup, and is not allowed on the
Master database.
14. No, transaction log can be backed up only all at once. Transaction log
keeps track of the changes made to the database and is used to deter-mine
what part is supposed to be backed up during a differential backup
of the database.
15. First restore the last full backup; then apply all transaction-log backups,
starting from the oldest.
16. You can only perform a full backup of the Master database, not a differ-ential
or transaction-log backup; when restoring the Master database you
should use only the Recovery Complete option.
17. Distribution of identical data across several data sources.
18. Publisher —A source server for the distributed data. It maintains all the
information about the data specified for publishing.
Distributor —An intermediary between the Publisher and the Subscriber,
which can also be both Publisher and Subscriber. Its role varies depending
on the type of replication you select.
Subscriber —The final destination of the distributed data.
19. PUSH subscriptions and PULL subscriptions.
20. Replication agents are utilities that assist in the replication process.

No comments: