单选题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.

单选题
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.


参考解析

解析: 暂无解析

相关考题:

Are you responsible for the maintenance of surveillance cameras within one year?A.Yes. Our company promises to provide free serviceB.Yes. Our company promises to provide post-sale services.C.Yes. Our company promises to provide good post-sale services.D.No. Our company doesn’t promise to provide post-sale services.

– ()– Thank you. I must say I have a great staff. ? A、I’d like you to meet Joe Stevens. He’s our sales team head.?B、Please allow me to introduce my colleague to you. She is the Purchasing Manager.C、It’s a pleasure to meet you, Ben. So you’re the one responsible for those outstanding sales figures I’ve seen.

What percentage of your college did you college did you pay for and what sort of jobs did you have while you were in school?

The chief officer is responsible ()the overall maintenance of deck department.A、forB、toC、withD、of

大副负责整个甲板部的维修保养工作。()A、The chief officer is responsible for the overall maintenance of the deck department.B、The second officer is responsible for the overall cleaning of the deck department.C、The third officer is responsible for the overall maintenance of the deck department.D、The chief officer is responsible for the overall cleaning of the deck department.

By default, who is responsible for firmware and software updates of an SVC solution? ()A、the customerB、IBM customer engineerC、certified IBM Business PartnerD、IBM Maintenance and Technology Support organization

How can you create a listener class that receives events when the mouse is moved?()  A、 By extending MouseListener.B、 By implementing MouseListener.C、 By extending MouseMotionListener.D、 By implementing MouseMotionListener.E、 Either by extending MouseMotionListener or extending MouseListener.F、 Either by implementing MouseMotion Listener or implementing MouseListener.

Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run?()A、 use DBMS_IJOB packageB、 use Oracle SchedulerC、 use DBMS_JOB packageD、 use Oracle Data Pump Export and Import

Which three statements are true regarding the functioning of the Autotask Background Process (ABP)?()A、 It creates jobs without considering the priorities associated with them.B、 It translates tasks into jobs for execution by the scheduler.C、 It determines the list of jobs that must be created for each maintenance window.D、 It is spawned by the MMON background process at the start of the maintenance window.E、 It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.

You work as the IT professional in an international company which is named Wiikigo. You are experiencedin implementing and administering a network operating system. You are specialized in deploying servers,configuring Windows Server 2008 Terminal services and network application services, and configuring aweb services infrastructure. You have the Web Server (IIS) server role installed on two servers. The twoservers are respectively named S01 and S02. Windows Server 2008 is run by the servers. Your companyhas a Web site named www.wiikigo.com hosted on S01. The Web site is due for maintenance. The Webcontent must be available during maintenance. You create a mirror Web site located on S02. The www.wiikigo.com site needs to be configured to redirect requests to S02. What action should you perform first?()A、The appcmd set config /section:httpRedirect /enabled:false command should be run.B、The appcmd set config /section:httpRedirect /enabled:true command should be run.C、The appcmd set site /site.name:wiikigo /+bindings.[protocol=’http’,www1.wiikigo.com] command shouldbe run.D、The appcmd set site /site.name:wiikigo /-bindings.[protocol=’http’,www.wiikigo.com] command should be run.

You work as the IT professional in an international company which is named Wiikigo. You are experiencedin implementing and administering a network operating system. You are specialized in deploying servers,configuring Windows Server 2008 Terminal services and network application services, and configuring aweb services infrastructure. There are four Terminal Servers that run Windows Server 2008. The TerminalServers are respectively named S01, S02, S03, and S04. You have the Terminal Server Session Brokerrole service installed on S01. You have to configure load balancing for the four Terminal Servers. Now youreceive an order from the company management. According to the company requirement, you must makesure that S02 is the preferred server for Terminal Services sessions. Which tool should you choose to use?()A、You should choose to use TS Gateway ManagerB、You should choose to use Terminal Services ManagerC、You should choose to use Group Policy ManagementD、You should choose to use Terminal Services Configuration

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. You put forward a database maintenance plan. The maintenance plan rebuilds indexes, checks database integrity, writes a report to a text file. Now the company requires that when the maintenance plan executes abnormally, the operators can be notified by an e-mail message. You've been assigned this task. So you have to make modifications on the SQL Server instance. What should you do?()A、For the SQL Server Agent, you should enable a fail-safe operator B、You should modify the database maintenance plan, making it send an e-mail to the appropriate operators C、You should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators. D、You should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.

You need to recommend changes to the DFS infrastructure that meet the company’s techical  requirements.   What should you recommend implementing in each branch office?()A、a DFS namespace serverB、a DFS replicaC、a standalone DFS namespaceD、BranchCache in Distributed Cache modeE、BranchCache in Hosted Cache mode

You work as a system administrator at Certkiller.com. You are in the process of creating anASP.NET application using Microsoft .NET Framework v3.5.  You receive an instruction from management to create a custom-templated server control. Toensure productivity you need to make sure that the child controls of the newly created servercontrol are identified within the hierarchy of the page. You thus need to identify the interface thatwill accomplish this.  What should you do?()A、You should consider implementing the IRequiresSessionState interface.B、You should consider implementing the ITemplatable interface.C、You should consider implementing the IPostBackDataHandler interface.D、You should consider implementing the INamingContainer interface

单选题You work as a system administrator at Certkiller.com. You are in the process of creating anASP.NET application using Microsoft .NET Framework v3.5.  You receive an instruction from management to create a custom-templated server control. Toensure productivity you need to make sure that the child controls of the newly created servercontrol are identified within the hierarchy of the page. You thus need to identify the interface thatwill accomplish this.  What should you do?()AYou should consider implementing the IRequiresSessionState interface.BYou should consider implementing the ITemplatable interface.CYou should consider implementing the IPostBackDataHandler interface.DYou should consider implementing the INamingContainer interface

单选题By default, who is responsible for firmware and software updates of an SVC solution? ()Athe customerBIBM customer engineerCcertified IBM Business PartnerDIBM Maintenance and Technology Support organization

单选题()is the officer responsible for the overall maintenance of deck department.ABosunBChief officerCThird officerDSecond officer

多选题You need to recommend changes to the DFS infrastructure that meet the company’s techical  requirements.   What should you recommend implementing in each branch office?()Aa DFS namespace serverBa DFS replicaCa standalone DFS namespaceDBranchCache in Distributed Cache modeEBranchCache in Hosted Cache mode

单选题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?()ACreate 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.BCreate 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.CCreate 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.DCreate 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

单选题大副负责整个甲板部的维修保养工作。()AThe chief officer is responsible for the overall maintenance of the deck department.BThe second officer is responsible for the overall cleaning of the deck department.CThe third officer is responsible for the overall maintenance of the deck department.DThe chief officer is responsible for the overall cleaning of the deck department.

单选题You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 contains a database that utilizes SQL Server log shipping. Log shipping occurs every 30 minutes. Each night, a full backup is made of the database, and all database indexes are rebuilt. The company’s network administrator reports that SQL1s network utilization becomes excessive after the nightly maintenance tasks are complete. You need to reduce the network bandwidth utilization for SQL1. What should you do?()AConfigure the database to use the bulk-logged recovery model.BEach night, rebuild only those indexes that require it.CDisable log shipping before the nightly maintenance. Re-enable log shipping after nightly maintenance completes.DIncrease the time between transaction log backups.

单选题As a network engineer at Certpaper.com, you are responsible for Certpaper network. Which will benecessarily taken into consideration when implementing Syslogging in your network?()AEnable the highest level of Syslogging available to ensure you log all possible event messagesBUse SSH to access your Syslog informationCLog all messages to the system buffer so that they can be displayed when accessing the routerDSyncronize clocks on the network with a protocol such as Network Time Protocol

单选题You have a print server that runs Windows Server 2003 Service Pack 2 (SP2). Users report that print jobs are not printing. Users also report that they do not receive any error messages. You notice a large number of jobs in the print queue. You attempt to delete some jobs from the queue and notice that the jobs remain in the queue. You need to ensure that users can print successfully. What should you do? ()ARestart the Print Spooler service.BPause the printer, and then restart the printer.CTake ownership of the printer, and then delete the print jobs.DAssign the Manage Documents permission to the users connected to the printer.

单选题Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run?()A use DBMS_IJOB packageB use Oracle SchedulerC use DBMS_JOB packageD use Oracle Data Pump Export and Import

单选题The chief officer is responsible ()the overall maintenance of deck department.AforBtoCwithDof

单选题According to the Sale Contract,it’s of FOB plus S.T.term.It’s quite obvious that().Aour ship is not responsible for trimming and stowingBour ship is responsible for trimming and stowingCour ship is responsible for expensesDour ship is not responsible for expenses

多选题Which three statements are true regarding the functioning of the Autotask Background Process (ABP)?()AIt creates jobs without considering the priorities associated with them.BIt translates tasks into jobs for execution by the scheduler.CIt determines the list of jobs that must be created for each maintenance window.DIt is spawned by the MMON background process at the start of the maintenance window.EIt maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.