ʱ : һ oracle10g数据库选择题翻译答?- 百度文库ϿʼĶ
BֵͬͲͬԶǽ Cơ͡˳ͬӳ Dͬͬӳ Eӳͬͻ˳ͬ 5ڰȷǣD AǶס Bݲ
CÿεǼصڴС DԱӦù
6ڰȷǣCE A淶Ͱ嶼ǰıɲ֡ B淶ǿѡģDZġ C淶DZģǿѡġ DݿУ淶Ͱ洢һ EݿУ淶ͰǷֿ洢ġ
7EMPһмǰаһEMPIJѯ䣬ȷʵֵڸλ߹ʺ֮䣬EMPеĹʱᷢʲôC
Aɹִ
BûдΪмAFTER UPDATE¼
CִʧܣΪִUPDATEıSELECTDz
25 / 30
DִʧܣΪBEFORE UPDATEʹMINMAX
8ݿⴥһ־ִеĴA A B C¼ Dʱ
9һCALCTAX
CREATE OR REPLACE FUNCTION calctax (sal NUMBER) RETURN NUMBER IS BEGIN RETURN (sal * 0.05); END;
SQL*PLUSִиúȷE AִCALCTAX (1000);.
BִEXECUTE FUNCTION calctax;. CSQL*PlusXִ: X :
26 / 30
= CALCTAX (1000);.
DSQL*PlusXִEXECUTE: X : = CALCTAX;.
ESQL*PlusXִEXECUTE: X : = CALCTAX (1000);
10ִSELECTFOR UPDATEA
AʱִCOMMITROLLBACKʹûݸı BѡݣȻύعԽ
CʱִCOMMITROLLBACKֻеݸı DûݸıͲԲִCOMMITROLLBACK 17±ָ
ûԭ(ѡ)AD A.ݱύ B.ϵͳ C.Ȩ D.ض E.Ӧļɾ
27 / 30
F.ӦóѰַ쳣
(1)־аݿⱸݻϢB A.ļʼ״̬ B.ռ俪ʼ״̬ C.ݿⱸ״̬ɴر D.ݿļвϵͳ
(2)±ֻռлعѡ֣CD A.ָɶдıռ䣻
B.ָļûеıռ䣻 C.ָֻռ䣬ϴαʱҲΪֻ D.ָɶдıռ䣬ϴαʱΪֻ E.ָֻռ䣬ϴαʱΪɶд
(3)һռڴãݿڷǴ浵ģʽԱӦʹݿãB
Aݿָ Bݿȫָ
C֮ǰݿȫݻԭļ־ļͿļ Dʹݿ
(4)Ϊʲôʹֶ鵵C AҪĴԴ BҪĺ̨
28 / 30