250.You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation.
The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system.
How would you create these jobs?
A. Create both jobs by using events raised by the scheduler
B. Create both jobs by using events raised by the application
C. Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the scheduler
D. Create a job to rebuild indexes by using events arised by the Scheduller and then create another job to perform bulk load by using events raised by the application
Answer: D
你要安排一份作业,在一个大容量的批量加载操作完成后,重新安排销售表的所有索引。
批量加载操作还必须是一个计划的作业,它将在系统中包含数据的第一个文件到达时执行。
你如何创建这些作业?
参考:
http://docs.oracle.com/cd/E11882_01/server.112/e25494/scheduse.htm#ADMIN12361
关于事件
一个事件是一个应用程序或系统进程发送的消息,以指示某些动作或事件已被检测到。事件由一个应用程序或进程(发送)提出,并由一个或多个应用程序或进程(接收)消耗。
有2种事件消耗的调度程序:
? 由您的应用程序引发的事件
? 文件监视器引发的文件到达事件
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/81227/viewspace-2120296/
,如需转载,请注明出处,否则将追究法律责任。