databases Online Quiz - 72
Description: databases Online Quiz - 72 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Given the table, Customer contain the following data Customer Table: Product-ID Quantity 1 5 2 3 3 4 The following sequence of statement performed at the single unit of work: UPDATE Customer SET Quantity = 3 WHERE Product-ID = 1; SAVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE Customer SET Quantity = 5 WHERE Product-ID = 3; INSERT INTO Customer VALUES (5, 20); SAVEPOINT s2 ON ROLLBACK RETAIN CURSORS; INSERT INTO Customer VALUES (4, 10); ROLLBACK TO SAVEPOINT s1; INSERT INTO Customer VALUES (6, 10); INSERT INTO Customer VALUES (7, 15); COMMIT;
In which situation is shredding XML data recommended?
Which of the following supports the XML data type?
Which datatype stores data outside Oracle Database?
The following statements are executed: create sequence my_seq; select my_seq.nextval from dual; select my_seq.nextval from dual; rollback; select my_seq.nextval from dual;
What can be used to optimize the performance of simple SQL?
If the number of leaf blocks of index , scanned is less than 5000 then degree of parallelismis 2?