单选题You are creating a job class. You want access to the detailed information for all the runs of each job in the class and every operation performed on every job in the class. Which setting will you use for the LOGGING_LEVEL parameter？（）A LOGGING_OFFB LOGGING_RUNSC LOGGING_FULLD LOGGING_NULL
单选题
You are creating a job class. You want access to the detailed information for all the runs of each job in the class and every operation performed on every job in the class. Which setting will you use for the LOGGING_LEVEL parameter？（）
A
LOGGING_OFF
B
LOGGING_RUNS
C
LOGGING_FULL
D
LOGGING_NULL
参考解析
解析：
暂无解析
相关考题：
You are the network administrator for TestKing. You manage a Windows Server2003 computer named TestKing4 that functions as an application server.TestKing4 will be used for development during the next 30 days. You need to backup all data on TestKing4 every day for the next 30 days.You need to automate the backups of TestKing4 to meet these businessrequirements. You want to achieve this goal by using the minimum amount ofadministrative effort.What should you do?（）A. Create a scheduled backup job as a normal backup. Copy the backup job, and modify the start date so that one job starts every day for the next 30 days.B. Create a scheduled backup job as a daily backup. Set the start date of the job for today, and set the end date for 30 days from today.C. Create a scheduled backup job as a copy backup. Copy the backup job, and modify the start date so that one job starts every day for the next 30 days.D. Create a scheduled backup job as a normal backup. Set the start date of the job for today, and set the end date for 30 days from today.
You are the network administrator for All network servers run Windows Server 2003.A member server named TESTKING1 hosts several hundred folders, which residein various locations on the server. TESTKING1 is configured to run a normalbackup of the folder every Saturday at 1:00 A.M.You discover that users edit the contents of the folders on Saturday and Sunday.You need to use the Backup utility to reschedule the backup job so that it runs everyMonday at 1:00 A.M. instead of every Saturday at 1:00 A.M. You must achieve thisgoal by using the minimum amount of administrative effort.What should you do?（）A. Specify Monday as the start date of the job.B. Reconfigure the job schedule to run the backup every Monday at 1:00 a.m.C. Add an additional schedule to the job. Configure the additional schedule to run the backup on Monday at 1:00 a.m.D. Use the Repeat Task option to configure the existing job to repeat every 48 hours until an interval of 336 hours passes.
While creating a job class using the DBMS_SCHEDULER package， you set the logging level to LOGGING_RUNS. What would be the impact of this setting？（）A、 Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.B、 Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.C、 Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.D、 Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.
You want to limit access to a method of a public class to members of the same class. Which access accomplishes this objective？（） A、 publicB、 privateC、 protectedD、 transientE、 default access
You want to limit access to a method of a public class to members of the same class. Which access modifier accomplishes this objective？（） A、 PublicB、 PrivateC、 ProtectedD、 TransientE、 No access modifier is required
Using Oracle Scheduler you have scheduled two jobs， JOB_Aand JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）A、 A window must have been created with the WEEKEND_PLAN resource plan.B、 A program must have been created with the WEEKEND_PLAN resource plan.C、 A job class must have been created with the WEEKEND_PLAN resource plan.D、 A window group must have been created with the WEEKEND_PLAN resource plan.
You are creating a job class. You have issued the following command to create the job class： SQL BEGIN DBMS_SCHEDULER.CREATE_JOB_CLASS（ JOB_CLASS_NAME = ’LOW_PRIORITY_CLASS’， RESOURCE_CONSUMER_GROUP = ’LOW_GROUP’， LOGGING_LEVEL = DBMS_SCHEDULER.LOGGING_FULL， LOG_HISTORY = 1200， COMMENTS = ’LOW JOB PRIORITY CLASS’）； END； SQL / What will be the result of the above command？（）A、 The command will be executed successfully.B、 The command will fail because RESOURCE_CONSUMER_GROUP is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.C、 The command will fail because LOGGING_LEVEL is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.D、 The command will fail because LOG_HISTORY is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.E、 The command will fail because 1200 is an invalid value for the LOG_HISTORY parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
You are creating a job class. You want access to the detailed information for all the runs of each job in the class and every operation performed on every job in the class. Which setting will you use for the LOGGING_LEVEL parameter？（）A、 LOGGING_OFFB、 LOGGING_RUNSC、 LOGGING_FULLD、 LOGGING_NULL
Your business has departmental reports that are generated every day. Each department must use the same set of queries， but access a different subset of data in the tables， depending on which department generates the report. The format of the reports is being developed； currently， the format changes daily. How would you configure the database to ensure that each department generates its report （based on its target data） using the most recent report format every day？（）A、 By having each user run the report generation procedure at the scheduled time， supplying the necessary input variables.B、 By creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOB.C、 By having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the report.D、 By having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report.E、 By creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER.
William is creating a job class. William specifies the LOGGING_FULL setting for the LOGGING_LEVEL attribute at the time of job class creation. What is the impact of using this setting？（） A、 Detailed information regarding the first run of each job in the class will be written in the job log， and every operation performed on the job class will be logged.B、 Detailed information regarding each run of only the first job in the class will be written in the job log， and every operation performed on the job class will be logged.C、 Detailed information regarding each run of each job in the class will be written in the job log， and every operation performed on the job class will be logged.D、 Detailed information regarding each run of each job in the class will be written in the job log， but operations performed on the job class will not be logged.
You work in a company which is named Wiikigo Corp. The company 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 computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? （） A、You should use local Service accountB、You should use network Service accountC、You should use domain accountD、You should use local System account
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 stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed. What should you do？ （）A、You should create a job which is assigned to the Database Maintenance categoryB、You should create an Alert which will run another to delete the maintenance job.C、You should create a job. You schedule the job to run only once.D、You should create a job. The job uses the Automatically delete job option
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 business has departmental reports that are generated every day. Each department must use the same set of queries， but accesses a different subset of data in the tables， depending on which department generates the report. The format of the reports is being developed; currently， the format changes daily. How would you configure the database to ensure that each department generates its report （based on its target data） using the most recent report format every day？（）Aby having each user run the report generation procedure at the scheduled time， supplying the necessary input variablesBby creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOBCby having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the reportDby having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the reportEby creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER
单选题While creating a job class using the DBMS_SCHEDULER package， you set the logging level to LOGGING_RUNS. What would be the impact of this setting？（）A Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.B Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.C Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.D Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.
单选题You are creating a job class. You have issued the following command to create the job class： SQL BEGIN DBMS_SCHEDULER.CREATE_JOB_CLASS（ JOB_CLASS_NAME = ’LOW_PRIORITY_CLASS’， RESOURCE_CONSUMER_GROUP = ’LOW_GROUP’， LOGGING_LEVEL = DBMS_SCHEDULER.LOGGING_FULL， LOG_HISTORY = 1200， COMMENTS = ’LOW JOB PRIORITY CLASS’）； END； SQL / What will be the result of the above command？（）A The command will be executed successfully.B The command will fail because RESOURCE_CONSUMER_GROUP is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.C The command will fail because LOGGING_LEVEL is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.D The command will fail because LOG_HISTORY is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.E The command will fail because 1200 is an invalid value for the LOG_HISTORY parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
单选题When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?（）ASET_JOB_ARGUMENT_VALUEBSET_JOB_VALUE_ANYDATACSET_JOB_ANYDATA_VALUEDSET_SPECIAL_JOB_VALUEESET_JOB_ANYTYPE_VALUE
单选题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
单选题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 the network administrator for The network consists of a single Active Directory domain All network servers run Windows Server 2003. A member server named TestKingSrv1 functions as the backup server. Every night, TestKingSrv1 performs a normal backup of all files on drive D:/ of all servers in the domain. Files are stored on magnetic tape. A new written company security policy states that all servers must be protected from registry corruption. You need to ensure that a current copy of the registry from every server on the network is automatically backed up daily on magnetic tape. What should you do?（）AOn TestKingSrv1, create a new backup job that runs every day. Configure the job to back up drive C:/ on every network server.BOn TestKingSrv1, select Options, and then select the Exclusions tab. Remove all exclusions for files of the Registry Writer application type.COn each network server, start Registry Editor. On the File menu, select Export. Specify All as the export range. Export the registry to drive D:/.DOn each network server, configure a new backup job that runs every day. Configure the job to back up each server's System State data in a file on drive D:/.
单选题You work in a company which is named Wiikigo Corp. The company 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 computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? （）AYou should use local Service accountBYou should use network Service accountCYou should use domain accountDYou should use local System account
单选题William is creating a job class. William specifies the LOGGING_FULL setting for the LOGGING_LEVEL attribute at the time of job class creation. What is the impact of using this setting？（）A Detailed information regarding the first run of each job in the class will be written in the job log， and every operation performed on the job class will be logged.B Detailed information regarding each run of only the first job in the class will be written in the job log， and every operation performed on the job class will be logged.C Detailed information regarding each run of each job in the class will be written in the job log， and every operation performed on the job class will be logged.D Detailed information regarding each run of each job in the class will be written in the job log， but operations performed on the job class will not be logged.
单选题You want to limit access to a method of a public class to members of the same class. Which access accomplishes this objective？（）A publicB privateC protectedD transientE default access
单选题You are the network administrator for All network servers run Windows Server 2003. A member server named TESTKING1 hosts several hundred folders, which reside in various locations on the server. TESTKING1 is configured to run a normal backup of the folder every Saturday at 1:00 A.M. You discover that users edit the contents of the folders on Saturday and Sunday. You need to use the Backup utility to reschedule the backup job so that it runs every Monday at 1:00 A.M. instead of every Saturday at 1:00 A.M. You must achieve this goal by using the minimum amount of administrative effort. What should you do?（）ASpecify Monday as the start date of the job.BReconfigure the job schedule to run the backup every Monday at 1:00 a.m.CAdd an additional schedule to the job. Configure the additional schedule to run the backup on Monday at 1:00 a.m.DUse the Repeat Task option to configure the existing job to repeat every 48 hours until an interval of 336 hours passes.
单选题Using Oracle Scheduler you have scheduled two jobs， JOB_Aand JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）A A window must have been created with the WEEKEND_PLAN resource plan.B A program must have been created with the WEEKEND_PLAN resource plan.C A job class must have been created with the WEEKEND_PLAN resource plan.D A window group must have been created with the WEEKEND_PLAN resource plan.
单选题You are the network administrator for TestKing. You manage a Windows Server 2003 computer named TestKing4 that functions as an application server. TestKing4 will be used for development during the next 30 days. You need to back up all data on TestKing4 every day for the next 30 days. You need to automate the backups of TestKing4 to meet these business requirements. You want to achieve this goal by using the minimum amount of administrative effort. What should you do?（）ACreate a scheduled backup job as a normal backup. Copy the backup job, and modify the start date so that one job starts every day for the next 30 days.BCreate a scheduled backup job as a daily backup. Set the start date of the job for today, and set the end date for 30 days from today.CCreate a scheduled backup job as a copy backup. Copy the backup job, and modify the start date so that one job starts every day for the next 30 days.DCreate a scheduled backup job as a normal backup. Set the start date of the job for today, and set the end date for 30 days from today.
单选题Your business has departmental reports that are generated every day. Each department must use the same set of queries， but access a different subset of data in the tables， depending on which department generates the report. The format of the reports is being developed； currently， the format changes daily. How would you configure the database to ensure that each department generates its report （based on its target data） using the most recent report format every day？（）A By having each user run the report generation procedure at the scheduled time， supplying the necessary input variables.B By creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOB.C By having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the report.D By having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report.E By creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER.