单选题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？（）ALOGGING_OFFBLOGGI

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

相似考题

1.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.

2.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.

3.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

4.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.

参考答案和解析
正确答案： B
解析： 暂无解析
更多“单选题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  L”相关问题

  • 第1题：

    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、 Public
    • B、 Private
    • C、 Protected
    • D、 Transient
    • E、 No access modifier is required

    正确答案:B

  • 第2题：

    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.

    正确答案:E

  • 第3题：

    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.

    正确答案:E

  • 第4题：

    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 account
    • B、You should use network Service account
    • C、You should use domain account
    • D、You should use local System account

    正确答案:C

  • 第5题：

    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

    正确答案:A

  • 第6题：

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


    正确答案： A
    解析： 暂无解析

  • 第7题：

    单选题
    When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?（）
    A

    SET_JOB_ARGUMENT_VALUE

    B

    SET_JOB_VALUE_ANYDATA

    C

    SET_JOB_ANYDATA_VALUE

    D

    SET_SPECIAL_JOB_VALUE

    E

    SET_JOB_ANYTYPE_VALUE


    正确答案： D
    解析： 暂无解析

  • 第8题：

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


    正确答案： C
    解析： 暂无解析

  • 第9题：

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

    B

    You should use network Service account

    C

    You should use domain account

    D

    You should use local System account


    正确答案： B
    解析： 暂无解析

  • 第10题：

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


    正确答案： A
    解析： 暂无解析

  • 第11题：

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


    正确答案： B
    解析： 暂无解析

  • 第12题：

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


    正确答案： D
    解析： 暂无解析

  • 第13题：

    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.

    正确答案:C

  • 第14题：

    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

    正确答案:C

  • 第15题：

    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.

    正确答案:C

  • 第16题：

    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 category
    • B、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

    正确答案:D

  • 第17题：

    单选题
    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？（）
    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


    正确答案： E
    解析： 暂无解析

  • 第18题：

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


    正确答案： A
    解析： 暂无解析

  • 第19题：

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


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    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?（）
    A

    On TestKingSrv1, create a new backup job that runs every day. Configure the job to back up drive C:/ on every network server.

    B

    On TestKingSrv1, select Options, and then select the Exclusions tab. Remove all exclusions for files of the Registry Writer application type.

    C

    On each network server, start Registry Editor. On the File menu, select Export. Specify All as the export range. Export the registry to drive D:/.

    D

    On 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:/.


    正确答案： D
    解析： 暂无解析

  • 第21题：

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


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    You want to limit access to a method of a public class to members of the same class. Which access accomplishes this objective？（）
    A

     public

    B

     private

    C

     protected

    D

     transient

    E

     default access


    正确答案： C
    解析： 暂无解析

  • 第23题：

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


    正确答案： B
    解析： 暂无解析

  • 第24题：

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


    正确答案： E
    解析： 暂无解析

相关内容