C2090-730 Online Practice Questions and Answers

Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?

A. REVOKE SELECT FROM user2 ON TABLE org.tab1

B. REVOKE SELECT ON TABLE org.tab1 FROM user2

C. REVOKE READ ACCESS FROM user2 ON TABLE org.tab1

D. REVOKE READ ACCESS ON TABLE org.tab1 FROM user2

What does the following statement do?

GRANT REFERENCES (col1, col2) ON TABLE table1 TO user1 WITH GRANT OPTION

A. Gives user USER1 the ability to refer to COL1 and COL2 of table TABLE1 in queries, along with the ability to give this authority to other users and groups.

B. Gives user USER1 the ability to refer to COL1 and COL2 of table TABLE1 in views, along with the ability to give this authority to other users and groups.

C. Gives user USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the parent key of the constraint.

D. Gives user USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the foreign key of the constraint.

Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?

A. REVOKE ACCESS ON DATABASE FROM USER bob

B. REVOKE CONNECT ON DATABASE FROM USER tom

C. REVOKE tom FROM ACCESS ON DATABASE BY USER bob

D. REVOKE tom FROM CONNECT ON DATABASE BY USER bob

Which of the following DB2 objects can be referenced by an INSERT statement to generate values for a column?

A. Sequence

B. Identity column

C. Trigger

D. Table function

A sequence was created with the DDL statement shown below:

CREATE SEQUENCE my_sequence CACHE 10 ORDER

The following statements are successfully executed in sequence through separate database connections:

CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO :con1hvar CONNECTION2 - VALUES

NEXT VALUE FOR my_sequence INTO :con2hvar CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO :con1hvar What is the current value of the :con1hvar host variable?

A. 2

B. 3

C. 11

D. 30

Given the following queries:

SELECT c1 FROM tab1; SELECT c1 FROM tab2;

Which of the following set operators can be used to produce a result data set that contains only records that are not found in the result data set produced by each query after duplicate rows have been eliminated?

A. UNION

B. INTERSECT

C. EXCEPT

D. MERGE

If the following SQL statements are executed:

CREATE TABLE tab1 (id SMALLINT NOT NULL PRIMARY KEY, name VARCHAR(25));

CREATE TABLE tab2 (empid SMALLINT,

weekno SMALLINT,

payamt DECIMAL(6,2),

CONSTRAINT const1 FOREIGN KEY (empid)

REFERENCES taba(id) ON UPDATE NO ACTION);

Which of the following statements is true?

A. Only values that exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2

B. The updating of values in the ID column of table TAB1 is not allowed

C. Only values that do not already exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2

D. When values that exist in the ID column of table TAB1 are updated, corresponding values in the EMPID column of table TAB2 are updated as well

The following triggers were defined for table TAB1 in the order shown:

CREATE TRIGGER trig_a AFTER UPDATE ON tab1 FOR EACH ROW UPDATE sale_tab SET sale_date = CURRENT DATE; CREATE TRIGGER trig_b AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE invoice_tab SET invoice_date = CURRENT DATE; CREATE TRIGGER trig_c AFTER UPDATE ON tab1 FOR EACH ROW CREATE TRIGGER trig_d AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE billing_tab SET billing_date = CURRENT DATE;

If an event occurs that causes all of them to activate, which trigger will be activated first?

A. TRIG_A

B. TRIG_B

C. TRIG_C

D. TRIG_D