Bazy_dannykh_Uchebnoe_posobie
.pdf+ + + +
34. |
|
|
? |
|
|
, |
|
|
, |
|
|
+ |
|
, |
|
35. |
|
|
? |
|
, |
|
, |
|
, |
|
, |
+ |
, |
|
|
36. |
|
- |
? |
+ |
|
, |
|
+ |
|
, |
|
37. |
|
|
? |
|
|
; |
, |
|
, |
|
|
|
, |
, |
, |
|
|
; |
|
|
, |
|
, |
+ |
|
, |
|
|
, |
|
|
38. |
|
|
|
|
? |
|
|
181
,
,
, ,
+ ,
, ,
39. ?
,
,
,
, ,
+
40.
?
+
+
41.
?
+ +
+
42. ?
+
182
+
+
183
+ + +
7. ?
+ +
+
,
+ + +
8. ?
+ ,
9. :
+ +
10.?
+
+ +
185
+
11.?
+
12.?
+ ,
13. ?
()
+ ,
,
, ,
14. ?
+ + +
15.?
+
186
16.?
+
17.?
+
18. ?
+ ; + + +
+
19. -?
()
, ,
+
20. -?
+
21. -?
187
+ +
+, +
22.
?
c
+
23.
?
+ c
24., ?
+
+
+ +
25. ?
+ «» +
+
+ ,
188
26. «-» «»?
+
27. SQL
SQL
+ SQL
+ SQL
28. |
|
(DCL) |
SQL? |
Update - |
|
+ Grant |
|
Select |
, |
Create |
, |
Drop |
|
Alter |
|
Insert |
|
Delete |
|
+ Deny - |
|
29. |
|
(DDL) |
SQL? |
Update - |
|
Grant |
|
Select |
, |
+ Create |
, |
+ Drop |
|
+ Alter |
|
189
Insert
Delete
Deny -
30.
(DML) SQL?
Update -
Grant
+ Select ,
Create ,
Drop
Alter
+ Insert
+ Delete
Deny -
31. SELECT?
+ FROM
WHERE
ORDER BY
GROUP BY
HAVING
32. SELECT?
FROM
+ WHERE
+ ORDER BY
+ GROUP BY
+ HAVING
33.
SELECT?
FROM
WHERE
190