[单选] You are responsible for implementing maintenance jobs on a SQL Server 2005 database server. Certain jobs run every Sunday and other jobs run at the beginning of every month. You need to schedule the jobs in the way that uses the least amount of administrative effort. What should you do? （）

A . Create a job schedule that runs every Sunday. Assign weekly tasks to this schedule. Create a second schedule that runs on the first day of every month. Assign monthly tasks to this schedule.
B . Create a job for each task that runs once a day. Use a Transact-SQL statement to check the date and day of the week. If the day is either a Sunday or the first day of the month, execute the code.
C . Create a job schedule that runs once a day. Assign jobs to this job schedule. If the day is either a Sunday or the first day of the month, execute the jobs.
D . Create a job for each task that runs once a week on Sunday. Add a second job schedule that runs the job on the first of the month.

以下不属于根据仓库保管条件的不同将仓库分类的是（）普通仓库。专用仓库。特种仓库。保税仓库。 Your database is running in the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（） modify the HASH_AREA_SIZE initialization parameter。 modify the PGA_AGGREGATE_TARGET initialization parameter。 modify the WORK_AREASIZE_POLICY initialization parameter。 increase the value of the SGA_TARGET initialization parameter。 increase the value of the SGA_MAX_SIZE initialization parameter。 increase the value of the SORT_AREA_SIZE initialization parameter。必需氨基酸 The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve by the above process（） The database user OPS$SKD will be able to administer the database.。 The authentication detail for the database user OPS$SKD is recorded in the password file.。 The local operating system user SKD will be able to access the database instance without specifying theusername and password.。 The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.。了解中学生思维能力与创新能力和实践能力发展的过程与特点，属于（）。 You are responsible for implementing maintenance jobs on a SQL Server 2005 database server. Certain jobs run every Sunday and other jobs run at the beginning of every month. You need to schedule the jobs in the way that uses the least amount of administrative effort. What should you do? （）

参考答案：

● 参考解析

本题暂无解析

当前位置：MCITP(70-431)题库

相关题目: