ocp: sql: question?

From: ks <kshathrya_at_attbi.com>
Date: Sun, 20 Apr 2003 17:34:40 GMT
Message-ID: <QSAoa.13050$Si4.6203_at_rwcrnsc51.ops.asp.att.net>

i came across this in some place.
can someone explain:

Q 1.
The PRODUCT table contains these columns: PRODUCT_ID NUMBER PK
NAME VARCHAR2(30)
LIST_PRICE NUMBER(7,2)
COST NUMBER(7,2) You logged on to the database to update the PRODUCT table. After your session began, you issued these statements: INSERT INTO product VALUES(4,'Ceiling Fan',59.99, 32.45); INSERT INTO product VALUES(5,'Ceiling Fan',69.99,37.20); SAVEPOINT A;
UPDATE product SET cost = 0;
SAVEPOINT B;
DELETE FROM product WHERE UPPER(name) = 'CEILING FAN'; ALTER TABLE product ADD qoh NUMBER DEFAULT 10; ROLLBACK TO B;
UPDATE product SET name = 'CEILING FAN KIT' WHERE product_id = 4;

Then you exit iSQL*Plus. Which of the statements you issued were committed?

A. only the INSERT statements
B. only the INSERT statements and the first UPDATE statement
C. the INSERT statements, the first UPDATE statement, and the DELETE

statement
D. all of the DML operations
E. none of the DML operations

Ans: D

--
regards,
ks

Received on Sun Apr 20 2003 - 19:34:40 CEST