OCP-1Z0-053-V13.02-276题
来源:互联网 发布:照片漫画化软件 编辑:程序博客网 时间:2024/06/05 19:45
276.The following command is executed to create the baseline template:
SQL> EXECUTE
DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(START_TIME=>
TO_TIESTAMP(SYSDATE+2),
END_TIME=>TO_TIMESTAMP(SYSDATE+10),
BASELINE_NAME=>'Mybase4',
TEMPLATE_NAME=>'Mytemp4',
EXPIRATION=>NULL);
Which statement is true about the effect of the above command?
A. It creates a baseline template that never expires.
B. It produces an error because no snapshot information is provided to create the baseline.
C. It creates a baseline template that expires after the Automatic Workload Repository (AWR) retention period.
D. It creates a repeating baseline template that repeats after the Automatic Workload Repository (AWR) retention period.
Answer: A
答案解析:
参考:http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_workload_repos.htm#ARPLS69131
Parameters
Table 162-24 CREATE_BASELINE_TEMPLATE Procedure Parameters
start_time
Start Time for the baseline to be created'
end_time
End Time for the baseline to be created
baseline_name
Name of baseline to be created
template_name
Name for the template
expiration
Expiration in number of days for the baseline. If NULL
, then expiration is infinite, meaning do not drop baseline ever. Defaults to NULL
dbid
Database Identifier for baseline. If NULL
, this takes the database identifier for the local database. Defaults toNULL
.
day_of_week
Day of week that the baseline should repeat on. Specify one of the following values: SUNDAY
, MONDAY
, TUESDAY
,WEDNESDAY
, THURSDAY
, FRIDAY
, SATURDAY
.
hour_in_day
Value of 0-23 to specify the Hour in the Day the baseline should start
duration
Duration (in number of hours) after hour in the day that the baseline should last
baseline_name_prefix
Name for baseline prefix. When creating the baseline, the name of the baseline will be the prefix appended with the date information.
- OCP-1Z0-053-V13.02-276题
- OCP-1Z0-053-V13.02-1题
- OCP-1Z0-053-V13.02-682题
- OCP-1Z0-053-V13.02-687题
- OCP-1Z0-053-V13.02-692题
- OCP-1Z0-053-V13.02-696题
- OCP-1Z0-053-V13.02-711题
- OCP-1Z0-053-V13.02-710题
- OCP-1Z0-053-V13.02-709题
- OCP-1Z0-053-V13.02-708题
- OCP-1Z0-053-V13.02-706题
- OCP-1Z0-053-V13.02-490题
- OCP-1Z0-053-V13.02-24题
- OCP-1Z0-053-V13.02-36题
- OCP-1Z0-053-V13.02-43题
- OCP-1Z0-053-V13.02-45题
- OCP-1Z0-053-V13.02-60题
- OCP-1Z0-053-V13.02-651题
- 第十五周项目-带姓名的成绩单
- sql查询动态表名的记录
- jsp学习笔记——跳转命令
- (3)正则补充
- 正则表达式30分钟入门教程(键人岐)
- OCP-1Z0-053-V13.02-276题
- 电脑文件恢复的具体操作
- lamdba算子之布尔值理解
- 程序员不能不懂数据存储
- 获取字符窜的字节长度
- 数据库基础知识
- cocos2d-x 使用CCLabelAtlas自定义字体
- vt-shuju
- Mysql和Mongodb的Map reduce