Question:Consider the following SQL statement:
UPDATE employees SET first_name = 'John'
WHERE emp_id = 1009;
COMMIT;

What happens when a user issues the COMMIT in the above SQL statement? 

A The server process places the commit record in the redo log buffer 
B Log Writer (LGWR) writes the redo log buffer entries to the redo log files and data files 
C The user process notifies the server process that the transaction is complete 
D The user process notifies the server process that the resource locks can be released 

+ Answer
A 

+ Report

Md. Habib Ullah

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description