Summer Sale - Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpt65

C2090-616 Questions and Answers

Note! Following C2090-616 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

C2090-616 Questions and Answers

Question # 6

Which of the following isolation levels most reduces concurrency and is most likely to cause lock escalations?

A.

Read Stability

B.

Cursor Stability

C.

Repeatable Read

D.

Uncommitted Read

Full Access
Question # 7

Which of the following SQL statements will remove all rows from the table T1? (Choose two.)

A.

DELETE FROM t1

B.

DELETE* FROM t1

C.

DELETE* TABLE t1

D.

TRUNCATE TABLE t1 IMMEDIATE

E.

TRUNCATE TABLE t1

Full Access
Question # 8

Which of the following authorities is sufficient for connecting to a database?

A.

SQLADM

B.

CONNECT

C.

DATAACESS

D.

ACCESSCTRL

Full Access
Question # 9

What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE?

REVOKE SELECT ON TABLE mytable FROM USER myuser

A.

An error is returned

B.

An entry is mane in SYSCAT.TABAUTH

C.

The REVOKE statement succeeds with no effect

D.

All privileges are granted to user MYUSER on MYTABLE

Full Access