Which part of a database trigger determines the number of times the trigger body executes?
A. trigger type
B. trigger body
C. trigger event
D. trigger timing
查看答案
Given a function CALCTAX CREATE OR REPLACE FUNCTION calctax (sal NUMBER) RETURN NUMBER IS BEGIN RETURN (sal * 0.05); END; If you want to run the above function from the SQL*Plus prompt, which statement is true?
A. You need to execute the command CALCTAX(1000);.
B. You need to execute the command EXECUTE FUNCTION calctax;.
C. You need to create a SQL*Plus environment variable X and issue the command :X:= CALCTAX(1000);.
D. You need to create a SQL*Plus environment variable X and issue the command EXECUTE :X := CALCTAX;.
E. You need to create a SQL*Plus environment variable X and issue the command EXECUTE :X := CALCTAX(1000);
When a program executes a SELECT ... FOR UPDATE statement, Which of the following must it do?
A. Execute a COMMIT or ROLLBACK to end the transaction, even if no data has changed
B. Change the data values in the rows selected, then commit or rollback to end the transaction
C. Execute a COMMIT or ROLLBACK to end the transaction , but only if data has changed
D. Because a transaction doesn't start until data has actually changed, no COMMIT or ROLLBACK needs to executed
Which single-row function could you use to return a specific portion of a character string?
A. INSERT
B. SUBSTR
C. LPAD
D. LEAST
Which function() accept arguments of any datatype?Select all that apply.(10分)
A. SUBSTR
B. NVL
C. ROUND
DECODE
E. SIGN
微信支付 
支付宝支付