A. SELECT last_name, 12*salary* commission_pct FROM emp;
B. SELECT last_name, 12*salary* (commission_pct,0) FROM emp;
C. SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;
D. SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;
第1题
A.YoumustenabletherowmovementontheSCOTT.EMPtable.
B.YoumustdefinethetablespaceoftheSCOTT.EMPtableforautomaticsegmentspacemanagement.
C.YoumustusetheCASCADEclauseintheALTERTABLESHRINKSPACEstatement.
D.YoumustusetheCOMPACTclauseintheALTERTABLESHRINKSPACEstatement.
第2题
A.All system users have access to the MySQL server via—login path local
B.login-path can be used only for MySQL servers running on a local machine
C.login-path allows you to provide login credentials without passing clear text passwords on the command line
D.When using – login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later
第3题
Yoususpectunauthorizeddatamanipulationlanguage(DML)operationsonaparticulartable.Youwanttotrackuserswhoareperformingthetransactionsandthevaluesusedinthetransactions.Youalsoplantotransferthesevaluestoanothertableforanalysis.Howwouldyouachievethis()
A.byusingtriggers
B.byusingDataPump
C.byusingexternaltables
D.byusinganonymousPL/SQLblocks
第4题
A. They consist of one or more Scheduler programs.
B. They are used to implement dependency scheduling.
C. They are used to implement time-based scheduling.
D.They are used to implement event-based scheduling.
E.None of the above.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!