QUESTION: 5

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

An error is returned
An entry is mane in SYSCAT.TABAUTH
The REVOKE statement succeeds with no effect
All privileges are granted to user MYUSER on MYTABLE

Answer(s): C

Reveal Solution Next Question

QUESTION: 6

A user executes the following statements:
REATE TABLE t1 (c1 INT, c2 INT);
CREATE ALIAS a1 FOR t1;
What will be the result if the user executes the following statement? DROP ALIAS a1;

The alias A1 will be dropped
The table T1 will be dropped
Both T1 and A1 will be dropped
Nothing, the statement will result in an error

Answer(s): A

Reveal Solution Next Question

QUESTION: 7

Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?

NOT NULL
Foreign key
Primary key
Informational constraint

Answer(s): C

Reveal Solution Next Question

QUESTION: 8

Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?

A ROLLBACK command executed just after the COMMIT command cancels that COMMIT
Save points defined during transaction T1 are released only if there is a RELEASE SAVEPOINT command executed after the COMMIT command
It finishes the current T1 unit of work and a new one is initiated, however it is possible to ROLLBACK to the latest SAVEPOINT before COMMIT
It finishes the current T1 unit of work and a new one is initiated. All changes made by UPDATE and DELETE commands during unit of work T1 are committed

Answer(s): D

Reveal Solution Next Question

Free C2090-616 Exam Braindumps (page: 2)

QUESTION: 5

QUESTION: 6

QUESTION: 7

QUESTION: 8