05-07-2012, 04:50 PM
: DATABASE ADMINISTRATION QUESTION PAPER
1DATABASE ADMINISTRATION.doc (Size: 24 KB / Downloads: 69)
PART-A
Q1:To automate many of the tasks you need to perform to maintain your SQL Server, you must define schedules for when your jobs run. Create a new schedule for your Simple Backup job that will run the job every weekday at noon.
Q2. Mention all the steps you have to take while creating a job schedule and henceforth attaching it to the job for which you have designed that schedule .Take an example at your own.
Q3:-What is SQL Server Agent Service. How it helps in automating various administrative task. Explain its various properties.
PART-B
Q4. Differentiate between Differential backups, Transaction-log backups, File-group backups.
Q5. Explain the various steps to restore your database .Give T-SQL query as well.
Q6..Write the various steps of configuring database mail feature in SQL Server 2005.How a mail can be send using SQL Server 2005.