The DDL statement is used to create table T1:
CREATE TABLEt1 (
c1 INTEGER,
c2 INTEGER NOT NULL,
c1 DECIMAL(11,2),
c4 TIMESTAMP WITH DEFAULT CURRENT TIMESTAMP
)
Which of the following INSERT statements will execute successfully?

• A.INSERT INTO t1 VALUES (100)
• B.INSERT INTO t1 (c1, c2) VALUES (100)
• C.INSERT INTO t1 (c1, c3) VALUES ('100', '100.00')
• D.INSERT INTO t1 (c2, c3) VALUES (100, 100.00), (101, 101)

Comment: *

Name: *

Email: *

Verification: *

Which method for restricting data access relies on security labels and security policies to control what data a user can access?

• A.Authentication
• B.Authorities and privileges
• C.Label-based access control
• D.Row and column access control

Comment: *

Name: *

Email: *

Verification: *

Consider the following sequence of events:
Eddie grants SELECT WITH GRANT OPTION privilege to Mike.
Mike grants SELECT privilege to Jeff.
Eddie revokes SELECT privilege from Mike.
What will happen to Jeff's SELECT privilege?

• A.Jeff's SELECT privilege will be revoked
• B.Jeff's SELECT privilege will be retained
• C.Jeff's SELECT privilege will be retained only if he has ACCESSCTRL authority
• D.Jeff's SELECT privilege will be retained only if Eddie has ACCESSCTRL authority

Comment: *

Name: *

Email: *

Verification: *

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

• A.DATAACESS
• B.SQLADM
• C.ACCESSCTRL
• D.CONNECT

Comment: *

Name: *

Email: *

Verification: *

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.The REVOKE statement succeeds with no effect
• B.All privileges are granted to user MYUSER on MYTABLE
• C.An entry is mane in SYSCAT.TABAUTH
• D.An error is returned

Comment: *

Name: *

Email: *

Verification: *