Click the Exhibit button.
INSERT INTO table1 VALUES(1,11);
INSERT INTO table1 VALUES(2,11);
SAVEPOINT sp1 ON ROLLBACK RETAIN CURSORS;
INSERT INTO table1 VALUES(3,11);
INSERT INTO table1 VALUES(4,11);
INSERT INTO table1 VALUES(5,11);
SAVEPOINT sp2 ON ROLLBACK RETAIN CURSORS;
INSERT INTO table1 VALUES(6,11);
INSERT INTO table1 VALUES(7,11);
ROLLBACK TO SAVEPOINT sp2;
INSERT INTO table1 VALUES(8,11);
SAVEPOINT sp3 ON ROLLBACK RETAIN CURSORS;
INSERT INTO table1 VALUES(9,11);
ROLLBACK;
Application1 executes the SQL statements shown in the exhibit against table TABLE1 in manual
commit mode. How many rows will be inserted in TABLE1?

• A. 9
• B. 7
• C. 5
• D. 0

Click the Exhibit button. PRODUCTS ID NAME QUANTITY
1 Orange juice 30
2 Milk 25 Given the table shown in the exhibit.
Which values will be returned by query shown below?
SELECT XMLGROUP(
id as "Id",name as "Name",quantity as "Quantity"
OPTION ROW "Product") as Products
FROM products

• A.
  1Orange juice30
  2Milk25
  
• B.
  1Orange juice30
  2Milk25
  
• C. 1Orange juice30
  2MIlk25
• D.
  1Orange
  juice30 2Milk25

Which SQL procedure will retrieve all the rows from table T1 and make those rows available to the invoker as a result set?

• A. CREATE PROCEDURE proc1() DYNAMIC RESULTS SET 1 LANGUAGE SQL SELECT * FROM t1
• B. CREATE PROCEDURE proc1()
  DYNAMIC RESULTS SET 1
  LANGUAGE SQL
  BEGIN
  DECLARE c1 CURSOR WITH RETURN FOR SELECT * FROM t1;
  OPEN c1;
  END
• C. CREATE PROCEDURE proc1()
  DYNAMIC RESULTS SET 1
  LANGUAGE SQL
  RETURN (SELECT * FROM t1)
• D. CREATE PROCEDURE proc1()
  DYNAMIC RESULTS SET 1
  LANGUAGE SQL
  BEGIN
  DECLARE c1 CURSOR FOR SELECT * FROM t1;
  RETURN c1;
  END

The table PERSON is declared as shown below:
CREATE TABLE xmltest (id BIGINT, info XML)
What is the column type for the result of the following statement?
SELECT t.* FROM
xmltest,
XMLTABLE (
'$INFO/question'
) AS t

• A. BLOB
• B. XML
• C. VARCHAR
• D. CLOB

A database contains a table and a view declared as shown below:
CREATE TABLE s1.t1 ( c1 INTEGER, c2 CHAR(20) );
CREATE VIEW s1.v1 AS SELECT * FROM s1.t1;
A system administrator successfully executes the following code:
GRANT CONNECT, IMPLICIT_SCHEMA ON DATABASE TO user1;
GRANT INSERT ON TABLE s1.t1 TO user1;
GRANT CONTROL ON s1.v1 TO user1;
Which SQL statement does user USER1 have privileges to execute?

• A. SELECT * FROM s1.t1 WHERE c2 < 100
• B. CREATE VIEW user1.v2 AS SELECT * FROM s1.v1
• C. CREATE PUBLIC ALIAS a1 FOR s1.v1
• D. UPDATE s1.t1 SET c1 = 2 WHERE c1 IS NULL