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