C2090-616 Table Practice Questions

What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE? REVOKE SELECT ON TABLE mytable FROM USER myuser

• AA. An error is returned
• BB. An entry is made in SYSCAT.TABAUTH
• CC. The REVOKE statement succeeds with no effect
• DD. All privileges are granted to user MYUSER on MYTABLE

Below are the SQL statements a DBA is planning to execute on a database: CREATE TABLE t1 (name VARCHAR (1)); INSERT INTO t1 VALUES (‘A’), (‘B’), (‘C’), (‘D’); ALTER TABLE t1 ALTER COLUMN name SET DATA TYPE INT; What will be the outcome of the last statement?

• AA. The statement will fail due to variable length character error
• BB. The statement will fail due to an incompatible data type error
• CC. The statement will execute successfully and it deletes the character data
• DD. The statement will execute successfully and it internally converts the character data into ASCII numbers

Which of the following commands can undo the work done by the current unit of work executing UPDATE statements on a table?

• AA. COMMIT
• BB. SAVEPOINT
• CC. ROLLBACK WORK
• DD. UPDATE TERMINATE