SYSDBA . USER.
. 2 : , , .
2 :
- , , ;
- , , ( ).
. :
GRAND , ON [TABLE] TO , [WHITH GRAND OPTION]
:=
:=
:=
: , - - - .
PUBLIC , , SYSDBA
WITH GRAND OPTION .
:
REVOKE [GRAND OPTION FOR] , ON [TABLE] FROM
: - - . , , ( , , , ).
GRAND OPTION FOR , , .
1. :
CREATE ROLE
2.
GRAND , ON TO
3.
GRAND , TO [USER] , | PUBLIC
. Interbase , .
4. .
CONNECT [USER ] [PASSWORD ] [CACHE ] [ROLE ]
: - - , - , , , .
5. .
DROP ROLE
select
CREATE VIEW [(, )] AS <SELECT> [WITH CHECK OPTION]
WITH CHECK OPTION ( )
, , . , .
, , .
()
|
|
1. :
CREATE PROCEDURE [( , )] [RETURNS ( , )]
AS
[DECLARE VARIABLE , ]
BEGIN
END
2. GRANT. , . , , .
3. .
GRAND EXECUTE ON PROCEDURE TO ,
.
() | |||
1. | Å | + | |
2. | Å | + | |
3. | Å | + | |
4. | ( ) | + () | Å |
5. | + (-) | Å |
Å -
+ -
:
:
1. : > 0
2. : sum=kol*cena
3. : nomdoc
4. / : kolsotr = id
5. : , , , . .
SQL2
CREATE TABLE (_ [,_ | _])
_::=
{ | []}
[DEFAULT ]
[COLLATE ]
[_]
_::=
[CONSTRAINT ]
PRIMARY KEY (, )
| UNIQUE (, )
| FOREIGN KEY (, )
>> | REFERENCES [(, )]
>> _
| CHECK
_::=
[MATCH {FULL | PARTIAL}] PARTIAL
[ON DELETE {NO ACTION | CASCADE | SET NULL | SET DEFAULT}]
[ON UPDATE {NO ACTION | CASCADE | SET NULL | SET DEFAULT}]
_ _ :
[INITIALLY {DEFERRED | IMMEDIATE}] ( { | })
[NOT] DEFERRABLE , NOT .
:
SET CONSTAINTS MODE TO
{ALL | } {DEFFERED | IMMEDIATE}
CHECK .
::=
1 2
| 1 BETWEEN 1 AND 2
| [NOT] IN ( | )
| EXISTS
NULL :
::=
1 [{OR | AND} 2]
[IS [NOT] {_}]
_::= {TRUE | FALSE | UNKNOWN}
:
NOT | OR | AND | IS | |||||||||||||
T | F | U | T | F | U | T | F | U | ||||||||
T | F | T | T | T | T | T | T | F | U | T | T | F | F | |||
F | T | F | T | F | U | F | F | F | F | F | F | T | F | |||
U | U | U | T | U | U | U | U | F | U | U | F | F | T |
* IS ,
|
|
:
CREATE DOMAIN [AS]
[DEFULT ]
[ ]
, , . .
, :
CREATE ASSERTION
CHECK ()
, , . , ALTER DROP. , !
() , .. .
. 3-
,
, (, )
..
.. :
1.
2.
3.
4.
5.
6.
. . .
f min | f max | |
1,5 | ||
( ) | 180 | |
( ) | 0,5-1 | |
6 | ||
1,2 | ||
() | 0,3 | 3,4 |
() | 10^5 | |
10^6 | ||
10^4 | 10^9 | |
10^9 | 10^11 | |
- | 10^13 | 10^15 |
3 :
1.
2.
3.
4 :
1.
2.
3.
4. ( , )
(G) ()
2
.
1,2 4,8 .
. , . .
:
|
|
1.
2.
3.
, . . .
2 :
1. ( )
2. ( . , .. 1 )
3- : , . , , .. .. .
2 : .
:
, .
DSP.
, , .
, , . = 2 ( ).
. , .
, - , , .. , -, -.
, .
1. SCR M 1.21
- 0,45
-
-
-
2.
( )
- 20
-
- 5
10^(-2) 10^(-6). 10^(-6), 1- 14 .
10^(-9)
.
:
|
|
|
:
..
.
2 :
1) ( )
2) ( )
) , .. , . .
, .
) ( , ). . (-, -).
) . , . .
.
) . . , , , .
) . , . , ..
) . , , , , , . , .. .
. (10^(-6) 10^(-12)) .
, , .
:
-
-
-
CRC
FlagOk , .
.
. : (V.41 CRC 16 X^16+X^12+X^5+1), CRC . . , - ( 0).
1) . .. 1 0.
2) . . ..
2 , , 0 1 .
.
- .
|
|
2 , .
, . 2 :
)
) ( )
:
(7,6) (. )
(20,3) , , IntelSat
+
-
,
. , .
- . , .
. .
, .
. :
)
)
)
) ,
) (, 2 4 , ).
V.29 (fax) 9600 /, V.27 (fax) 4800 /. V.14 14,7 /. V.34 33,6 / V.26 2400 /, V.22.
. - .
.
, , .
,
2 :
:
1.
2. . .
3. . 600 +/-20% 1,8 . ( )
4.
:
, 8-11 (, ). , :
1. , .. 1,9
2. ,
3. . .. . :
4. Jitter () . 50
5.
6. , :
,
, , . - ,
, ..
,
. :
1.
2.
.
1. / ( SNR). + []
2. [ ]
3. . [%]
4. [].
5. 3 4
6. 100 20
7. 6 4 15
8. 12 4 15
9. [] - [] [].
, . ( ѻ).
. :
TDA-3 (DOS)
TDA-5(Windows).
.
:
1. . , . . 5-10
2.
3. /
4. . 0,8 2,0.
5. . 10-15 . 2 .
6.
7.
8.
9.
10. , ,
,
1. 40 2. | . ( ) |
3. , 4. 6 | |
5. 6. 1,5% | |
7. +/- 5% 8. +/- 1 9. +/- 7 | , |
10. 10 | |
11. , | |
12. -, 200 (V.32, V.34) |