You create the following table and execute the following code:
Which statement is true about the outcome of the above code?
A.
It executes successfully and all the rows are updated.
B.
It gives an error but saves the inserted rows and the update to the first row.
C.
It gives an error but saves the inserted rows; however, no rows are updated.
D.
It gives an error and all the data manipulation language (DML) statements are rolled back
Explanation:
Answer B is correct. second update raises exception because value length exceeds the column length.
bookkeper||’ (Senior)’> varchar2(18)
19>18
“B” is correct.
select * from emp_temp
/
DEPTNO JOB
—— ——————
10 Cleark (Senior)
20 Bookkeeper
30 Analyst
B
A is an answer I tested it
You should read this Oracle Docs answer and explanation. It refers to this exact question.
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/tuning.htm#BCGDBDAI
as Vladmir_K has posted below.
The answer is B without a doubt.
A is the answer
DEPT_NO JOB
10 Clerk(Senior)
20 Bookkeeper(Senior)
30 Analyst(Senior)
Have you tried with a space before (Senior)??
A
Answer is B. See the same example – http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/tuning.htm#BCGDBDAI
B
B
b