consider this sql statement update employees set firstname john where empid..., Oracle 10g Database Administration, Databases

Test
- Model Test
Index

Question:Consider this 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

/67

+ AnswerC

+ Report

Descriptive on Oracle 10g Database Administration Ebook

Total Preview: 1149

Question:Consider this 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

C