Oracle OCP 082知识
剩余时间:
第 77 题 (多选题):
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data.
A. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted.
B. Primary key and foreign key constraints can be defined at both the column and table level.
C. A table can have only one primary key and one foreign key.
D. A table can have only one primary key but multiple foreign keys .
E. Only the primary key can be defined at the column and table level.
F. The foreign key columns and parent table primary key columns must have the same names.
G. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted
显示答案
正确答案:
A,B,D,G
解析:
上一题
下一题
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