Oracle OCP 082知识
剩余时间:
第 16 题 (多选题):
Choose two Examine this query: SELECT employee_id,first_name,salary FROM employees WHERE hire_date > '&1'; Which two methods should you use to prevent prompting for a hire date value when this query is executed.
A. Use the DEFINE command before executing the query.
B. Store the query in a script and pass the substitution value to the script when executing it.
C. Replace '&1' with '&&1' in the query.
D. Execute the SET VERIFY OFF command before executing the query.
E. Use the UNDEFINE command before executing the query.
F. Execute the SET VERIFY ON command before executing the query.
显示答案
正确答案:
A,B
解析:
上一题
下一题
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80