ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 043-092

043-092

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-07 21:04:01 0 删除 编辑
92. Your business has departmental reports that are generated every d
ay. Each department must use the same set of queries, but access a di
fferent subset of data in the tables, depending on which department g
enerates the report. The format of the reports is being developed; cu
rrently, the format changes daily. How would you configure the databa
se 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 sch
eduled time, supplying the necessary input variables.
B. By creating a program using DBMS_JOB that accepts one or more vari
ables, 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 repo
rt.
D. By having each user create a job using DBMS_SCHEDULER that include
s all the information and commands necessary to generate the report.
E. By creating a program using DBMS_SCHEDULER that accepts one or mor
e variables, and creating a job that calls this program using DBMS_SC
HEDULER.
Answer: E
一个企业,每天每个部门要产生一个report,这些report 只是调用的表不一样,其
它都一样。这样我们可以使用DBMS_SCHEDULER 建立一个program 接受多个变量,同时建立
一个job 调用该program 。

问题中问的是调度。设计到schedule

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-717994/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 043-091
下一篇: 043-094
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    203093