Multiple choices 16/50
(Choose 1 answer)
Next
What is the purpose of "OR IGNORE" in the following SQL:
INSERT OR IGNORE INTO Course (title) VALUES (?)
A. It makes sure that if a particular title is already in the table, there are no duplicate rows inserted
B. It ignores errors in the SQL syntax for the statement
C. It updates the created_at value if the title already exists in the table
D. It ignores any foreign key constraint errors
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 47
43
44
45 46 47 48
49 50